topic tabulate pctn in SAS Procedures

tabulate pctn

podarum — Tue, 24 Jan 2012 19:24:31 GMT

Hi, I'm having a hard time with trying to get percentages by subgroups using proc tabulate. I'm sure it's probably a simple fix, I just tried everything.

I have this output (below). But I want to show the percentages of each CI1_B by Vendor_1 separately. So each one would add up to 100%. I tried rowpctn.

PctN
Vendor_1	CI1_B	100
VendorA	<= -20.1%	100
	-15.1% => and => -20%	100
	-10.1% => and => -15%	100
	-5.1% => and => -10%	100
	0% => and => -5%	100
	0.1% <= and <= 5.0%	100
	5.0% <= and <= 10.0%	100
	10% <= and <= 15.0%	100
	> = 15.1%	100
VendorB	>=30%	100
	<30%	100
	<20%	100
	<10%	100
	<5%	100

tabulate pctn

Cynthia_sas — Tue, 24 Jan 2012 19:35:31 GMT

Hi:

It would be useful to see your TABULATE code and a small sample of data or fake data that was representative of your data.

If you need to specify a special denominator for percent calculation, you use the < > operators, as described in Example 13 in the documentation:

http://support.sas.com/documentation/cdl/en/proc/63079/HTML/default/viewer.htm#n1m5z9bzbggfson1wgywh01h8zlq.htm

cynthia