Date:         Fri, 14 Mar 2008 11:45:12 -0400
Reply-To:     Chang Chung <chang_y_chung@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Chang Chung <chang_y_chung@HOTMAIL.COM>
Subject:      Re: creating excel file beyond the size of an excel worksheet
Comments: To: Mary H <mlhoward@AVALON.NET>

On Fri, 14 Mar 2008 10:33:07 -0500, Mary <mlhoward@AVALON.NET> wrote:

>You could just create a variable within your data set:
>
>data set2;
>   set set1;
>   obsnum + 1;
>
>data set3;
>    set set2;
>    where obsnum < 60000;
>
>data set4;
>     set set2;
>     where obsum >= 60000;
>run;
>
>Then export the new data sets.

hi,
this is just amazing! with such a short code, mary managed to read the
entire data three times and write twice, when probably reading it once will
suffice. with this kind of coding, no amount of performance tweaking on the
server could keep it from crawling... no wonder sys admins love sas users... :-)
cheers,
chang