topic Re: Proc tabulate? in SAS Programming

Proc tabulate?

Nini — Tue, 14 Nov 2017 21:30:11 GMT

I have a number of variables showing time in minutes, each with many observations. I need to show each of the variables as a percentage of the total.I think I need to use proc tabulate but am new to SAS. Can someone help?

Re: Proc tabulate?

Reeza — Tue, 14 Nov 2017 21:53:49 GMT

I don't think PROC TABULATE will do what you want with multiple variables.

I think you'll need multiple steps, likely a PROC MEANS and a FREQ or a DATA STEP.

Either way, for more assistance please post sample data and your expected output.

Don't post images as sample data, that would mean we have to type it out 😞

@Nini wrote:
I have a number of variables showing time in minutes, each with many observations. I need to show each of the variables as a percentage of the total.I think I need to use proc tabulate but am new to SAS. Can someone help?

Re: Proc tabulate?

Shmuel — Tue, 14 Nov 2017 21:53:52 GMT

Can you post a sample of your dataset and in what format you want the report ?

Re: Proc tabulate?

Nini — Wed, 15 Nov 2017 08:21:17 GMT

Thanks all,

here is a sample of my data

Outdoor Leisure Team Domestic Walk Cycle Total

0 0 15 20 0 0 35

0 10 0 10 5 0 25

35 0 50 0 15 0 85

I just want to show how each of the variables contributes to the total something like below

Outdoor 25%

Leisure 10%

Team 15%

Domestic 5%

Walk 15%

Cycle 30%

Total 100%

Re: Proc tabulate?

Ksharp — Wed, 15 Nov 2017 13:49:10 GMT

It is very easy for IML .

data have;
input Outdoor  Leisure  Team  Domestic  Walk  Cycle  Total ;
cards;
  0                0         15          20           0        0          35
  0               10          0          10           5        0          25
  35              0          50          0            15      0          85
;
run;

proc iml;
use have;
read all var _num_ into x[c=vname];
close;

ratio=t(x[+,]/sum(x[,ncol(x)]));

print (t(vname)) ratio[f=percent8.2];
quit;