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 (June 2000, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Fri, 23 Jun 2000 09:11:46 -0400
Reply-To:     "Bross, Dean S" <dean.bross@MAIL.VA.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Bross, Dean S" <dean.bross@MAIL.VA.GOV>
Subject:      Re: Proc Export
Content-Type: text/plain; charset="iso-8859-1"

I'll give you one possible suggestion. You could have the SAS export wizard convert a test file into CSV format. This will feed directly into EXCEL although it doesn't have all the features available in EXCEL.

The export wizard does its work by generating SAS code and running it. So you can just press the recall button and this will give you the code to build into your own SAS run. The result will be a noninteractive conversion, but only to CSV. The CSV file does have to be loaded into EXCEL manually.

Another possibility is to use DDE. This is not hard once you learn how to do it, but it is a little bit more difficult to learn than the export wizard.

Dean Bross

> -----Original Message----- > From: Nick Paszty [mailto:npaszty@ORGANIC.COM] > Sent: Thursday, June 22, 2000 4:29 PM > To: SAS-L@LISTSERV.UGA.EDU > Subject: Proc Export > > > Hello. > > Is there a way to non interactively load output from SAS into > Excel without > having Access to PC file formats? I know that there is a > proc export that > writes out to an Excel file but do you need Access to PC file > formats to > have this functionality or is it simply a part of Base SAS > export procedure? > > Thanks, > > Nick >

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