topic Output dataset to same server with excel format in New SAS User

Output dataset to same server with excel format

LTY — Fri, 26 Feb 2021 06:58:35 GMT

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;

Re: Output dataset to same server with excel format

andreas_lds — Fri, 26 Feb 2021 07:42:00 GMT

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.