Split more than 5 GB datasets into Excel 2003 version

[rohit_prajapati]

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]

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]

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

http://support.sas.com/kb/16/587.html

Ksharp

[ballardw]

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.