topic Excel export in SAS Enterprise Guide

Excel export

Lucasmarques94 — Sat, 15 Jun 2024 16:14:07 GMT

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?

Re: Excel export

PaigeMiller — Sat, 15 Jun 2024 16:35:54 GMT

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;

Re: Excel export

Lucasmarques94 — Sat, 15 Jun 2024 17:34:15 GMT

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

Re: Excel export

PaigeMiller — Sat, 15 Jun 2024 20:54:01 GMT

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

Re: Excel export

Kurt_Bremser — Sun, 16 Jun 2024 13:28:40 GMT

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 */