topic Re: Descending Y Axis SGPanel with Hbar in Graphics Programming

topic Re: Descending Y Axis SGPanel with Hbar in Graphics Programming https://communities.sas.com/t5/Graphics-Programming/Descending-Y-Axis-SGPanel-with-Hbar/m-p/183644#M6768 <HTML><HEAD></HEAD><BODY><P>It worked the key was the <SPAN style="color: #000000; font-family: 'Courier New'; font-size: 15px; background-color: #ffffff;">discreteorder=data.</SPAN></P></BODY></HTML> Thu, 15 Jan 2015 17:59:10 GMT DavidPhillips2 2015-01-15T17:59:10Z Descending Y Axis SGPanel with Hbar https://communities.sas.com/t5/Graphics-Programming/Descending-Y-Axis-SGPanel-with-Hbar/m-p/183637#M6761 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 11.0pt; font-family: 'Arial',sans-serif; color: black; background: white;">I found a number of examples online for sorting the y-axis using the word descending but not for sgpanel / vbar, hbar.  </SPAN></P><P><SPAN style="font-size: 11.5pt; font-family: 'Arial',sans-serif; color: black; background: white;">In some cases sorting the data first helped in others descending just needed to be used with the hbar line.</SPAN></P><P><SPAN style="font-size: 11.0pt; font-family: 'Arial',sans-serif; color: black; background: white;">Can this be done?</SPAN></P><P><SPAN style="font-size: 11.0pt; font-family: 'Arial',sans-serif; color: black; background: white;"> </SPAN></P><P><SPAN style="font-size: 11.0pt; font-family: 'Arial',sans-serif; color: black; background: white;">My objective is</SPAN></P><P><SPAN style="font-size: 11.0pt; font-family: 'Arial',sans-serif; color: black; background: white;"> </SPAN></P><P><SPAN style="font-size: 11.0pt; font-family: 'Arial',sans-serif; color: black; background: white;">Year</SPAN></P><TABLE border="1" cellpadding="0" cellspacing="0" style="border: none;"><TBODY><TR><TD style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="208"><P><SPAN style="font-size: 11.0pt; font-family: 'Arial',sans-serif; color: black; background: white;">2005</SPAN></P><P><SPAN style="font-size: 11.0pt; font-family: 'Arial',sans-serif; color: black; background: white;">2004</SPAN></P><P><SPAN style="font-size: 11.0pt; font-family: 'Arial',sans-serif; color: black; background: white;">2003</SPAN></P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="208"><P><SPAN style="font-size: 11.0pt; font-family: 'Arial',sans-serif; color: black; background: white;">2005 bar group1</SPAN></P><P><SPAN style="font-size: 11.0pt; font-family: 'Arial',sans-serif; color: black; background: white;">2004 bar group1</SPAN></P><P><SPAN style="font-size: 11.0pt; font-family: 'Arial',sans-serif; color: black; background: white;">2003 bar group1</SPAN></P><P><SPAN style="background: white; font-size: 10pt; text-decoration: line-through; font-family: Helvetica, sans-serif;"> </SPAN></P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="208"><P><SPAN style="font-size: 11.0pt; font-family: 'Arial',sans-serif; color: black; background: white;">2005 bar group2</SPAN></P><P><SPAN style="font-size: 11.0pt; font-family: 'Arial',sans-serif; color: black; background: white;">2004 bar group2</SPAN></P><P><SPAN style="font-size: 11.0pt; font-family: 'Arial',sans-serif; color: black; background: white;">2003 bar group2</SPAN></P><P><SPAN style="background: white; font-size: 10pt; text-decoration: line-through; font-family: Helvetica, sans-serif;"> </SPAN></P></TD></TR></TBODY></TABLE><P><SPAN style="background: white; font-size: 10pt; text-decoration: line-through; font-family: Helvetica, sans-serif;"> </SPAN></P><P><STRONG style="color: navy; background: white; font-size: 11.0pt; font-family: 'Courier New';">proc</STRONG> <STRONG style="color: navy; background: white; font-size: 11.0pt; font-family: 'Courier New';">sort</STRONG> <SPAN style="font-size: 11.0pt; font-family: 'Courier New'; color: blue; background: white;">data</SPAN><SPAN style="font-size: 11.0pt; font-family: 'Courier New'; color: black; background: white;">=enrollment;</SPAN></P><P>           <SPAN style="font-size: 11.0pt; font-family: 'Courier New'; color: blue; background: white;">by</SPAN> <SPAN style="font-size: 11.0pt; font-family: 'Courier New'; color: blue; background: white;">descending</SPAN><SPAN style="font-size: 11.0pt; font-family: 'Courier New'; color: black; background: white;"> FOUR_DIGIT_YEAR;</SPAN></P><P><STRONG style="color: navy; background: white; font-size: 11.0pt; font-family: 'Courier New';">run</STRONG><SPAN style="font-size: 11.0pt; font-family: 'Courier New'; color: black; background: white;">;</SPAN></P><P><STRONG style="color: navy; background: white; font-size: 11.0pt; font-family: 'Courier New';"> </STRONG></P><P><STRONG style="color: navy; background: white; font-size: 11.0pt; font-family: 'Courier New';">proc</STRONG> <STRONG style="color: navy; background: white; font-size: 11.0pt; font-family: 'Courier New';">sgpanel</STRONG> <SPAN style="font-size: 11.0pt; font-family: 'Courier New'; color: blue; background: white;">data</SPAN><SPAN style="font-size: 11.0pt; font-family: 'Courier New'; color: black; background: white;">=enrollment;</SPAN></P><P style="margin-left: .5in;"><SPAN style="font-size: 11.0pt; font-family: 'Courier New'; color: blue; background: white;">panelby</SPAN><SPAN style="font-size: 11.0pt; font-family: 'Courier New'; color: black; background: white;"> residency_desc/ </SPAN><SPAN style="font-size: 11.0pt; font-family: 'Courier New'; color: blue; background: white;">novarname</SPAN> <SPAN style="font-size: 11.0pt; font-family: 'Courier New'; color: blue; background: white;">uniscale</SPAN><SPAN style="font-size: 11.0pt; font-family: 'Courier New'; color: black; background: white;">=row  </SPAN><SPAN style="font-size: 11.0pt; font-family: 'Courier New'; color: blue; background: white;">layout</SPAN><SPAN style="font-size: 11.0pt; font-family: 'Courier New'; color: black; background: white;">=columnlattice; </SPAN></P><P style="margin-left: .5in;"><SPAN style="font-size: 11.0pt; font-family: 'Courier New'; color: blue; background: white;">hbar</SPAN><SPAN style="font-size: 11.0pt; font-family: 'Courier New'; color: black; background: white;"> FOUR_DIGIT_YEAR / </SPAN><SPAN style="font-size: 11.0pt; font-family: 'Courier New'; color: blue; background: white;">response</SPAN><SPAN style="font-size: 11.0pt; font-family: 'Courier New'; color: black; background: white;">=STUDENTS_ENROLLED </SPAN><SPAN style="font-size: 11.0pt; font-family: 'Courier New'; color: blue; background: white;">stat</SPAN><SPAN style="font-size: 11.0pt; font-family: 'Courier New'; color: black; background: white;">=sum </SPAN><SPAN style="font-size: 11.0pt; font-family: 'Courier New'; color: blue; background: white;">group</SPAN><SPAN style="font-size: 11.0pt; font-family: 'Courier New'; color: black; background: white;">=degree_level /*<SPAN style="color: #000000; font-family: Arial, sans-serif; font-size: 15px; background-color: #ffffff;">descending*/</SPAN>;</SPAN></P><P>     <SPAN style="font-size: 11.0pt; font-family: 'Courier New'; color: blue; background: white;">keylegend</SPAN><SPAN style="font-size: 11.0pt; font-family: 'Courier New'; color: black; background: white;"> / </SPAN><SPAN style="font-size: 11.0pt; font-family: 'Courier New'; color: blue; background: white;">position</SPAN><SPAN style="font-size: 11.0pt; font-family: 'Courier New'; color: black; background: white;">=right </SPAN><SPAN style="font-size: 11.0pt; font-family: 'Courier New'; color: blue; background: white;">noborder</SPAN><SPAN style="font-size: 11.0pt; font-family: 'Courier New'; color: black; background: white;">;</SPAN></P><P><STRONG style="color: navy; background: white; font-size: 11.0pt; font-family: 'Courier New';">run</STRONG><SPAN style="font-size: 11.0pt; font-family: 'Courier New'; color: black; background: white;">;</SPAN></P></BODY></HTML> Wed, 14 Jan 2015 22:03:21 GMT https://communities.sas.com/t5/Graphics-Programming/Descending-Y-Axis-SGPanel-with-Hbar/m-p/183637#M6761 DavidPhillips2 2015-01-14T22:03:21Z Re: Descending Y Axis SGPanel with Hbar https://communities.sas.com/t5/Graphics-Programming/Descending-Y-Axis-SGPanel-with-Hbar/m-p/183638#M6762 <HTML><HEAD></HEAD><BODY><P>Drop the PROC SORT and see if this works for you. If it doesn't, please post a picture of your current result:</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: #ffffff;"><SPAN style="font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: navy; background-position: initial;"><STRONG>proc</STRONG></SPAN> <SPAN style="font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: navy; background-position: initial;"><STRONG>sgpanel</STRONG></SPAN> <SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: blue; background-position: initial;">data</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: black; background-position: initial;">=enrollment;</SPAN></P><P style="margin: 0 0 0 0.5in; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: #ffffff;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: blue; background-position: initial;">panelby</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: black; background-position: initial;"> residency_desc/ </SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: blue; background-position: initial;">novarname</SPAN> <SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: blue; background-position: initial;">uniscale</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: black; background-position: initial;">=row  </SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: blue; background-position: initial;">layout</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: black; background-position: initial;">=columnlattice;</SPAN></P><P style="margin: 0 0 0 0.5in; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: #ffffff;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: blue; background-position: initial;">hbar</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: black; background-position: initial;"> FOUR_DIGIT_YEAR / </SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: blue; background-position: initial;">response</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: black; background-position: initial;">=STUDENTS_ENROLLED </SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: blue; background-position: initial;">stat</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: black; background-position: initial;">=sum </SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: blue; background-position: initial;">group</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: black; background-position: initial;">=degree_level /*<SPAN style="font-weight: inherit; font-style: inherit; font-family: Arial, sans-serif;">descending*/</SPAN>;</SPAN></P><P style="margin: 0 0 0 0.5in; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: #ffffff;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: black; background-position: initial;">rowaxis reverse;<BR /></SPAN></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: #ffffff;">     <SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: blue; background-position: initial;">keylegend</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: black; background-position: initial;"> / </SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: blue; background-position: initial;">position</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: black; background-position: initial;">=right </SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: blue; background-position: initial;">noborder</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: black; background-position: initial;">;</SPAN></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: #ffffff;"><SPAN style="font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: navy; background-position: initial;"><STRONG>run</STRONG></SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: black; background-position: initial;">;</SPAN></P></BODY></HTML> Wed, 14 Jan 2015 22:12:42 GMT https://communities.sas.com/t5/Graphics-Programming/Descending-Y-Axis-SGPanel-with-Hbar/m-p/183638#M6762 DanH_sas 2015-01-14T22:12:42Z Re: Descending Y Axis SGPanel with Hbar https://communities.sas.com/t5/Graphics-Programming/Descending-Y-Axis-SGPanel-with-Hbar/m-p/183639#M6763 <HTML><HEAD></HEAD><BODY><P>That should have been ROWAXIS, not YAXIS. I fixed the code.</P></BODY></HTML> Wed, 14 Jan 2015 22:13:34 GMT https://communities.sas.com/t5/Graphics-Programming/Descending-Y-Axis-SGPanel-with-Hbar/m-p/183639#M6763 DanH_sas 2015-01-14T22:13:34Z Re: Descending Y Axis SGPanel with Hbar https://communities.sas.com/t5/Graphics-Programming/Descending-Y-Axis-SGPanel-with-Hbar/m-p/183640#M6764 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 11.0pt; font-family: 'Arial',sans-serif; color: black; background: white;">When I use reverse I receive an error.  It is not an option…</SPAN></P><P></P><P>proc sql noprint;</P><P>CREATE TABLE enrollment (</P><P>  FOUR_DIGIT_YEAR varchar(50),</P><P>  STUDENTS_ENROLLED int,</P><P>  residency_desc varchar(50)</P><P>);</P><P></P><P></P><P>/*panel one data*/</P><P>INSERT INTO enrollment</P><P>  (FOUR_DIGIT_YEAR, STUDENTS_ENROLLED, residency_desc)</P><P>VALUES</P><P>  ('2001', 234, '1');</P><P>INSERT INTO enrollment</P><P>  (FOUR_DIGIT_YEAR, STUDENTS_ENROLLED, residency_desc)</P><P>VALUES</P><P>  ('2002', 345, '1');</P><P>INSERT INTO enrollment</P><P>  (FOUR_DIGIT_YEAR, STUDENTS_ENROLLED, residency_desc)</P><P>VALUES</P><P>  ('2003', 584, '1');</P><P></P><P></P><P>/*panel two data*/</P><P>INSERT INTO enrollment</P><P>  (FOUR_DIGIT_YEAR, STUDENTS_ENROLLED, residency_desc)</P><P>VALUES</P><P>  ('2001', 465, '2');</P><P>INSERT INTO enrollment</P><P>  (FOUR_DIGIT_YEAR, STUDENTS_ENROLLED, residency_desc)</P><P>VALUES</P><P>  ('2002', 344, '2');</P><P>INSERT INTO enrollment</P><P>  (FOUR_DIGIT_YEAR, STUDENTS_ENROLLED, residency_desc)</P><P>VALUES</P><P>  ('2003', 200, '2');</P><P>quit;</P><P></P><P></P><P>proc sgpanel data=enrollment;</P><P> panelby residency_desc / novarname uniscale=row  layout=columnlattice;</P><P>  hbar FOUR_DIGIT_YEAR / response=STUDENTS_ENROLLED stat=sum group=residency_desc;</P><P>  rowaxis label='Academic Year';</P><P>  colaxis label=' ';</P><P>  keylegend / position=right noborder;</P><P>run;</P><P></P><P><IMG alt="panel.png" class="jive-image-thumbnail jive-image" src="https://communities.sas.com/legacyfs/online/8716_panel.png" width="450" /></P></BODY></HTML> Thu, 15 Jan 2015 16:15:56 GMT https://communities.sas.com/t5/Graphics-Programming/Descending-Y-Axis-SGPanel-with-Hbar/m-p/183640#M6764 DavidPhillips2 2015-01-15T16:15:56Z Re: Descending Y Axis SGPanel with Hbar https://communities.sas.com/t5/Graphics-Programming/Descending-Y-Axis-SGPanel-with-Hbar/m-p/183641#M6765 <HTML><HEAD></HEAD><BODY><P>What version of SAS are you running?</P></BODY></HTML> Thu, 15 Jan 2015 16:18:09 GMT https://communities.sas.com/t5/Graphics-Programming/Descending-Y-Axis-SGPanel-with-Hbar/m-p/183641#M6765 DanH_sas 2015-01-15T16:18:09Z Re: Descending Y Axis SGPanel with Hbar https://communities.sas.com/t5/Graphics-Programming/Descending-Y-Axis-SGPanel-with-Hbar/m-p/183642#M6766 <HTML><HEAD></HEAD><BODY><P>9.2</P></BODY></HTML> Thu, 15 Jan 2015 16:22:12 GMT https://communities.sas.com/t5/Graphics-Programming/Descending-Y-Axis-SGPanel-with-Hbar/m-p/183642#M6766 DavidPhillips2 2015-01-15T16:22:12Z Re: Descending Y Axis SGPanel with Hbar https://communities.sas.com/t5/Graphics-Programming/Descending-Y-Axis-SGPanel-with-Hbar/m-p/183643#M6767 <HTML><HEAD></HEAD><BODY><P>Nevermind, I just saw in another of your posts that you are running SAS 9.2. I think the REVERSE option was added in SAS 9.3. As an alternative, if you presort *all* of the "class" variables in sgpanel, then SGPANEL will not auto sort the data. In addition, you'll need to tell the axis to stay in data order. The code will look something like this:</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: #ffffff;"><SPAN style="font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: navy; background-position: initial;"><STRONG>proc</STRONG></SPAN> <SPAN style="font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: navy; background-position: initial;"><STRONG>sort</STRONG></SPAN> <SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: blue; background-position: initial;">data</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: black; background-position: initial;">=enrollment;</SPAN></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: #ffffff;">           <SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: blue; background-position: initial;">by</SPAN> <SPAN style="color: #000000; font-family: 'Courier New'; font-size: 15px; background-color: #ffffff;">residency_desc </SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: blue; background-position: initial;">descending</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: black; background-position: initial;"> FOUR_DIGIT_YEAR;</SPAN></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: #ffffff;"><SPAN style="font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: navy; background-position: initial;"><STRONG>run</STRONG></SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: black; background-position: initial;">;</SPAN></P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: #ffffff;"><SPAN style="font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: navy; background-position: initial;"><STRONG>proc</STRONG></SPAN> <SPAN style="font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: navy; background-position: initial;"><STRONG>sgpanel</STRONG></SPAN> <SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: blue; background-position: initial;">data</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: black; background-position: initial;">=enrollment;</SPAN></P><P style="margin: 0 0 0 0.5in; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: #ffffff;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: blue; background-position: initial;">panelby</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: black; background-position: initial;"> residency_desc/ </SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: blue; background-position: initial;">novarname</SPAN> <SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: blue; background-position: initial;">uniscale</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: black; background-position: initial;">=row  </SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: blue; background-position: initial;">layout</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: black; background-position: initial;">=columnlattice;</SPAN></P><P style="margin: 0 0 0 0.5in; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: #ffffff;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: black; background-position: initial;">rowaxis discreteorder=data;<BR /></SPAN></P><P style="margin: 0 0 0 0.5in; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: #ffffff;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: blue; background-position: initial;">hbar</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: black; background-position: initial;"> FOUR_DIGIT_YEAR / </SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: blue; background-position: initial;">response</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: black; background-position: initial;">=STUDENTS_ENROLLED </SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: blue; background-position: initial;">stat</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: black; background-position: initial;">=sum </SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: blue; background-position: initial;">group</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: black; background-position: initial;">=degree_level /*<SPAN style="font-weight: inherit; font-style: inherit; font-family: Arial, sans-serif;">descending*/</SPAN>;</SPAN></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: #ffffff;">     <SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: blue; background-position: initial;">keylegend</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: black; background-position: initial;"> / </SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: blue; background-position: initial;">position</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: black; background-position: initial;">=right </SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: blue; background-position: initial;">noborder</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: black; background-position: initial;">;</SPAN></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: #ffffff;"><SPAN style="font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: navy; background-position: initial;"><STRONG>run</STRONG></SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: 'Courier New'; color: black; background-position: initial;">;</SPAN></P></BODY></HTML> Thu, 15 Jan 2015 16:30:56 GMT https://communities.sas.com/t5/Graphics-Programming/Descending-Y-Axis-SGPanel-with-Hbar/m-p/183643#M6767 DanH_sas 2015-01-15T16:30:56Z Re: Descending Y Axis SGPanel with Hbar https://communities.sas.com/t5/Graphics-Programming/Descending-Y-Axis-SGPanel-with-Hbar/m-p/183644#M6768 <HTML><HEAD></HEAD><BODY><P>It worked the key was the <SPAN style="color: #000000; font-family: 'Courier New'; font-size: 15px; background-color: #ffffff;">discreteorder=data.</SPAN></P></BODY></HTML> Thu, 15 Jan 2015 17:59:10 GMT https://communities.sas.com/t5/Graphics-Programming/Descending-Y-Axis-SGPanel-with-Hbar/m-p/183644#M6768 DavidPhillips2 2015-01-15T17:59:10Z