topic Re: Proc sgplot/Tickvalueformat problem in Graphics Programming https://communities.sas.com/t5/Graphics-Programming/Proc-sgplot-Tickvalueformat-problem/m-p/214928#M8022 <HTML><HEAD></HEAD><BODY><P>Thank you so much! </P></BODY></HTML> Fri, 31 Jul 2015 18:37:43 GMT Greek 2015-07-31T18:37:43Z Proc sgplot/Tickvalueformat problem https://communities.sas.com/t5/Graphics-Programming/Proc-sgplot-Tickvalueformat-problem/m-p/214926#M8020 <HTML><HEAD></HEAD><BODY><P>Good morning, </P><P></P><P>I am trying to figure out why isn't the option "tickvalueformat" working. I modified my code for your convenience by adding a step with datalines. It should run without you having to do anything. I get numbers 3-7 in the xaxis instead of the months March-July...</P><P></P><P>Does anybody know what's wrong?</P><P></P><P>data vbar;</P><P>length combined $30;</P><P>input month $ month_numeric combined $ Hours @@; </P><P>datalines; </P><P>March&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp; compensation&nbsp;&nbsp;&nbsp; 148.9</P><P>March&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp; projects&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 31.1</P><P>April&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp; compensation&nbsp;&nbsp;&nbsp; 148.5</P><P>April&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp; projects&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 36.5</P><P>May&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp; compensation&nbsp;&nbsp;&nbsp; 114.9</P><P>May&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp; projects&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50.3</P><P>June&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp; compensation&nbsp;&nbsp;&nbsp; 73.7</P><P>June&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp; projects&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 113.4</P><P>July&nbsp;&nbsp;&nbsp; 7&nbsp;&nbsp;&nbsp; compensation&nbsp;&nbsp;&nbsp; 102.3</P><P>July&nbsp;&nbsp;&nbsp; 7&nbsp;&nbsp;&nbsp; projects&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 73.8</P><P>run;</P><P></P><P></P><P>proc format;</P><P>value monthly</P><P>3='March'</P><P>4='April'</P><P>5='May'</P><P>6='June'</P><P>7='July'</P><P>;</P><P>run;</P><P></P><P>proc sgplot data=vbar;</P><P>vbar month_numeric/response=hours group=combined groupdisplay=cluster;</P><P>xaxis tickvalueformat=monthly;</P><P>run;</P></BODY></HTML> Fri, 31 Jul 2015 15:41:31 GMT https://communities.sas.com/t5/Graphics-Programming/Proc-sgplot-Tickvalueformat-problem/m-p/214926#M8020 Greek 2015-07-31T15:41:31Z Re: Proc sgplot/Tickvalueformat problem https://communities.sas.com/t5/Graphics-Programming/Proc-sgplot-Tickvalueformat-problem/m-p/214927#M8021 <HTML><HEAD></HEAD><BODY><P>Do it this way, and it will work for you:</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: #ffffff;">proc sgplot data=vbar;</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: #ffffff;">format month_numeric monthly.;</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: #ffffff;">vbar month_numeric/response=hours group=combined groupdisplay=cluster;</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: #ffffff;"><SPAN style="font-size: 10pt; line-height: 1.5em;">run;</SPAN></P></BODY></HTML> Fri, 31 Jul 2015 17:10:03 GMT https://communities.sas.com/t5/Graphics-Programming/Proc-sgplot-Tickvalueformat-problem/m-p/214927#M8021 DanH_sas 2015-07-31T17:10:03Z Re: Proc sgplot/Tickvalueformat problem https://communities.sas.com/t5/Graphics-Programming/Proc-sgplot-Tickvalueformat-problem/m-p/214928#M8022 <HTML><HEAD></HEAD><BODY><P>Thank you so much! </P></BODY></HTML> Fri, 31 Jul 2015 18:37:43 GMT https://communities.sas.com/t5/Graphics-Programming/Proc-sgplot-Tickvalueformat-problem/m-p/214928#M8022 Greek 2015-07-31T18:37:43Z