Date:         Tue, 13 Mar 2007 21:47:06 -0400
Reply-To:     "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Subject:      Re: reporting

On Mon, 12 Mar 2007 13:32:42 -0400, Amy Sun <tonyliang20032@GMAIL.COM> wrote:

>Hi, All;
>
>I have the following data structure
>
>BODY PREFER  SEVR     CAT1          CAT2            CAT3
>AAAA  BBBBB   MIL    2 (12.5)      2 (12.5)       3 (14.7)
>AAAA  BBBBB   MOD    2 (12.5)      2 (12.5)       3 (14.7)
>AAAA  BBBBB   SEV    2 (12.5)      2 (12.5)       3 (14.7)
>BBBB  CCCCC   MIL    2 (12.5)      2 (12.5)       3 (14.7)
>BBBB  CCCCC   MOD    2 (12.5)      2 (12.5)       3 (14.7)
>BBBB  CCCCC   SEV    2 (12.5)      2 (12.5)       3 (14.7)
>
>AND I want the following report
>
>                                         CAT1
>CAT2                               CAT3
>BODY PREFER      MIL     MOD        SEV       MIL     MOD        SEV
>MIL MOD SEV
>AAAA  BBBBB   2 (12.5) 2 (12.5)   2 (12.5) 2 (12.5) 2 (12.5)   2 (12.5)
>......
>BBBB  CCCCC    ...................................
>The following is the sample code for trying, while it does not work,
>proc report data=REPORTA  nowindows split='@' missing headline SPACING = 1;
> COLUMN  BODY PREFER
>  (str1, ( INTENS ) )
>  (str2, ( INTENS = INTENS1 ) )
>  (str3, ( INTENS = INTENS2) );
>
> DEFINE BODY   / GROUP FLOW 'System' LEFT ;
> DEFINE PREFER / GROUP'Prefer' FLOW ;
> DEFINE CAT1 / DISPLAY FLOW   ;
> DEFINE INTENS  / ACROSS ORDER = INTERNAL ' ';
>
> DEFINE CAT2 / DISPLAY FLOW   ;
> DEFINE INTENS1  / ACROSS ORDER = INTERNAL ' ';
> DEFINE CAT3 / DISPLAY FLOW   ;
> DEFINE INTENS2  / ACROSS ORDER = INTERNAL ' ';
>RUN;
>
>Hence, could you like to give me some suggestions, thank you in advance for
>your time.
>
>Best regards,
>Amy

The variables in the data set don't quite correspond to those in the PROC
REPORT code. I get