proc sql;
create table m as
select distinct month
from sashelp.prdsal3
;
quit; MONTH Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total month is 24. proc sql;
select month,
case
when year=1997 then sum(actual)
end as _1997
,
case
when year=1998 then sum(actual)
end as _1998
from sashelp.prdsal3
group by 1;
quit; OUTPUT: I want to properly to set month. I want to sum of column 'ACTUAL'.
... View more
