PRO SQL GROUP BY CLAUSE

Karen_sas11 — Sun, 08 Jul 2018 03:39:27 GMT

proc sql;
create table total2 as
select idnumber, jobcode, sale1, sale2, sum(sale1) as s1, sum(sale2) as s2,
           sum(sale1, sale2) as s3
 from sumy
 group by jobcode;
 quit;

Hello , is anybody can tell me about the order of observations in each group without having clause and order by clause when group by clause?

In the attachment and code, the table total is the original data, after using groupy by clause, the entire data is grouped by jobcode shown in table total2. However, I found the order of observations in each group is werid. I assume the order should be sequencial as the original data, but is wasn't.

Order by clause can modify the order in each group, if there is no order by clause, what's the order convention in each group, which is my concern.

Hope anyone can explain it for me.

Many thanks!

Re: PRO SQL GROUP BY CLAUSE

Kurt_Bremser — Sun, 08 Jul 2018 05:26:02 GMT

It's undetermined, and an effect of the order in which observations are read from the utility file when the output is written.

Always specify the order yourself if you need a specific one.

Re: PRO SQL GROUP BY CLAUSE

Karen_sas11 — Sun, 08 Jul 2018 14:27:45 GMT

Thank you Kurt, now I get it.

topic PRO SQL GROUP BY CLAUSE in SAS Procedures

PRO SQL GROUP BY CLAUSE

Re: PRO SQL GROUP BY CLAUSE

Re: PRO SQL GROUP BY CLAUSE