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?
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;
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;
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;
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.