LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (October 2004, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Wed, 20 Oct 2004 19:10:59 -0400
Reply-To:     Arthur Tabachneck <art297@NETSCAPE.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Arthur Tabachneck <art297@NETSCAPE.NET>
Subject:      Re: Sas to Excel questions

Mike,

My suggested solution will only work in SAS9 (I'm running SAS 9.12). As Ya pointed out, this feature alone might make SAS9 worth the effort of upgrading, although there are a number of other good reasons.

On the Import side, the problem Greg mentioned, is also corrected in SAS9. One of Import's new options is the keyword "MIXED". If set to "no", the problem Greg mentioned will still exist. However, if set to "yes", SAS will correctly import a column that contains both character and numeric entries.

Art ------- "Ross, Michael D" <michael.ross@ASTRAZENECA.COM> wrote in message news:22F95BC7C879D211AB120008C7A43B8008B971E2@usuwphmsx01.usuwd.astrazeneca.net... > Hi There, > The "sheet" logic doesn't seem to be working in the following. Any > suggestions? > > Tx. > > data one; > input a $ b $ c $ ; > datalines; > aaaaaaaa bbbbbbbb cccccccc > ;run; > data two; > input d $ e $ f $ ; > datalines; > dddddddd eeeeeeee ffffffff > ; > run; > data three; > input g $ h $ i $ ; > datalines; > gggggggg hhhhhhhh iiiiiiii > ; > run; > > PROC EXPORT DATA= WORK.one > OUTFILE= "C:\excel.xls" > DBMS=EXCEL REPLACE; > SHEET="one"; > RUN; > PROC EXPORT DATA= WORK.two > OUTFILE= "C:\excel.xls" > DBMS=EXCEL REPLACE; > SHEET="sheet2"; > RUN; > > PROC EXPORT DATA= WORK.three > OUTFILE= "C:\excel.xls" > DBMS=EXCEL REPLACE; > SHEET="sheet3"; > RUN; > > -----Original Message----- > From: Jim Hoffman [mailto:jshoffman@dbsicorp.com] > Sent: Tuesday, October 19, 2004 10:04 PM > To: Ross, Michael D > Subject: RE: Sas to Excel questions > > > Here is an example of creating a new tab. > > filename excel dde 'EXCEL|SYSTEM'; > data _null_; > file excel; > put '[error(false)]'; > put '[file.close(false)]'; > put '[new(1)]'; > put '[save.as("c:\temp\color")]'; > run; > > It assumes that Excel Is running and has a spreadsheet open. It will > close the existing spreadsheet and create one with one tab "sheet1" then > save it. > > Regards, Jim Hoffman > > > -----Original Message----- > From: Ross, Michael D [mailto:michael.ross@ASTRAZENECA.COM] > Sent: Tuesday, October 19, 2004 3:02 PM > Subject: Sas to Excel questions > > > Hi All, > I'm trying to create multiple tabs in excel programatically from Sas > (4-6 tabs). I looked at the Sas-L archives and had no luck. Does > anyone have some example code to help me do this task? > > Also, does anyone know if you declare specific columns in excel > "Read-only" and how to allow other columns to be written too in the same > "tab" of a workbook programatically. > > Thanks. > Mike


Back to: Top of message | Previous page | Main SAS-L page