|Date: ||Mon, 11 Feb 2002 13:01:42 -0700|
|Reply-To: ||Margaret Menache <MMenache@SALUD.UNM.EDU>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||Margaret Menache <MMenache@SALUD.UNM.EDU>|
|Subject: ||exporting excel files|
|Content-Type: ||text/plain; charset=US-ASCII|
I'm trying to export data from sas into excel spreadsheets and seem to
have run into some glitches.
We're running sas 8.2 on windows 2000. One machine has office97
but the other has office2000.
1. Is it possible to write multiple pages to the same spreadsheet?
2. If I export using EXCEL2000 (the wizard option of 97/2000), then
I can read the data just fine in excel97 but find that missing values
are not treated properly in excel2000. Rather than having a blank
field all values in a row get shifted left.
If there's been discussion on these issues already, just point me to
Thanx for your help.