BookmarkSubscribeRSS Feed
sharedobe
Calcite | Level 5

Dear SAS Community,

 

I have been encountering a problem in exporting an excel dataset from SAS.

 

I have a dataset that is needed to be exported monthly.  As time goes by, the number of rows in that dataset grows.

The size of the dataset is usually less than 4,000 KB with around 30,000 rows.

 

 

Sometimes, the dataset can be exported fine in a xlsb format with all the rows that I want. But some other months (maybe by the end of the year when the number of rows grows), it is exported only a few rows of the complete dataset.  However, it doesn't give me any error message. My current solution to this is open the SAS dataset in SAS and export it as a xlsb format manually.

 

Any thoughts about fixing this problem or what causes this problem?

 

I am using the following code to export the dataset

 

PROC EXPORT DATA= myDataset
OUTFILE="&mypath._&Report_Year.&Report_Month..xlsb"
DBMS=EXCEL2007 REPLACE;
SHEET="DATA";
RUN;

 

data _null_; x = sleep(30); run; /*I was hoping putting a Pause may help to resolve the issue */

 

Thank you for your time and your help!

1 REPLY 1
Reeza
Super User

Pause should have no effect on a PROC EXPORT. Try using DBMS=XLSX instead. 

 

Excel2007 is old and I believe had the 65k limit. I think 2010 64 bit is a million rows. 30k shouldn't cause issues though. 

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 686 views
  • 0 likes
  • 2 in conversation