You will need a DATA STEP to do this . Moreover a Data _NULL_

data _null_ ; set sasdata.out; by DESCENDING percent; file ................; * output file info ;

put @ 1 varname $?? @25 count 8. @35 percent 5.2 ;

> -----Original Message----- > From: Mark Varacalli [SMTP:mvaracalli@ATT.COM] > Sent: Thursday, July 26, 2001 12:07 PM > To: SAS-L@LISTSERV.UGA.EDU > Subject: Creating a flat text file from proc freq results > > I am new to sas so I apologize in advance for my ingnorance... > > There is probably a very easy solution to this, but it is evading me > at the moment. I would like to create a flat text file that contains > the results of many proc freq functions. I currently have scripts > that run, but the output to sas data sets using /out=. Here is an > example: > > proc freq data=sasdata.data noprint; > tables field /out=sasdata.out; > run; > > proc sort data=sasdata.out; > by DESCENDING percent; > run; > > *This repeats for different fields. > > Ideally I would like the results to look something like this: > > Title Count Percent of total > Unique data from field 1000 23.000 > Unique data from field 500 11.500 > Unique data from field 250 5.750 > and so on... > > Thank you for your help, > > Mark

**************************************************************** Bear Stearns is not responsible for any recommendation, solicitation, offer or agreement or any information about any transaction, customer account or account activity contained in this communication. ***********************************************************************