Dear Rxperts.. Was wondering if there is a way in R to read a csv file and generate an XPT file? For some reason the function write.xport() does not seem to work for me.... i get the following error... "error in label.data.frame(df,default=""): length of default same as x A sample dataframe is given below xg2 <- data.frame(aa=runif(10),bb=sample(runif(100),10)) SASformat(xg2$aa) <- 'Numeric2' SASformat(xg2$bb) <- 'Numeric2' label(xg2$aa) <- "test aa" label(xg2$bb) <- "test bb" label(xg2) <- "testa" SAStype(xg2) <- "TestXge" write.xport(xg2,file="A1.xpt") Error in label.data.frame(df, default = "") : length of default must same as x Any suggestions/tips are welcome.. Thanks and regards Santosh
Convert csv to xpt file in R?
3 messages · Nordlund, Dan (DSHS/RDA), Santosh
-----Original Message----- From: R-help [mailto:r-help-bounces at r-project.org] On Behalf Of Santosh Sent: Wednesday, May 06, 2015 8:04 PM To: r-help Subject: [R] Convert csv to xpt file in R? Dear Rxperts.. Was wondering if there is a way in R to read a csv file and generate an XPT file? For some reason the function write.xport() does not seem to work for me.... i get the following error... "error in label.data.frame(df,default=""): length of default same as x A sample dataframe is given below xg2 <- data.frame(aa=runif(10),bb=sample(runif(100),10)) SASformat(xg2$aa) <- 'Numeric2' SASformat(xg2$bb) <- 'Numeric2' label(xg2$aa) <- "test aa" label(xg2$bb) <- "test bb" label(xg2) <- "testa" SAStype(xg2) <- "TestXge" write.xport(xg2,file="A1.xpt") Error in label.data.frame(df, default = "") : length of default must same as x Any suggestions/tips are welcome.. Thanks and regards Santosh
The code above runs without error and produces an xport file on my Win7 64-bit system running R-3.2.0. You haven't told us anything about your OS, version of R, and packages loaded. Have you tried running the code from a fresh start of R after only loading the SASxport package? Dan Daniel J. Nordlund Research and Data Analysis Division Services & Enterprise Support Administration Washington State Department of Social and Health Services
Dear Rxperts.. Thanks for your response. Below is the version on Windows 7 Enterprise (64-bit) OS machine..Yes, I tried SASxport, foreign and Hmisc.. have used SASxport before (not for writing to xpt though) and continue to have the same write to sas transport file issue..
version
_ platform x86_64-w64-mingw32 arch x86_64 os mingw32 system x86_64, mingw32 status major 3 minor 0.2 year 2013 month 09 day 25 svn rev 63987 language R version.string R version 3.0.2 (2013-09-25) Thanks and regards, Santosh On Thu, May 7, 2015 at 8:51 AM, Nordlund, Dan (DSHS/RDA) <
NordlDJ at dshs.wa.gov> wrote:
-----Original Message----- From: R-help [mailto:r-help-bounces at r-project.org] On Behalf Of Santosh Sent: Wednesday, May 06, 2015 8:04 PM To: r-help Subject: [R] Convert csv to xpt file in R? Dear Rxperts.. Was wondering if there is a way in R to read a csv file and generate an XPT file? For some reason the function write.xport() does not seem to work for me.... i get the following error... "error in label.data.frame(df,default=""): length of default same as x A sample dataframe is given below xg2 <- data.frame(aa=runif(10),bb=sample(runif(100),10)) SASformat(xg2$aa) <- 'Numeric2' SASformat(xg2$bb) <- 'Numeric2' label(xg2$aa) <- "test aa" label(xg2$bb) <- "test bb" label(xg2) <- "testa" SAStype(xg2) <- "TestXge" write.xport(xg2,file="A1.xpt") Error in label.data.frame(df, default = "") : length of default must same as x Any suggestions/tips are welcome.. Thanks and regards Santosh
The code above runs without error and produces an xport file on my Win7 64-bit system running R-3.2.0. You haven't told us anything about your OS, version of R, and packages loaded. Have you tried running the code from a fresh start of R after only loading the SASxport package? Dan Daniel J. Nordlund Research and Data Analysis Division Services & Enterprise Support Administration Washington State Department of Social and Health Services