BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
LTY
Calcite | Level 5 LTY
Calcite | Level 5

Hi everyone, I would like to output a dataset to the folder in same server but in excel format. I am able to output to the same server in sas format using below code. Is there anyone can help to change it to excel format? Thank you.

libname out "/sasdata/data/xxxxxxx";
data out.custlist;
set work.custlist;
run;

1 ACCEPTED SOLUTION

Accepted Solutions
andreas_lds
Jade | Level 19

Have you tried using proc export?

 

proc export data=work.custlist dbms=xlsx file="..." replace;
run;

or just change the libname-statement to use xlsx-engine, the path has to point to a file.

View solution in original post

1 REPLY 1
andreas_lds
Jade | Level 19

Have you tried using proc export?

 

proc export data=work.custlist dbms=xlsx file="..." replace;
run;

or just change the libname-statement to use xlsx-engine, the path has to point to a file.