- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;