tabulate pctn

[podarum]

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%
	-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

[Cynthia_sas]

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#n1m5z9bzbggfson1wgywh...

cynthia