[R] Meaning of error message when exporting to MS Excel

Hi, I’m attempting to export data (split into multiple files from one large dataset) from R to excel using the excel.link package. The code for export is as follows: for(i in practicesNN){ #Create relevant data for input #Separate out all parts of data – PracticeName is removed from example d

Re: [R] Install of R-2.15.1 for Windows (64 bit) on application server

Thanks, will go ahead -- View this message in context: http://r.789695.n4.nabble.com/Install-of-R-2-15-1-for-Windows-64-bit-on-application-server-tp4644042p4644829.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.org

[R] Install of R-2.15.1 for Windows (64 bit) on application server

Hi, I'm looking to install ‘R’ on an application server which we can give plenty of resource to, and actually run the program from a terminal server. Do you know if this is possible, and if so are there any special installation instructions required? Many thanks, D -- View this message in co

[R] What does "package 'RDCOMClient' is not installed for 'arch=x64' " exactly mean?

Hi, I'm trying to use the excel.link package to write data to excel spreadsheets. I've installed the RDCOMClient package as required but get the error: package 'RDCOMClient' is not installed for 'arch=x64' I'm on Rx64 2.13.0. I assume it means the RDCOMClient package does not work on the x64 ve

[R] Converting strings into data frame column names

Hi all, I want to loop through a series of data frames and append them into one data frame, however I do not want all columns of the original data frames to be in the new data frame. I have the following code: phList<-c('ph2010','ph2009','ph2008','ph2007','ph2006') #Name of original data frames

[R] Extracting data from SQL Server based on R parameters

Hi, Can you extract data from a SQL server table based on parameters already in R? For 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 wi

Re: [R] Extracting rows with latest date from a data frame

Thanks Petr, one line of code - awesome. -- View this message in context: http://r.789695.n4.nabble.com/Extracting-rows-with-latest-date-from-a-data-frame-tp4305651p4319303.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-proj

[R] Extracting rows with latest date from a data frame

Hi, I have a list of unique patient IDs which I want to run against a dataframe of unique patient IDs with dates. There are multiple date instances against unique IDs. The end result I wish is that I have a list of IDs (which are unique) with the latest date. I have begun with using test data (but

Re: [R] Extracting Data from SQL Server

a.diag03 = b.[ICD-10 Codes] I am not sure why your table name CVD_ICD10 has a suffix $. From: Jeff Newmiller <[hidden email]> To: dthomas <[hidden email]>; [hidden email] Sent: Tuesday, 10 January 2012, 8:00 Subject: Re: [R] Extracting Data from SQL Ser

[R] Extracting Data from SQL Server

Hi, I am new to R (and rusty on SQL!) and I'm trying to extract records from a SQL server database. I have a table of patient records (LoadPUS) which have three code columns which i want to evaluate against a list of particular codes (CVD_ICD$ table). Given the size of the patient table I want to