Displaying 1 result from an estimated 1 matches for "mmpilatesthosp".
2012 Jan 23
1
Extracting data from SQL Server based on R parameters
...example I have a list of unique patient IDs with latest
hospitalisation date which I've processed in R. I need to join this data to
other tables in SQL server. The tables in SQL server are too large to import
without reducing the number of records. I do not have write access to the
SQL server.
mMPILatestHosp #this is my data frame of patients with unique IDs (ID) and
most recent date (EVENDate)
The select query is easy
query<-"select * (plus columns in mMPILatestHosp) from Pharm2011
where....#This is where I want to insert mMPILatestHosp$ID in the where
clause"
I'm new to R so woul...