| Date: | Mon, 27 Oct 2008 15:37:51 -0400 |
|---|
| Reply-To: | Bucher Scott <SBucher@SCHOOLS.NYC.GOV> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Bucher Scott <SBucher@SCHOOLS.NYC.GOV> |
|---|
| Subject: | Re: Proc Export question |
|---|
|
| In-Reply-To: | A<912ED977DA302D4F889A8DD10D5544DE048132D4@afhe-ex.afhe.ualberta.ca> |
|---|
| Content-Type: | text/plain; charset="us-ascii" |
|---|
I think Excel has a limit of 256 columns. You could export to two
different sheets, each with 250 variables.
PROC EXPORT
DATA=dsn (keep = var1--var250)
OUTFILE=" "
DBMS=xls;
SHEET='sheet1';
RUN;
If you have Excel 2007, this restriction does not apply, so if you could
export to a csv or tab-delimited file, and then open it in Excel.
-Scott
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Navabi, Alireza
Sent: Monday, October 27, 2008 3:04 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Proc Export question
I am trying to export a SAS dataset of 500 by 500 into Excel. The error
message is: Too many fields defined. Any idea how could this be done?
Thanks
Ali
| 
