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 2007, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Mon, 7 May 2007 10:54:26 -0400
Reply-To:   "Richard A. DeVenezia" <rdevenezia@WILDBLUE.NET>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   "Richard A. DeVenezia" <rdevenezia@WILDBLUE.NET>
Organization:   Internet News Service
Subject:   Tabulate, use a class variable twice but with different formats ?
Comments:   To: sas-l@uga.edu

Is it possible to reuse a class variable, but with a different formatting at the different class level ?

This sample code is close but hopefully missing a small something.

----- data fins; do date = today()-720 to today(); do storeid = 1 to 100; actual = floor (1000 * ranuni(1234)); projected = actual + floor (125 * ranuni(1234)) - 50; output; end; end; run;

proc format; value storeg 1-20 = 'A' 21-40 = 'B' 40-90 = 'C' 90-100 = 'D' ; run;

proc tabulate data=fins; class date storeid; var actual projected;

format date year.; format storeid storeg.;

table storeid='region' * storeid='store'*f=3. , date='year' * (date='qtr'*f=qtr.) * (actual*sum='' projected*sum='') ; run;

-- Richard A. DeVenezia http://www.devenezia.com/


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