09-17-2012 02:58 AM
i want to split the more than 5 GB data into Excel 97-2003 cversion(67535 records per sheet) sheetwise.
Even I am not able to get the count of abservation in the data as dataset size is more than 5 GB.
Can anyone help me on this with the running fastest and short code ?
09-17-2012 03:17 AM
There are several ways of doing this.
But this sounds very odd to me. Excel isn't the tool for storing large databases. What is the business requirement?
09-17-2012 11:32 AM
Here is an example on how to get the number of observations:
where libname='SASHELP' and memname= 'ZIPCODE';
The nobs could be selected into a macro variable for use elsewhere.