cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
kpro1234
‎05-15-2020
  • 4 Posts
  • 0 Likes Given
  • 0 Solutions
  • 3 Likes Received

Re: How do I get percents by group in SGPLOT?

by Fluorite | Level 6 in Graphics Programming
‎08-08-2018 04:01 PM
‎08-08-2018 04:01 PM
In this case I have 2 distinct values in DATA_COLUMN_C, but I more in other scenarios. So transforming and repeating should work as you suggested, but I wish there was an option that would make it happen without transforming data. From the documentation PCTLEVEL seemed like was the solution but it is giving percent by DATA_COLUMN_A grouping. Thanks for your responses, will have to do that work around if no other solution. ... View more

Re: How do I get percents by group in SGPLOT?

by Fluorite | Level 6 in Graphics Programming
‎08-08-2018 03:47 PM
1 Like
‎08-08-2018 03:47 PM
1 Like
 What I want is that the blue bars sum up to 100% and the pink bars also sum up to 100%. The variable name differentiating them is DATA_COLUMN_C in my code above. 0-14 are DATA_COLUMN_A values and DATA_COLUMN_B is the response variable.     ... View more

Re: How do I get percents by group in SGPLOT?

by Fluorite | Level 6 in Graphics Programming
‎08-08-2018 03:33 PM
1 Like
‎08-08-2018 03:33 PM
1 Like
I had tried that, when I do PCTLEVEL=GRAPH I get percents for the entire data. If I do PCTLEVEL=GRAPH and then add a BY DATA_COLUMN_C statement after VBAR, then I get what I need but in two different graphs. But I am trying to have them both in one GRAPH. Trying to get distribution of data in PERCENT but the percents should add up to 100 by the GROUP variable. ... View more

How do I get percents by group in SGPLOT?

by Fluorite | Level 6 in Graphics Programming
‎08-08-2018 03:03 PM
1 Like
‎08-08-2018 03:03 PM
1 Like
I am using this code to get percent of bars within group (data_column_C), but what I am getting is percent within data_column_A category.   Basically I want the percents to sum up to 100% for data_column_C and have individual bar by data_column_A.   proc sgplot data=data_table pctlevel=group; vline data_column_A /response=data_column_B stat=mean limitstat=clm markers group=data_column_C lineattrs=(thickness=2); vbar data_column_A / response=data_column_B y2axis transparency=0.75 group=data_column_C groupdisplay=cluster stat=percent; run; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎05-15-2020 05:41 PM
Likes from
View All
Quick links