topic Re: Why does xaxis value not work in SAS Programming

Why does xaxis value not work

GS2 — Mon, 07 Dec 2020 17:34:31 GMT

Using SAS 9.4

I am running the following code:

proc format;
value $ funcfmt "X"="A-Severly Abnormal"
"Abnormal"="B-Abnormal"
"Nearly normal"="C-Nearly normal"
"Normal"="D-Normal";
run;

proc summary data= peroneal.labeled nway completetypes;
class ratecurrent_level_func / preloadfmt order=formated missing;
format ratecurrent_level_func $funcfmt.;
output out=counts;
run;

overall current level of function;
options reset=all ;
ods graphics on /
imagefmt=tiff
imagename="Overall, Current Level of Function"
width=15cm
noborder;
ods listing gpath= "path" image_dpi=300 ;
proc sgplot data=counts;
format ratecurrent_level_func $funcfmt.;
title 'Overall, Current Level of Function';
vbarparm category=ratecurrent_level_func response=_FREQ_ / nozerobars;
yaxis grid label='Percent';
xaxis values=("Severly Abnormal" "Abormal" "Nearly Normal" "Normal");
run;

run;
ods graphics off;

I am trying to get a bar graph with the data in order from severly abnormal, abnormal, nearly normal and normal. So I used the format to get the data in that order; however, I do not want "A-", "B-" etc precedding the value name so I used the xaxis values. When I do this it distorts the graph? Does anyone know what I am doing incorrectly? I have attached a word document with an example of each graph. The first one is correct other than the labels are inaccurate and the second is what happens when I add the xaxis values statement. Thank you

Re: Why does xaxis value not work

PaigeMiller — Mon, 07 Dec 2020 17:58:46 GMT

I do not download attachments, as they can be a security threat. So please include your graph in your reply by clicking on the camera icon.

however, I do not want "A-", "B-" etc precedding the value name

Then don't put them in your format. If you are putting them there to force the proper order on the x-axis, then in PROC SGPLOT you can use the VALUES= option of the XAXIS statement. There is an example here: https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.4&docsetId=grstatproc&docsetTarget=p07m2vpyq75fgan14m6g5pphnwlr.htm&locale=en#n09f4ln7jq8gkan1w2nhlkzjcrqza (scroll down)

Re: Why does xaxis value not work

GS2 — Mon, 07 Dec 2020 18:02:21 GMT

The first is the correct version and my code will produce without the xaxis values statement. When I include xaxis value the second graph is produced

Re: Why does xaxis value not work

PaigeMiller — Mon, 07 Dec 2020 18:10:41 GMT

Please show us the LOG from your code, starting at PROC FORMAT and then all the way down to the NOTES after PROC SGPLOT. Do not chop anything out.

Follow these instructions exactly: Copy the log as text, then paste it into the window that appears when you click on the </> icon. DO NOT SKIP THIS STEP.

Re: Why does xaxis value not work

GS2 — Mon, 07 Dec 2020 18:17:20 GMT

64  proc format;
2465      value $ funcfmt "X"="A-Severly Abnormal"
2466                      "Abnormal"="B-Abnormal"
2467                     "Nearly normal"="C-Nearly normal"
2468                     "Normal"="D-Normal";
NOTE: Format $FUNCFMT is already on the library WORK.FORMATS.
NOTE: Format $FUNCFMT has been output.
2469  run;

NOTE: PROCEDURE FORMAT used (Total process time):
      real time           0.00 seconds
      cpu time            0.01 seconds


2470
2471  proc summary data= peroneal.labeled nway completetypes;
2472     class ratecurrent_level_func / preloadfmt order=formated missing;
2473     format ratecurrent_level_func $funcfmt.;
2474     output out=counts;
2475  run;

NOTE: There were 51 observations read from the data set PERONEAL.LABELED.
NOTE: The data set WORK.COUNTS has 4 observations and 3 variables.
NOTE: PROCEDURE SUMMARY used (Total process time):
      real time           0.04 seconds
      cpu time            0.06 seconds


2476
2477  *overall current level of function;
2478  options reset=all ;
              -----
              13
ERROR 13-12: Unrecognized SAS option name RESET.
2479  ods graphics on /
2480  imagefmt=tiff
2481  imagename="Overall, Current Level of Function"
WARNING: The IMAGENAME option or the output name contains invalid characters. Overall_ Current
         Level of Function will be used as the image name prefix.
2482  width=15cm
2483  noborder;
2484  ods listing gpath= "C:\Users\gscar\Desktop\FA094 Peroneal Subluxation\Tables" image_dpi=300
2484! ;
2485  proc sgplot data=counts;
2486      format ratecurrent_level_func $funcfmt.;
2487      title 'Overall, Current Level of Function';
2488      vbarparm category=ratecurrent_level_func response=_FREQ_ / nozerobars;
2489      yaxis grid label='Percent';
2490      xaxis values=("Severly Abnormal" "Abormal" "Nearly Normal" "Normal");
2491  run;

