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
**********************************************************************