NOTE: The query requires remerging summary statistics back with the original data.

[frupaul]

Hi Everyone,

I am trying to summaries data contained in sashelp.class using PROC SQL to a report similar (column headers might be different but information contained should match) to the below output generated from PROC REPORT:

The script I have written is this:

proc sql;
select 
     age, 
     case when Sex='F' then sum(Weight) else . end as Weight_Femal, 
     case when Sex='M' then sum(weight) else . end as Weight_Male
from sashelp.class
group by 1;
quit;

However, this generates the error message: 

I know what the error is, but in this case i dont know how to correct it. Can anyone help please?

[ChrisNZ · Accepted solution]

Like this?

proc sql;
  select age
        ,sum(case when Sex='F' then Weight else . end) as Weight_F
        ,sum(case when Sex='M' then Weight else . end) as Weight_M 
  from sashelp.class
  group by 1;
quit;

[ChrisNZ]

You cam also write this as:

proc sql;
  select AGE
        ,sum((SEX='F') * WEIGHT) as WEIGHT_F
        ,sum((SEX='M') * WEIGHT) as WEIGHT_M
  from SASHELP.CLASS
  group by 1;
quit;