| Date: | Mon, 27 Aug 2001 16:01:20 -0500 |
|---|
| Reply-To: | "Smith, Curtis, Mr, DCAA" <Curtis.Smith@DCAA.MIL> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | "Smith, Curtis, Mr, DCAA" <Curtis.Smith@DCAA.MIL> |
|---|
| Subject: | Re: exporting to EXCEL2000 |
|---|
|
| Content-Type: | text/plain; charset="iso-8859-1" |
|---|
Is the file that fails to export of similar size than the others? Are there
more than 65,536 rows to export( Excel's magic limit)?
-----Original Message-----
From: Cornel Lencar [mailto:CLencar@ORMCANADA.COM]
Sent: Monday, August 27, 2001 1:50 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: exporting to EXCEL2000
Hi,
I am cleaning some dirty, dirty data and to have a quick look across my
variables (changes and enhancements) I export the preliminary results into
EXCEL using PROC EXPORT. Everything works fine for saying 10-15 runs. After
that SAS is reporting a successful transfer, but the file in EXCEL, instead
of having 20000KB has only 6 and opening it would close Excel for good. Any
idea will keep the rising tsunami off shore...
Cornel
|
