Hi,
How do I create a proc tabulate by using the following code below
proc sql;
create table test.testing_one as
select
pdte,
mnth,
sum(fns) as test_fns,
sum(val) as test_Val
from test.testing
group by pdte, mnth;
to output like
pdte mnth test_fns test_val
1 1 898 54545
1 2 45454 54548
Thanks
If you are really after a report rather than a data set, and really set on using PROC TABULATE, it can come pretty close to what you ask:
proc tabulate data=have;
class pdte month;
var test_fns test_Val;
tables pdte * month, sum=' '*(test_fns test_val);
run;
That isn't a tabulation, its a summarisation, so use proc means/summary, e.g:
proc means data=testing; by pdte mnth; var fns val; output out=testing_one sum=; run;
If you are really after a report rather than a data set, and really set on using PROC TABULATE, it can come pretty close to what you ask:
proc tabulate data=have;
class pdte month;
var test_fns test_Val;
tables pdte * month, sum=' '*(test_fns test_val);
run;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.