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 (May 2006, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Wed, 3 May 2006 14:10:39 -0700
Reply-To:     David Ryerson <ryersond@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         David Ryerson <ryersond@YAHOO.COM>
Subject:      Make columns out of proc freq output
Content-Type: text/plain; charset=iso-8859-1

I need to convert the following proc freq output into more of a columnar format to report it in a table. Specifically, I need to take the following:

var txgrp COUNT PERCENT ------------------------------------ 1 A 3 10.0000 1 B 2 6.6667

and turn it into something like:

VAR COUNTA PCTA COUNTB PCTB ------------------------------------------- 1 3 10.0000 2 6.6667

I'd prefer to be able to do this in a data step rather than calculating statistics in proc report.

Any thoughts would be appreciated, David Ryerson

__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com


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