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 (February 2003, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Yahoo! Shopping - Send Flowers for Valentine's Day
=========================================================================
Date:         Wed, 19 Feb 2003 11:03:56 +1100
Reply-To:     Thomas Rick <rthomas@WOOLWORTHS.COM.AU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Thomas Rick <rthomas@WOOLWORTHS.COM.AU>
Subject:      Re: Question on rearranging data for output.
Content-Type: text/plain

John,

Try something like this (untested code)...

PROC TABULATE; CLASS Act_reason Act_outcome; VAR x1 x2 y1 y2 z1 z2; TABLE Act_reason=' ', Act_outcome=' '*(x1 x2 y1 y2 z1z z2)*F=comma3.*sum=' ' / RTS=20; RUN;

Regards, Rick. > -----Original Message----- > From: John Hewitt [SMTP:john_hewitt2003@YAHOO.COM] > Sent: Wednesday, February 19, 2003 10:51 AM > To: SAS-L@LISTSERV.UGA.EDU > Subject: Question on rearranging data for output. > > Dear ALL: > I have a dataset organized as follows: > Act_reason Act_Outcome x1 x2 y1 y2 Z1 Z2 > > Btext Z00 > > NAB Z00 > > Omitted Ads Z00 > > Other Z00 > > BText Z0A > > NAB Z0A > > Omitted Ads Z0A > > Other Z0A > > BText Z0C > > NAB Z0C > > Other Z0C > > > > Which I want to reorganize as follows: > > > > Z00 Z0A ZOC > > x1 x2 y1 y2 Z1 Z2 x1 x2 y1 y2 Z1 Z2 x1 x2 y1 y2 Z1 Z2 > > Btext > > NAB > > Omitted Ads > > Other > > > > I have tried using Proc Tabulate but can't seem to make it work. Can > anyone kindly suggest a good approach. > Thanks in advance for your help. > > John > > > > --------------------------------- > Do you Yahoo!? > Yahoo! Shopping - Send Flowers for Valentine's Day **********************************************************************


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