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 (February 2004, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Wed, 4 Feb 2004 20:55:45 -0500
Reply-To:     "Richard A. DeVenezia" <radevenz@IX.NETCOM.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Richard A. DeVenezia" <radevenz@IX.NETCOM.COM>
Subject:      Re: Outputting a table to Excel

"Peter" <peter.papas@sympatico.ca> wrote in message news:nbgUb.8715$bp1.469657@news20.bellglobal.com... > Hi, > > I need some help with how to output a "new" table to Excel. I am new to SAS > and only try and post on the newsgroup if I cannot find the answer myself. > In this case I just cannot seem to find it...:( > > I input some data using the data step and then manipulate it into a format I > want using "proc transpose" or "proc tabulate". The problem is the "new" > table I have created is displayed in the output window. I need to export > the table to excel. I know where the data is stored that I read into sas > using the data step, but it is not in the format I want. > > How do I output the "new" table? > > Thank you in advance for your help! > > Peter

This example shows how to move html files into sheets of a workbook; the html files are created using ODS and Proc TABULATE. www.devenezia.com/downloads/sas/samples#excelmultisheet

There are many other techniques.

-- Richard A. DeVenezia


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