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.