proc sql; create table dataset2 as select var1, mean(var2) as average, (select sum(var3) from dataset1 where var2>=1 group by var1), (select sum(var3) from dataset1 where var2>=1 group by var1) from dataset1 group by var1; quit; ERROR: SUBQUERY EVALUATED TO MORE THAN ONE ROW Hi everyone, I am new to SAS and I'd like to understand about subqueries. So what I want is to have a table with 4 columns: var1 mean(var2) sum(var3) only where var2>=1 sum(var3) only where var2<1 Therefore I want the "where" statement to trigger only for the last two columns. The subquery works if I dont add the "group by" but in that case I am not able to have the breakdown by var1. On the other hand if I add the "group by" in the subquery I get this error: Subquery evaluated to more than one row. I know that I could obtain the same table with joins but I really would like to understand better how to exploit subqueries. Thanks in advance for your help.
... View more