topic Re: Create a Proc Tabulate in SAS Programming

Create a Proc Tabulate

Brandon16 — Mon, 26 Feb 2018 13:15:09 GMT

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

RW9 — Mon, 26 Feb 2018 14:09:59 GMT

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;

Astounding — Mon, 26 Feb 2018 14:18:06 GMT

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;