Problem Open Excel file after proc export

Hazou — Tue, 05 May 2020 14:00:02 GMT

Hello,

I have a problem when i want to open Excel File with many sheets after a proc export on server.

Sometimes its works, sometimes not.

After analyse, for Data < 5500 rows, i can't open the excel file, for the data > 5500 rows, it's working.

Do you have a idea ? Thanks a lot.

ps : On server, i can't use XLSX, EXCEL, EXCEL5.

%MACRO Export_ness (data,table, sheet);
PROC EXPORT DATA = &data.
OUTFILE = "/..../&table..xlsx"
DBMS = xlsx REPLACE ;
SHEET = "&sheet." ;
RUN ;
%mend;

%Export_ness (test,FIILE, sheet1);
%Export_ness (test,FILE, sheet2);

Best Regards

Hazou

Re: Problem Open Excel file after proc export

ChrisNZ — Thu, 04 Jun 2020 22:38:47 GMT

> On server, i can't use XLSX, EXCEL, EXCEL5.

Yet the code uses XLSX

> Sometimes its works, sometimes not.

What does that mean? Errors in the log? missing data?

Show us the log.

topic Problem Open Excel file after proc export in SAS Procedures

Problem Open Excel file after proc export

Re: Problem Open Excel file after proc export