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 (August 2007, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Tue, 28 Aug 2007 06:39:20 -0700
Reply-To:     Syb it <sas_datalover@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Syb it <sas_datalover@YAHOO.COM>
Subject:      Re: Displaying SAS output in Excel
Comments: To: Alan Churchill <savian001@GMAIL.COM>
In-Reply-To:  <000901c7e977$73aa5030$5afef090$@com>
Content-Type: text/plain; charset=iso-8859-1

I chose variations of this code instead...

ods pdf file="huge.pdf"; proc freq data = huge; tables product; run; ods pdf close;

or

ods html file="huge.xls"; proc freq data = huge; tables product; run; ods html close;

Alan Churchill <savian001@GMAIL.COM> wrote: SAS Add-In for Microsoft Office.

Outside of that, you need to parse the list output. Loads of ways of handling the parsing and the display into Excel...

Alan

Alan Churchill Savian www.savian.net

-----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Syb it Sent: Tuesday, August 28, 2007 7:24 AM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: Displaying SAS output in Excel

What is the best way of outputing the results of a PROC FREQ in Excel? I ran a proc freq on product names from a dataset with 11 million records. so its pretty huge, but that all i need to do.

Help would be appreciated!

--------------------------------- Got a little couch potato? Check out fun summer activities for kids.

--------------------------------- Building a website is a piece of cake. Yahoo! Small Business gives you all the tools to get online.


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