It's possible, but inefficient.
*Summary statistics;
proc means data=sashelp.prdsal3 noprint nway;
class month year;
var actual;
output out=summary sum(actual)=total_sales;
run;
*format for display;
proc transpose data=summary out=want (drop=_:) prefix=Year;
by month;
id year;
var total_sales;
run;
The SQL solution works but you have to know the years ahead of time AND code it for each year individually.
proc sql;
create table want_sql as
select put(month, monname3.) as month,
sum(case when year=1997 then actual else 0 end) as year1997 format=dollar32.2,
sum(case when year=1998 then actual else 0 end) as year1998 format=dollar32.2
from sashelp.prdsal3
group by calculated month;
quit;
@kishangabani wrote:
Sorry, I want output like this
MONTH 1997 1998 column name
I don't want missing or null value. and, also want PROC SQL query if it's possible.
Thank You.
... View more