How to export a table from SAS software to Excel

0

Entering edit mode

2.8 years ago

Fede_Santos95 ▴ 10

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 • 774 views

ADD COMMENT • link updated 2.8 years ago by Pierre Lindenbaum 161k • written 2.8 years ago by Fede_Santos95 ▴ 10

0

Entering edit mode

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

ADD REPLY • link 2.8 years ago by Sej Modha 5.3k

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 • link 2.8 years ago by Pierre Lindenbaum 161k

Login before adding your answer.