How to export a table from SAS software to Excel
0
0
Entering edit mode
3.4 years ago

Hi guys,

I'm facing with a working problem and I'm quite upset by it!

I've a file created on SAS (I've never used this statistical software until now!!!), in which there's a table with my data.

Now, I've to export this table from the SAS file to an Excel file, in order to analyze these data in R.

I don't know where to start, since I've never used SAS as written before...

I tried to run in SAS (SAS 9.4 TS Level 1M3) the following commands:

proc export
data = my_data
dbms = xlsx
outfile ="C:\Users\Desktop\my_data2.xlsx"

and I found the following error message:

ERROR 202-322: The option or parameter is not recognized and will be ignored.

Could someone help me?? Thank u!

SAS • 973 views
ADD COMMENT
0
Entering edit mode

This is not a bioinformatics-related question as it stands.

ADD REPLY
0
Entering edit mode

Now, I've to export this table from the SAS file to an Excel file, in order to analyze these data in R.

you meant to a comma-separated-value file in order to analyze these data in R. didn't you ?

ADD REPLY

Login before adding your answer.

Traffic: 1925 users visited in the last hour
Help About
FAQ
Access RSS
API
Stats

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.

Powered by the version 2.3.6