Excel export

[Lucasmarques94]

Boa tarde,

tenho duas tabelas e gostaria de gerar/exportar um arquivo único, em que, cada tabela ficasse em uma aba do excel.

Como fazer este procedimento?

[PaigeMiller]

ods excel file="myexcelfile.xlsx" options(sheet_name='Table 1');
proc print data=table1;
run;
ods excel options(sheet_name='Table 2');
proc print data=table2;
run;
ods excel close;

[Lucasmarques94]

Está aparecendo o seguinte erro: ERROR insuficiente authorization to access

[PaigeMiller]

Try creating the Excel file in a folder where you do have write permission/access.

[Kurt_Bremser]

Use an absolute path (starts with a drive letter or backslash in Windows, or at root in UNIX) which points to a location where you have write permission.

if you just need it temporarily (e.g. to attach the file to email), you can use the WORK location:

%let loc = %sysfunc(pathname(work));

ods excel file="&loc./myexcelfile.xlsx" options(sheet_name='Table 1');

/* rest of code */