Hi,

This is really driving me mad. I have large SAS data set which I need
to write to excel, unfortunately,
I can't work out (or my version of SAS doesn't have the ability) to
write to a single .xlsx file.

So, I would like to split the dataset up into x4 smaller tables. The
variables look like:

DATE stock1000 stock10010 stock10015 etc etc

where everything after DATE is always indexed stockX but are
necessarily in order.

Simply, how can I check the width of the table and select the first,
say, 200 variables, then
move on to the next 2000 variables etc until the end.

I'm sure this should be easy but I really cannot work it out,
Many thanks,

On Mar 21, 10:57=A0am, jediwhelan <jediwhe...@googlemail.com> wrote:
> Hi,
>
> This is really driving me mad. I have large SAS data set which I need
> to write to excel, unfortunately,
> I can't work out (or my version of SAS doesn't have the ability) to
> write to a single .xlsx file.
>
> So, I would like to split the dataset up into x4 smaller tables. The
> variables look like:
>
> DATE stock1000 stock10010 stock10015 etc etc
>
> where everything after DATE is always indexed stockX but are
> necessarily in order.
>
> Simply, how can I check the width of the table and select the first,
> say, 200 variables, then
> move on to the next 2000 variables etc until the end.
>
> I'm sure this should be easy but I really cannot work it out,
> Many thanks,


Noted in the SAS Documentation:

http://support.sas.com/kb/37/612.html

They thoughtfully provide a program to do a workaround.


HTH,
Reeza