Date: Wed, 3 Jan 2001 09:37:11 -0800
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: From SAS to Excel
Content-Type: text/plain; charset="iso-8859-1"
I agree that the DDE method is a far more elegant solution for repeatable
tasks. I have only begun using it lately as my company saw fit to
discontinue my license for SAS/Access to PC Formats. Most of my recent cases
have not involved repeatable tasks - so I use the CSV round-about method.
-----Original Message-----
From: Brucken, Nancy [mailto:Nancy.Brucken@PFIZER.COM]
Sent: Wednesday, January 03, 2001 9:22 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: From SAS to Excel
Besides all of the custom formatting that our clients want (bolding,
italics, centering text over selected columns, etc.), the other reason we've
used DDE rather than creating CSV files is that with DDE, we can dump data
directly into Excel in a single step from within the SAS program. Creating
a CSV file and importing it into Excel is programmatically simpler, but if
you're running the same programs repeatedly, it adds another, manual, step
to what can be an automated process.
Nancy
Nancy Brucken
Clinical Informatics
Pfizer Global Research & Development, Ann Arbor
(734) 622-5767
E-mail address: Nancy.Brucken@pfizer.com
-----Original Message-----
From: Smith, Curtis, Mr, DCAA [mailto:Curtis.Smith@DCAA.MIL]
Sent: Wednesday, January 03, 2001 10:26 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: From SAS to Excel
Most of the problems I have is the way Excel treats the values it reads. If
Excel sees a column of all numbers, it treats it as numeric, even though you
might want to treat the column as character or date. I usually save a CSV
file with an extension of TXT. The in Excel, I File-Open and work through
the import wizard. It's an extra step, but it allows me to specify the
format of each column.
-----Original Message-----
From: Smith, Anne [mailto:anne.smith@SPCORP.COM]
Sent: Wednesday, January 03, 2001 7:06 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: From SAS to Excel
Hi Sas-lers,
Happy New Year and New Millennium!
I have a couple of comments regarding this method, SAS-> CSV -> Excel. This
way is far from the perfect solution either. Dates and character strings
with numbers embedded have not always come through this process as expected.
And I've had to fix various problems at different places such as editing the
data in Excel or actually going back to the sas
program and fixing the data before outputting to CSV file(Comma separated
values)
Anyone else had similar problems with imputing CSV to Excel?
Kind regards,
Anne
| 
