Help using Base SAS procedures

tabulate pctn

Reply
Super Contributor
Posts: 395

tabulate pctn

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_1CI1_B100
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
SAS Super FREQ
Posts: 8,743

tabulate pctn

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

 

Ask a Question
Discussion stats
  • 1 reply
  • 141 views
  • 0 likes
  • 2 in conversation