Nesting Headers in PROC REPORT

[camdbean]

Nesting Headers in PROC REPORT

**********************************************************************************

Hello SAS Communities,

I am trying to nest MEAN and STD statistics for two variables: SBP (Systolic Blood Pressure) and DBP (Diastolic Blood Pressure). I am attempting to nest them so that I have one Spanning header reading "Average Pressures", within this are two more headers "Systolic" and "Diastolic", where finally my MEAN and STD calculations are located for each variable. My issue is, when nesting my variables, I am getting all of my desired headers, with the addition of the original variable labels right below my "Systolic" and "Diastolic" headers. Is there any way to suppress the original variable labels?

My code is below

TITLE1 “Blood Pressure Summaries by Race”;
PROC REPORT DATA = WORK.Test;
           COLUMN RaceCd N
                           ("Average Pressures" ("Systolic" SBP,(MEAN STD))
                                                              ("Diastolic" DBP,(MEAN STD))
                            );
            DEFINE RaceCd / GROUP;
            DEFINE SBP / FORMAT = 4.1;
            DEFINE DBP / FORMAT = 4.1;

            RBREAK AFTER / SUMMARIZE;
RUN;
TITLE;

Thank you

[dthompsonada · Accepted solution]

Hi camdbean,

I had a hard time with this as well. I originally attempted this same set up in the column statement. I got some advice (From a TA!) and this worked:

COLUMN RaceCd N
("Average Pressures" SBP DBP),(MEAN STD);

And then add label text to your DEFINE statements like this:

DEFINE SBP / FORMAT = 5.1 'Systolic';
DEFINE DBP / FORMAT = 5.1 'Diastolic';

Everything else in our code was the same.

Hope that helps!

Danielle

[Ksharp]

https://communities.sas.com/t5/SAS-Communities-Library/Demographic-Table-and-Subgroup-Summary-Macro-...