How to export data to Microsoft Excel using the SAS/ACCESS XLSX engine?

[zihdonv19]

Could someone give an example (simple coding) of it?

Thanks!

[ed_sas_member · Accepted solution]

Hi @zihdonv19 

here is an example:

libname xout xlsx "Path/file.xlsx";

Data xout.mydata;
Set work.mydata;
Run;

Libname xout clear;

I also share an interesting resource: https://www.lexjansen.com/nesug/nesug13/89_Final_Paper.pdf

Best,

[zihdonv19]

Thanks! it is helpful.

[ed_sas_member]

You’re welcome 😊