NOTE: Writing HTML Body file: sashtml4.htm
NOTE: PROCEDURE SGPLOT used (Total process time):
      real time           0.83 seconds
      cpu time            0.50 seconds

WARNING: HTML4 destination does not support TIFF images. Using the default static format.
NOTE: Listing image output written to C:\Users\gscar\Desktop\FA094 Peroneal
      Subluxation\Tables\Overall_ Current Level of Function9.tiff.
NOTE: There were 4 observations read from the data set WORK.COUNTS.

2492  ods graphics off;

Log of the distorted graph above

Log of correct graph below

2493  proc format;
2494      value $ funcfmt "X"="A-Severly Abnormal"
2495                      "Abnormal"="B-Abnormal"
2496                     "Nearly normal"="C-Nearly normal"
2497                     "Normal"="D-Normal";
NOTE: Format $FUNCFMT is already on the library WORK.FORMATS.
NOTE: Format $FUNCFMT has been output.
2498  run;

NOTE: PROCEDURE FORMAT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds


2499
2500  proc summary data= peroneal.labeled nway completetypes;
2501     class ratecurrent_level_func / preloadfmt order=formated missing;
2502     format ratecurrent_level_func $funcfmt.;
2503     output out=counts;
2504  run;

NOTE: There were 51 observations read from the data set PERONEAL.LABELED.
NOTE: The data set WORK.COUNTS has 4 observations and 3 variables.
NOTE: PROCEDURE SUMMARY used (Total process time):
      real time           0.05 seconds
      cpu time            0.06 seconds


2505
2506  *overall current level of function;
2507  options reset=all ;
              -----
              13
ERROR 13-12: Unrecognized SAS option name RESET.
2508  ods graphics on /
2509  imagefmt=tiff
2510  imagename="Overall, Current Level of Function"
WARNING: The IMAGENAME option or the output name contains invalid characters. Overall_ Current
         Level of Function will be used as the image name prefix.
2511  width=15cm
2512  noborder;
2513  ods listing gpath= "C:\Users\gscar\Desktop\FA094 Peroneal Subluxation\Tables" image_dpi=300
2513! ;
2514  proc sgplot data=counts;
2515      format ratecurrent_level_func $funcfmt.;
2516      title 'Overall, Current Level of Function';
2517      vbarparm category=ratecurrent_level_func response=_FREQ_ / nozerobars;
2518      yaxis grid label='Percent';
2519      *xaxis values=("Severly Abnormal" "Abormal" "Nearly Normal" "Normal");
2520  run;

NOTE: PROCEDURE SGPLOT used (Total process time):
      real time           0.23 seconds
      cpu time            0.09 seconds

WARNING: HTML4 destination does not support TIFF images. Using the default static format.
NOTE: Listing image output written to C:\Users\gscar\Desktop\FA094 Peroneal
      Subluxation\Tables\Overall_ Current Level of Function11.tiff.
NOTE: There were 4 observations read from the data set WORK.COUNTS.

2521  ods graphics off;

Re: Why does xaxis value not work

PaigeMiller — Mon, 07 Dec 2020 19:10:53 GMT

Eliminate the format. Do not apply it in PROC SUMMARY or anywhere else.

In PROC SGPLOT, use:

xaxis values=("Severly Abnormal" "Abormal" "Nearly Normal" "Normal");

and make sure the spelling and capitalization in the XAXIS statement match exactly what is in your data set peroneal.labeled (there are at least two spelling errors and one place where the capitalization changes throughout your code, but the code must match the data)

Re: Why does xaxis value not work

ballardw — Mon, 07 Dec 2020 19:26:58 GMT

Don't apply the format if you do not want that appearance, or create a different format without the A- B- C-.

Spelling counts: Look closely at your Values and see if you find a spelling problem with the second value.

Also from your format definition then there appears that you do not have a Value = "Severely Abnormal".

From the documentation of the Values option in the Xaxis statement:

If a custom format is applied to the value, the raw value is plotted first and then formatted.

Which means that the VALUES you list must be exactly as they appear in the data for character values.

Re: Why does xaxis value not work

GS2 — Mon, 07 Dec 2020 19:33:34 GMT

That is correct. There is no value for 'severely abnormal' , I am trying to show a zero in that column and report the others but in a specific order.

Re: Why does xaxis value not work

PaigeMiller — Mon, 07 Dec 2020 21:28:57 GMT

@GS2 wrote:
That is correct. There is no value for 'severely abnormal' , I am trying to show a zero in that column and report the others but in a specific order.

You will need to use the PRELOADFMT option of the CLASS statement. Example: https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=proc&docsetTarget=n1eseaucwkzo18n1nph31op5kkdt.htm&locale=en#n1eseaucwkzo18n1nph31op5kkdt


	If a custom format is applied to the value, the raw value is plotted first and then formatted.