topic Re: Proc SQL sub query with group by example in SAS Programming

Proc SQL sub query with group by example

krishnaarrora — Thu, 25 Jun 2020 12:17:36 GMT

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

Re: Proc SQL sub query with group by example

Ksharp — Thu, 25 Jun 2020 12:32:34 GMT

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;

Re: Proc SQL sub query with group by example

krishnaarrora — Fri, 26 Jun 2020 10:28:12 GMT

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

Re: Proc SQL sub query with group by example

Ksharp — Fri, 26 Jun 2020 11:23:51 GMT

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