topic Re: PROC SGPLOT - stacked bar graph - HORIZONTAL and colors in SAS Programming

topic Re: PROC SGPLOT - stacked bar graph - HORIZONTAL and colors in SAS Programming https://communities.sas.com/t5/SAS-Programming/proc-sgplot-stacked-bar-chart-horizontal-with-RGB-colors/m-p/518632#M140387 <P>You posted this in SAS VA, are you using SAS Visual Analytics, which is a GUI interface or programming in Base?</P> <P> </P> <P>Assuming you're using Base - Pattern statements apply to SAS/GRAPH not SGPLOT. You can use the STYLEATTRS() to control the colour. You may want a data attribute map, but try adding the following statement after your SGPLOT statement, but before your VBAR statement. </P> <P> </P> <PRE><CODE class=" language-sas">styleattrs datacolors=(cx9999ff cs993366 cxffffcc);</CODE></PRE> <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/153469">@radhikaa4</a> wrote:<BR /> <P>Hello,</P> <P> </P> <P>I need help with creating 1) horizontal stacked bar chart and then 2) giving certain RGB color to a scale:</P> <P> </P> <P>here is the dataset I have:</P> <TABLE border="1" cellspacing="1" cellpadding="2"> <TBODY> <TR> <TD> <P align="left"><FONT face="Calibri" size="3">treatment_group</FONT></P> </TD> <TD> <P align="left"><FONT face="Calibri" size="3">scale</FONT></P> </TD> <TD> <P align="left"><FONT face="Calibri" size="3">percent</FONT></P> </TD> </TR> <TR> <TD> <P align="left"><FONT face="Calibri" size="3">drug</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">0</FONT></P> </TD> <TD> <P align="left"><FONT face="Calibri" size="3">.</FONT></P> </TD> </TR> <TR> <TD> <P align="left"><FONT face="Calibri" size="3">drug</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">1</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">2.5</FONT></P> </TD> </TR> <TR> <TD> <P align="left"><FONT face="Calibri" size="3">drug</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">2</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">2.5</FONT></P> </TD> </TR> <TR> <TD> <P align="left"><FONT face="Calibri" size="3">drug</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">3</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">12.5</FONT></P> </TD> </TR> <TR> <TD> <P align="left"><FONT face="Calibri" size="3">drug</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">4</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">24.2</FONT></P> </TD> </TR> <TR> <TD> <P align="left"><FONT face="Calibri" size="3">drug</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">5</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">23.3</FONT></P> </TD> </TR> <TR> <TD> <P align="left"><FONT face="Calibri" size="3">drug</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">6</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">9.2</FONT></P> </TD> </TR> <TR> <TD> <P align="left"><FONT face="Calibri" size="3">drug</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">7</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">25.8</FONT></P> </TD> </TR> <TR> <TD> <P align="left"><FONT face="Calibri" size="3">control</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">0</FONT></P> </TD> <TD> <P align="left"><FONT face="Calibri" size="3">.</FONT></P> </TD> </TR> <TR> <TD> <P align="left"><FONT face="Calibri" size="3">control</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">1</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">0.4</FONT></P> </TD> </TR> <TR> <TD> <P align="left"><FONT face="Calibri" size="3">control</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">2</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">6.0</FONT></P> </TD> </TR> <TR> <TD> <P align="left"><FONT face="Calibri" size="3">control</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">3</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">12.0</FONT></P> </TD> </TR> <TR> <TD> <P align="left"><FONT face="Calibri" size="3">control</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">4</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">25.7</FONT></P> </TD> </TR> <TR> <TD> <P align="left"><FONT face="Calibri" size="3">control</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">5</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">24.1</FONT></P> </TD> </TR> <TR> <TD> <P align="left"><FONT face="Calibri" size="3">control</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">6</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">12.4</FONT></P> </TD> </TR> <TR> <TD> <P align="left"><FONT face="Calibri" size="3">control</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">7</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">19.3</FONT></P> </TD> </TR> </TBODY> </TABLE> <P> </P> <P>I would like to create a stacked bar graph HORIZONTAL. Right now, I have it vertical.</P> <P><FONT face="Courier New" size="2"> </FONT></P> <P><FONT face="Courier New" size="2" color="#000080"><STRONG>proc</STRONG></FONT> <STRONG><FONT face="Courier New" size="2" color="#000080">sgplot</FONT></STRONG> <FONT face="Courier New" size="2" color="#0000ff">data</FONT><FONT face="Courier New" size="2">=a.FreqOut;</FONT></P> <P> </P> <P><FONT face="Courier New" size="2" color="#0000ff">vbar</FONT><FONT face="Courier New" size="2"> treatment_group/ </FONT><FONT face="Courier New" size="2" color="#0000ff">response</FONT><FONT face="Courier New" size="2">=Percent </FONT><FONT face="Courier New" size="2" color="#0000ff">group</FONT><FONT face="Courier New" size="2">=scale </FONT><FONT face="Courier New" size="2" color="#0000ff">groupdisplay</FONT><FONT face="Courier New" size="2">=stack;</FONT></P> <P><FONT face="Courier New" size="2" color="#0000ff">xaxis</FONT> <FONT face="Courier New" size="2" color="#0000ff">discreteorder</FONT><FONT face="Courier New" size="2">=data;</FONT></P> <P><FONT face="Courier New" size="2" color="#0000ff">yaxis</FONT> <FONT face="Courier New" size="2" color="#0000ff">grid</FONT> <FONT face="Courier New" size="2" color="#0000ff">values</FONT><FONT face="Courier New" size="2">=(</FONT><STRONG><FONT face="Courier New" size="2" color="#008080">0</FONT></STRONG><FONT face="Courier New" size="2"> to </FONT><STRONG><FONT face="Courier New" size="2" color="#008080">100</FONT></STRONG><FONT face="Courier New" size="2"> by </FONT><STRONG><FONT face="Courier New" size="2" color="#008080">10</FONT></STRONG><FONT face="Courier New" size="2">) </FONT><FONT face="Courier New" size="2" color="#0000ff">label</FONT><FONT face="Courier New" size="2">=</FONT><FONT face="Courier New" size="2" color="#800080">"Percentage of Total"</FONT><FONT face="Courier New" size="2">;</FONT></P> <P><FONT face="Courier New" size="2" color="#000080"><STRONG>run</STRONG></FONT><FONT face="Courier New" size="2">;</FONT></P> <P> </P> <P><FONT face="Courier New" size="2">Also for Each scale, I would like to give a RGB color</FONT></P> <P><FONT face="Courier New" size="2">For examples</FONT></P> <P><FONT face="Courier New" size="2">- Scale 7 should have certain color:cx9999ff <FONT face="Courier New" size="2"><BR />- Scale 6 should have certain color=cx993366</FONT></FONT></P> <P><FONT face="Courier New" size="2"><FONT face="Courier New" size="2">- Scale 5 should have certain color=cxffffcc</FONT></FONT></P> <P> </P> <P><FONT face="Courier New" size="2"><FONT face="Courier New" size="2">I tried but no luck!</FONT></FONT></P> <P><FONT face="Courier New" size="2"><FONT face="Courier New" size="2">pattern1 v=solid color=cx9999ff; <BR />pattern2 v=solid color=cx993366; <BR />pattern3 v=solid color=cxffffcc;  </FONT></FONT></P> <P> </P> <P><FONT face="Courier New" size="2"><FONT face="Courier New" size="2">Any help would be appreciated!!</FONT></FONT></P> <HR /></BLOCKQUOTE> <P><BR /><BR /></P> Wed, 05 Dec 2018 02:16:40 GMT Reeza 2018-12-05T02:16:40Z proc sgplot - stacked bar chart (horizontal) with RGB colors https://communities.sas.com/t5/SAS-Programming/proc-sgplot-stacked-bar-chart-horizontal-with-RGB-colors/m-p/518636#M140385 <P>Hello,</P><P> </P><P>I need help with creating 1) horizontal stacked bar chart and then 2) giving certain RGB color to a scale:</P><P> </P><P>here is the dataset I have:</P><TABLE border="1" cellspacing="1" cellpadding="2"><TBODY><TR><TD><P align="left"><FONT face="Calibri" size="3">treatment_group</FONT></P></TD><TD><P align="left"><FONT face="Calibri" size="3">scale</FONT></P></TD><TD><P align="left"><FONT face="Calibri" size="3">percent</FONT></P></TD></TR><TR><TD><P align="left"><FONT face="Calibri" size="3">drug</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">0</FONT></P></TD><TD><P align="left"><FONT face="Calibri" size="3">.</FONT></P></TD></TR><TR><TD><P align="left"><FONT face="Calibri" size="3">drug</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">1</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">2.5</FONT></P></TD></TR><TR><TD><P align="left"><FONT face="Calibri" size="3">drug</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">2</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">2.5</FONT></P></TD></TR><TR><TD><P align="left"><FONT face="Calibri" size="3">drug</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">3</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">12.5</FONT></P></TD></TR><TR><TD><P align="left"><FONT face="Calibri" size="3">drug</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">4</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">24.2</FONT></P></TD></TR><TR><TD><P align="left"><FONT face="Calibri" size="3">drug</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">5</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">23.3</FONT></P></TD></TR><TR><TD><P align="left"><FONT face="Calibri" size="3">drug</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">6</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">9.2</FONT></P></TD></TR><TR><TD><P align="left"><FONT face="Calibri" size="3">drug</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">7</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">25.8</FONT></P></TD></TR><TR><TD><P align="left"><FONT face="Calibri" size="3">control</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">0</FONT></P></TD><TD><P align="left"><FONT face="Calibri" size="3">.</FONT></P></TD></TR><TR><TD><P align="left"><FONT face="Calibri" size="3">control</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">1</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">0.4</FONT></P></TD></TR><TR><TD><P align="left"><FONT face="Calibri" size="3">control</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">2</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">6.0</FONT></P></TD></TR><TR><TD><P align="left"><FONT face="Calibri" size="3">control</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">3</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">12.0</FONT></P></TD></TR><TR><TD><P align="left"><FONT face="Calibri" size="3">control</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">4</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">25.7</FONT></P></TD></TR><TR><TD><P align="left"><FONT face="Calibri" size="3">control</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">5</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">24.1</FONT></P></TD></TR><TR><TD><P align="left"><FONT face="Calibri" size="3">control</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">6</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">12.4</FONT></P></TD></TR><TR><TD><P align="left"><FONT face="Calibri" size="3">control</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">7</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">19.3</FONT></P></TD></TR></TBODY></TABLE><P> </P><P>I would like to create a stacked bar graph HORIZONTAL. Right now, I have it vertical.</P><P><FONT face="Courier New" size="2"> </FONT></P><P><FONT color="#000080" face="Courier New" size="2"><STRONG>proc</STRONG></FONT> <STRONG><FONT color="#000080" face="Courier New" size="2">sgplot</FONT></STRONG> <FONT color="#0000ff" face="Courier New" size="2">data</FONT><FONT face="Courier New" size="2">=a.FreqOut;</FONT></P><P> </P><P><FONT color="#0000ff" face="Courier New" size="2">vbar</FONT><FONT face="Courier New" size="2"> treatment_group/ </FONT><FONT color="#0000ff" face="Courier New" size="2">response</FONT><FONT face="Courier New" size="2">=Percent </FONT><FONT color="#0000ff" face="Courier New" size="2">group</FONT><FONT face="Courier New" size="2">=scale </FONT><FONT color="#0000ff" face="Courier New" size="2">groupdisplay</FONT><FONT face="Courier New" size="2">=stack;</FONT></P><P><FONT color="#0000ff" face="Courier New" size="2">xaxis</FONT> <FONT color="#0000ff" face="Courier New" size="2">discreteorder</FONT><FONT face="Courier New" size="2">=data;</FONT></P><P><FONT color="#0000ff" face="Courier New" size="2">yaxis</FONT> <FONT color="#0000ff" face="Courier New" size="2">grid</FONT> <FONT color="#0000ff" face="Courier New" size="2">values</FONT><FONT face="Courier New" size="2">=(</FONT><STRONG><FONT color="#008080" face="Courier New" size="2">0</FONT></STRONG><FONT face="Courier New" size="2"> to </FONT><STRONG><FONT color="#008080" face="Courier New" size="2">100</FONT></STRONG><FONT face="Courier New" size="2"> by </FONT><STRONG><FONT color="#008080" face="Courier New" size="2">10</FONT></STRONG><FONT face="Courier New" size="2">) </FONT><FONT color="#0000ff" face="Courier New" size="2">label</FONT><FONT face="Courier New" size="2">=</FONT><FONT color="#800080" face="Courier New" size="2">"Percentage of Total"</FONT><FONT face="Courier New" size="2">;</FONT></P><P><FONT color="#000080" face="Courier New" size="2"><STRONG>run</STRONG></FONT><FONT face="Courier New" size="2">;</FONT></P><P> </P><P><FONT face="Courier New" size="2">Also for Each scale, I would like to give a RGB color</FONT></P><P><FONT face="Courier New" size="2">For examples</FONT></P><P><FONT face="Courier New" size="2">- Scale 7 should have certain color:cx9999ff<BR />- Scale 6 should have certain color=cx993366</FONT></P><P><FONT face="Courier New" size="2">- Scale 5 should have certain color=cxffffcc</FONT></P><P> </P><P><FONT face="Courier New" size="2">I tried but no luck!</FONT></P><P><FONT face="Courier New" size="2">pattern1 v=solid color=cx9999ff; <BR />pattern2 v=solid color=cx993366; <BR />pattern3 v=solid color=cxffffcc;  </FONT></P><P> </P><P><FONT face="Courier New" size="2">Any help would be appreciated!!</FONT></P> Wed, 05 Dec 2018 02:19:05 GMT https://communities.sas.com/t5/SAS-Programming/proc-sgplot-stacked-bar-chart-horizontal-with-RGB-colors/m-p/518636#M140385 radhikaa4 2018-12-05T02:19:05Z PROC SGPLOT - stacked bar graph - HORIZONTAL and colors https://communities.sas.com/t5/SAS-Programming/proc-sgplot-stacked-bar-chart-horizontal-with-RGB-colors/m-p/518628#M140386 <P>Hello,</P><P> </P><P>I need help with creating 1) horizontal stacked bar chart and then 2) giving certain RGB color to a scale:</P><P> </P><P>here is the dataset I have:</P><TABLE border="1" cellspacing="1" cellpadding="2"><TBODY><TR><TD><P align="left"><FONT face="Calibri" size="3">treatment_group</FONT></P></TD><TD><P align="left"><FONT face="Calibri" size="3">scale</FONT></P></TD><TD><P align="left"><FONT face="Calibri" size="3">percent</FONT></P></TD></TR><TR><TD><P align="left"><FONT face="Calibri" size="3">drug</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">0</FONT></P></TD><TD><P align="left"><FONT face="Calibri" size="3">.</FONT></P></TD></TR><TR><TD><P align="left"><FONT face="Calibri" size="3">drug</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">1</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">2.5</FONT></P></TD></TR><TR><TD><P align="left"><FONT face="Calibri" size="3">drug</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">2</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">2.5</FONT></P></TD></TR><TR><TD><P align="left"><FONT face="Calibri" size="3">drug</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">3</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">12.5</FONT></P></TD></TR><TR><TD><P align="left"><FONT face="Calibri" size="3">drug</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">4</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">24.2</FONT></P></TD></TR><TR><TD><P align="left"><FONT face="Calibri" size="3">drug</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">5</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">23.3</FONT></P></TD></TR><TR><TD><P align="left"><FONT face="Calibri" size="3">drug</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">6</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">9.2</FONT></P></TD></TR><TR><TD><P align="left"><FONT face="Calibri" size="3">drug</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">7</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">25.8</FONT></P></TD></TR><TR><TD><P align="left"><FONT face="Calibri" size="3">control</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">0</FONT></P></TD><TD><P align="left"><FONT face="Calibri" size="3">.</FONT></P></TD></TR><TR><TD><P align="left"><FONT face="Calibri" size="3">control</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">1</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">0.4</FONT></P></TD></TR><TR><TD><P align="left"><FONT face="Calibri" size="3">control</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">2</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">6.0</FONT></P></TD></TR><TR><TD><P align="left"><FONT face="Calibri" size="3">control</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">3</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">12.0</FONT></P></TD></TR><TR><TD><P align="left"><FONT face="Calibri" size="3">control</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">4</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">25.7</FONT></P></TD></TR><TR><TD><P align="left"><FONT face="Calibri" size="3">control</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">5</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">24.1</FONT></P></TD></TR><TR><TD><P align="left"><FONT face="Calibri" size="3">control</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">6</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">12.4</FONT></P></TD></TR><TR><TD><P align="left"><FONT face="Calibri" size="3">control</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">7</FONT></P></TD><TD><P align="right"><FONT face="Calibri" size="3">19.3</FONT></P></TD></TR></TBODY></TABLE><P> </P><P>I would like to create a stacked bar graph HORIZONTAL. Right now, I have it vertical.</P><P><FONT face="Courier New" size="2"> </FONT></P><P><FONT color="#000080" face="Courier New" size="2"><STRONG>proc</STRONG></FONT> <STRONG><FONT color="#000080" face="Courier New" size="2">sgplot</FONT></STRONG> <FONT color="#0000ff" face="Courier New" size="2">data</FONT><FONT face="Courier New" size="2">=a.FreqOut;</FONT></P><P> </P><P><FONT color="#0000ff" face="Courier New" size="2">vbar</FONT><FONT face="Courier New" size="2"> treatment_group/ </FONT><FONT color="#0000ff" face="Courier New" size="2">response</FONT><FONT face="Courier New" size="2">=Percent </FONT><FONT color="#0000ff" face="Courier New" size="2">group</FONT><FONT face="Courier New" size="2">=scale </FONT><FONT color="#0000ff" face="Courier New" size="2">groupdisplay</FONT><FONT face="Courier New" size="2">=stack;</FONT></P><P><FONT color="#0000ff" face="Courier New" size="2">xaxis</FONT> <FONT color="#0000ff" face="Courier New" size="2">discreteorder</FONT><FONT face="Courier New" size="2">=data;</FONT></P><P><FONT color="#0000ff" face="Courier New" size="2">yaxis</FONT> <FONT color="#0000ff" face="Courier New" size="2">grid</FONT> <FONT color="#0000ff" face="Courier New" size="2">values</FONT><FONT face="Courier New" size="2">=(</FONT><STRONG><FONT color="#008080" face="Courier New" size="2">0</FONT></STRONG><FONT face="Courier New" size="2"> to </FONT><STRONG><FONT color="#008080" face="Courier New" size="2">100</FONT></STRONG><FONT face="Courier New" size="2"> by </FONT><STRONG><FONT color="#008080" face="Courier New" size="2">10</FONT></STRONG><FONT face="Courier New" size="2">) </FONT><FONT color="#0000ff" face="Courier New" size="2">label</FONT><FONT face="Courier New" size="2">=</FONT><FONT color="#800080" face="Courier New" size="2">"Percentage of Total"</FONT><FONT face="Courier New" size="2">;</FONT></P><P><FONT color="#000080" face="Courier New" size="2"><STRONG>run</STRONG></FONT><FONT face="Courier New" size="2">;</FONT></P><P> </P><P><FONT face="Courier New" size="2">Also for Each scale, I would like to give a RGB color</FONT></P><P><FONT face="Courier New" size="2">For examples</FONT></P><P><FONT face="Courier New" size="2">- Scale 7 should have certain color:cx9999ff <FONT face="Courier New" size="2"><BR />- Scale 6 should have certain color=cx993366</FONT></FONT></P><P><FONT face="Courier New" size="2"><FONT face="Courier New" size="2">- Scale 5 should have certain color=cxffffcc</FONT></FONT></P><P> </P><P><FONT face="Courier New" size="2"><FONT face="Courier New" size="2">I tried but no luck!</FONT></FONT></P><P><FONT face="Courier New" size="2"><FONT face="Courier New" size="2">pattern1 v=solid color=cx9999ff; <BR />pattern2 v=solid color=cx993366; <BR />pattern3 v=solid color=cxffffcc;  </FONT></FONT></P><P> </P><P><FONT face="Courier New" size="2"><FONT face="Courier New" size="2">Any help would be appreciated!!</FONT></FONT></P> Wed, 05 Dec 2018 01:47:56 GMT https://communities.sas.com/t5/SAS-Programming/proc-sgplot-stacked-bar-chart-horizontal-with-RGB-colors/m-p/518628#M140386 radhikaa4 2018-12-05T01:47:56Z Re: PROC SGPLOT - stacked bar graph - HORIZONTAL and colors https://communities.sas.com/t5/SAS-Programming/proc-sgplot-stacked-bar-chart-horizontal-with-RGB-colors/m-p/518632#M140387 <P>You posted this in SAS VA, are you using SAS Visual Analytics, which is a GUI interface or programming in Base?</P> <P> </P> <P>Assuming you're using Base - Pattern statements apply to SAS/GRAPH not SGPLOT. You can use the STYLEATTRS() to control the colour. You may want a data attribute map, but try adding the following statement after your SGPLOT statement, but before your VBAR statement. </P> <P> </P> <PRE><CODE class=" language-sas">styleattrs datacolors=(cx9999ff cs993366 cxffffcc);</CODE></PRE> <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/153469">@radhikaa4</a> wrote:<BR /> <P>Hello,</P> <P> </P> <P>I need help with creating 1) horizontal stacked bar chart and then 2) giving certain RGB color to a scale:</P> <P> </P> <P>here is the dataset I have:</P> <TABLE border="1" cellspacing="1" cellpadding="2"> <TBODY> <TR> <TD> <P align="left"><FONT face="Calibri" size="3">treatment_group</FONT></P> </TD> <TD> <P align="left"><FONT face="Calibri" size="3">scale</FONT></P> </TD> <TD> <P align="left"><FONT face="Calibri" size="3">percent</FONT></P> </TD> </TR> <TR> <TD> <P align="left"><FONT face="Calibri" size="3">drug</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">0</FONT></P> </TD> <TD> <P align="left"><FONT face="Calibri" size="3">.</FONT></P> </TD> </TR> <TR> <TD> <P align="left"><FONT face="Calibri" size="3">drug</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">1</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">2.5</FONT></P> </TD> </TR> <TR> <TD> <P align="left"><FONT face="Calibri" size="3">drug</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">2</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">2.5</FONT></P> </TD> </TR> <TR> <TD> <P align="left"><FONT face="Calibri" size="3">drug</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">3</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">12.5</FONT></P> </TD> </TR> <TR> <TD> <P align="left"><FONT face="Calibri" size="3">drug</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">4</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">24.2</FONT></P> </TD> </TR> <TR> <TD> <P align="left"><FONT face="Calibri" size="3">drug</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">5</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">23.3</FONT></P> </TD> </TR> <TR> <TD> <P align="left"><FONT face="Calibri" size="3">drug</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">6</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">9.2</FONT></P> </TD> </TR> <TR> <TD> <P align="left"><FONT face="Calibri" size="3">drug</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">7</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">25.8</FONT></P> </TD> </TR> <TR> <TD> <P align="left"><FONT face="Calibri" size="3">control</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">0</FONT></P> </TD> <TD> <P align="left"><FONT face="Calibri" size="3">.</FONT></P> </TD> </TR> <TR> <TD> <P align="left"><FONT face="Calibri" size="3">control</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">1</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">0.4</FONT></P> </TD> </TR> <TR> <TD> <P align="left"><FONT face="Calibri" size="3">control</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">2</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">6.0</FONT></P> </TD> </TR> <TR> <TD> <P align="left"><FONT face="Calibri" size="3">control</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">3</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">12.0</FONT></P> </TD> </TR> <TR> <TD> <P align="left"><FONT face="Calibri" size="3">control</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">4</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">25.7</FONT></P> </TD> </TR> <TR> <TD> <P align="left"><FONT face="Calibri" size="3">control</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">5</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">24.1</FONT></P> </TD> </TR> <TR> <TD> <P align="left"><FONT face="Calibri" size="3">control</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">6</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">12.4</FONT></P> </TD> </TR> <TR> <TD> <P align="left"><FONT face="Calibri" size="3">control</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">7</FONT></P> </TD> <TD> <P align="right"><FONT face="Calibri" size="3">19.3</FONT></P> </TD> </TR> </TBODY> </TABLE> <P> </P> <P>I would like to create a stacked bar graph HORIZONTAL. Right now, I have it vertical.</P> <P><FONT face="Courier New" size="2"> </FONT></P> <P><FONT face="Courier New" size="2" color="#000080"><STRONG>proc</STRONG></FONT> <STRONG><FONT face="Courier New" size="2" color="#000080">sgplot</FONT></STRONG> <FONT face="Courier New" size="2" color="#0000ff">data</FONT><FONT face="Courier New" size="2">=a.FreqOut;</FONT></P> <P> </P> <P><FONT face="Courier New" size="2" color="#0000ff">vbar</FONT><FONT face="Courier New" size="2"> treatment_group/ </FONT><FONT face="Courier New" size="2" color="#0000ff">response</FONT><FONT face="Courier New" size="2">=Percent </FONT><FONT face="Courier New" size="2" color="#0000ff">group</FONT><FONT face="Courier New" size="2">=scale </FONT><FONT face="Courier New" size="2" color="#0000ff">groupdisplay</FONT><FONT face="Courier New" size="2">=stack;</FONT></P> <P><FONT face="Courier New" size="2" color="#0000ff">xaxis</FONT> <FONT face="Courier New" size="2" color="#0000ff">discreteorder</FONT><FONT face="Courier New" size="2">=data;</FONT></P> <P><FONT face="Courier New" size="2" color="#0000ff">yaxis</FONT> <FONT face="Courier New" size="2" color="#0000ff">grid</FONT> <FONT face="Courier New" size="2" color="#0000ff">values</FONT><FONT face="Courier New" size="2">=(</FONT><STRONG><FONT face="Courier New" size="2" color="#008080">0</FONT></STRONG><FONT face="Courier New" size="2"> to </FONT><STRONG><FONT face="Courier New" size="2" color="#008080">100</FONT></STRONG><FONT face="Courier New" size="2"> by </FONT><STRONG><FONT face="Courier New" size="2" color="#008080">10</FONT></STRONG><FONT face="Courier New" size="2">) </FONT><FONT face="Courier New" size="2" color="#0000ff">label</FONT><FONT face="Courier New" size="2">=</FONT><FONT face="Courier New" size="2" color="#800080">"Percentage of Total"</FONT><FONT face="Courier New" size="2">;</FONT></P> <P><FONT face="Courier New" size="2" color="#000080"><STRONG>run</STRONG></FONT><FONT face="Courier New" size="2">;</FONT></P> <P> </P> <P><FONT face="Courier New" size="2">Also for Each scale, I would like to give a RGB color</FONT></P> <P><FONT face="Courier New" size="2">For examples</FONT></P> <P><FONT face="Courier New" size="2">- Scale 7 should have certain color:cx9999ff <FONT face="Courier New" size="2"><BR />- Scale 6 should have certain color=cx993366</FONT></FONT></P> <P><FONT face="Courier New" size="2"><FONT face="Courier New" size="2">- Scale 5 should have certain color=cxffffcc</FONT></FONT></P> <P> </P> <P><FONT face="Courier New" size="2"><FONT face="Courier New" size="2">I tried but no luck!</FONT></FONT></P> <P><FONT face="Courier New" size="2"><FONT face="Courier New" size="2">pattern1 v=solid color=cx9999ff; <BR />pattern2 v=solid color=cx993366; <BR />pattern3 v=solid color=cxffffcc;  </FONT></FONT></P> <P> </P> <P><FONT face="Courier New" size="2"><FONT face="Courier New" size="2">Any help would be appreciated!!</FONT></FONT></P> <HR /></BLOCKQUOTE> <P><BR /><BR /></P> Wed, 05 Dec 2018 02:16:40 GMT https://communities.sas.com/t5/SAS-Programming/proc-sgplot-stacked-bar-chart-horizontal-with-RGB-colors/m-p/518632#M140387 Reeza 2018-12-05T02:16:40Z