Proc SQL sub query with group by example

[krishnaarrora]

Hey, programmers, can anyone tell me a simple example, how we can use subqueries and group by together in a single query?

[Ksharp]

proc sql;
select sex,count(*) as n_person,
 (select sum(weight) from sashelp.class where sex=a.sex) as total_weight
 from sashelp.class as a
  group by sex;
quit;

[krishnaarrora]

what's that "a.sex" means in where condition in that subquery?

[Ksharp · Accepted solution]

"a.sex" means variable sex is from table sashelp.class ( from sashelp.class as a )