topic Re: PROC Report change in New SAS User

PROC Report change

joaocamargo — Wed, 15 May 2024 11:38:44 GMT

Hi!
How can i change this?

for this

Re: PROC Report change

BrunoMueller — Wed, 15 May 2024 12:05:48 GMT

You can use a COMPUTE BEFORE block to achieve this. See example below. note that the make column is not printed but used in the COMPUTE BEFORE together with the LINE statement.

proc report data=sashelp.cars;
    column make model invoice horsepower;
    define make / order noprint;
    define model / display style={textalign=left};
    compute before make / 
        style={backgroundcolor=lightblue textalign=left}
    ;
        line make $20.;
    endcomp;
run;

Re: PROC Report change

joaocamargo — Wed, 15 May 2024 12:25:01 GMT

Wow, thanks a lot. I've been trying to do this for a few days!

Re: PROC Report change

joaocamargo — Wed, 15 May 2024 12:37:36 GMT

Can I create a large group and then place other groups?
Like
South America
Brazil
Type1
Type2
Type3
Argentina
Type1
Type2
Type3
Europe
Germany
Type1
Type2
Type3
France
Type1
Type2
Type3

?

Re: PROC Report change

BrunoMueller — Wed, 15 May 2024 12:38:11 GMT

You are welcome. Maybe it makes sense to buy this book https://support.sas.com/content/dam/SAS/support/en/books/the-sas-programmers-proc-report-handbook/69155_excerpt.pdf

Re: PROC Report change

BrunoMueller — Wed, 15 May 2024 13:22:27 GMT

Sure just add the variables needed specify NOPRINT for the once you use in a COMPUTE BEFORE variable block.


proc report data=sashelp.orsales;
    column year quarter product_line quantity;
    define year / group noprint;
    define quarter / group noprint;
    define product_line / group;
    define quantity / analysis;
    compute before year;
        line year 4.;
    endcomp;
    compute before quarter;
      line quarter $6.;
    endcomp;
run;