Date:         Thu, 22 Oct 1998 19:49:14 GMT
Reply-To:     JP <cruguel@DMS.UMONTREAL.CA>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         JP <cruguel@DMS.UMONTREAL.CA>
Organization: McGill University Computing Centre
Subject:      Re: How to overcome 16384 obs exporting limit?

>
> On the second question, that is not a function of SAS.  That is a limit
of
> older versions of Excel.  In other words, I suspect that SAS exported
your
> full dataset. However, Excel only imported the first 16k rows, since
older
> versions of Excel can only handle that many rows.  Excel 97 increases
that
> limit to 64k, so if you have less than that number of observations,
you'll
> need to upgrade to E97 if you want to use Excel.  Otherwise, you are out
of
> luck using Excel for your full dataset.
>
What you can do is export it as a DBF file, which can be read in EXCEL,
whatever the number of observations (I remember you can overpass the 16k
limit but up to ?, you still should make sure you get all your
observations).
YOU MUST NOT then save your dbf file as an XLS file, as it will save only
the firts 16k or 64k obs.
 
Definitely, Excel is not the right tool to manipulate big dataset (any
dataset in my personal opinion).
 
JP