topic Split more than 5 GB datasets into Excel 2003 version in SAS Procedures

Split more than 5 GB datasets into Excel 2003 version

rohit_prajapati — Mon, 17 Sep 2012 06:58:46 GMT

Hi ALL,

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 ?

Reragds,

Rohit

LinusH — Mon, 17 Sep 2012 07:17:00 GMT

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?

Ksharp — Mon, 17 Sep 2012 08:06:36 GMT

Check it out. you can search it at support.sas.com

Ksharp

ballardw — Mon, 17 Sep 2012 15:32:19 GMT

Here is an example on how to get the number of observations:

proc sql;

select nobs

from dictionary.tables

where libname='SASHELP' and memname= 'ZIPCODE';

quit;

The nobs could be selected into a macro variable for use elsewhere.