Date: Fri, 3 Mar 2000 11:33:20 -0800
Reply-To: Richard Ramirez <rramirez@MIDTOWN.NET>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Richard Ramirez <rramirez@MIDTOWN.NET>
Organization: Posted via Supernews, http://www.supernews.com
Subject: Re: sas7 to excel97 question
I was doing research on exporting SAS datasets to Excel when I found a
document stating problems to exporting to Excel97.
Take a look at http://www.sas.com/service/techsup/unotes/V6/E/E611.html
I also found some doco on a patch:
Hope this helps!
Cooke, Lowell wrote in message
> I am writing to an EXCEL97 spreadsheet using SAS7. Input is a sas
> data set with K observations. If i set K to less than 1300 then 1300
> appear in the spreadsheet. If i make K greater than or equal to 1300
>then nothing appears in spreadsheet and nothing in the log to indicate an
>error of any sort. In the log there is a message that says K observations
> written to spreadsheet regardless of what i set K to. The sas data set is
> just something i made up with K observations and 13 columns of numeric
> The code works ok in sas612.I have set K to as high as 15500 and all
> observations get written. Any ideas or help as to what is going on in
>SAS7? thanks for your help.