It is certainly possible to segment the data into multiple worksheets.

What tool are you using to move data from SAS to Excel? There are many
possibilities.

However, unless there is some natural grouping which will always yield
subsets of less than 64K observations, the output may not be very
convenient.

What I have done in such a situation is export the complete set to MS
Access, then set up, from Excel, a query against the Access table. Then
the end user can filter or summarize to get useful sets of less than 6K
rows.

On Sun, 28 Nov 2004 07:45:26 -0800, vickey <vickey_d@REDIFFMAIL.COM> wrote:

>hi all
>
>I am exporting a sas dataset to excel file. But Excel has a limitation
>and it can not record more than 65,536 observation.
>My dataset is big, almost 100,000 observations or may be more becase i
>am not sure what will be the data size when i will run the programm
>again.
>After exporing 65536 rows the SAS procedure stops and send an error.
>How can i export all the observations from dataset. What i think is
>that to export the rest of observations to second file once the 1st
>file is full and so on....but i am not able to write the code because
>in my case i don't know how many observations are there in the sas
>datasets and not sure how many xls file need to create.
>
>Can any one please help me?
>
>Thank you
>vickey

Hi Howard

I am not using any tool to export the data i am using a SAS Procedure
named Export. That is a good idea to send the dataset to acess and
then write the query there, but i am working in SAS enviornment only,
and i don't know the access in such a detail. But it is intresting to
learn that and use it.
Thank you for your sugession, it is a kind of a door opener in the
access side for me.

thank you
Vickey