R help - Feb 2011 - convert the sas file into csv in R

i am trying to convert sas file into csv. I used write.csv(a,
file="cool.csv") but nothing come out. i don't know why. Thanks.


library(Hmisc)
a<- sasxport.get("C:\\Users\.....")
write.csv(a, file="cool.csv")
-- 
View this message in context:
http://r.789695.n4.nabble.com/convert-the-sas-file-into-csv-in-R-tp3311769p3311769.html
Sent from the R help mailing list archive at Nabble.com.

> -----Original Message-----
> From: r-help-bounces at r-project.org [mailto:r-help-bounces at r-
> project.org] On Behalf Of yf
> Sent: Thursday, February 17, 2011 2:35 PM
> To: r-help at r-project.org
> Subject: [R] convert the sas file into csv in R
> 
> 
> i am trying to convert sas file into csv. I used write.csv(a,
> file="cool.csv") but nothing come out. i don't know why.
Thanks.
> 
> 
> library(Hmisc)
> a<- sasxport.get("C:\\Users\.....")
> write.csv(a, file="cool.csv")
What do you mean "nothing come out"?  Where did you look for the file?
It should have been written to your current working directory.  You might try
specifying a complete path so you know where you expect to find the CSV file.

Dan

Daniel J. Nordlund
Washington State Department of Social and Health Services
Planning, Performance, and Accountability
Research and Data Analysis Division
Olympia, WA 98504-5204

Hi yf,

On Thu, Feb 17, 2011 at 2:35 PM, yf <chang648 at umn.edu>
wrote:
>
> i am trying to convert sas file into csv. I used write.csv(a,
> file="cool.csv") but nothing come out. i don't know why.
Thanks.
>
>
> library(Hmisc)
> a<- sasxport.get("C:\\Users\.....")
Let's back up a little bit.  What type of file are you trying to read
into R with this statement?  Did you make sure it was a SAS XPORT
format?  SAS files often come in the native .sas7bdat format, which R
cannot read (it is proprietary).

At this point, try taking a look at your object "a".  At the console
you can type:

class(a)
str(a)

and see what the output says.  Is it a data frame?  A list? or .... ?
Even if the data is read into R properly, write.csv() may not be able
to properly write all classes of data.  You might also try:

print(a)

to make sure there is actually data to be written and it is not just
an empty dataset.
> write.csv(a, file="cool.csv")
Assuming "a" is a matrix or data frame or can readily be coerced to
such, this line should be fine.

Just as a note, if it is a .sas7bdat file, Revolution Analytics now
provides software that can read it into R.  There is normally a
charge, but it is free for academics, which, judging by your email
address, you are.
http://www.revolutionanalytics.com/news-events/news-room/2011/revolution-analytics-unlocks-sas-data-for-r.php

Cheers,

Josh
> --
> View this message in context:
http://r.789695.n4.nabble.com/convert-the-sas-file-into-csv-in-R-tp3311769p3311769.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
-- 
Joshua Wiley
Ph.D. Student, Health Psychology
University of California, Los Angeles
http://www.joshuawiley.com/