proc sgplot: valuesformat= vs. variable format

[xxformat_com]

Hi,

I was not anticipating any difference on the x-axis (when using valuesformat= or variable format) but there is one for the missing category.

Do you have any thought on this?

proc format;
    value $sex 'M'='Male'
               'F'='Female'
               ' '='Missing';
run;

data class;
    set sashelp.class;
    output;
    if _n_=1 then
       do;
           sex=' ';
           output;
       end;
run;

proc sgplot data=class;
    vbarbasic sex / response=height stat=mean missing;
    format sex $sex.;
run; 

proc sgplot data=class;
    vbarbasic sex / response=height stat=mean missing;
    xaxis valuesformat=$sex.;
run;    

[Ksharp · Accepted solution]

It seems that option valuesformat= did not honor MISSING value of character variable. Try another way:

proc format;
    value $sex 'M'='Male'
               'F'='Female'
               other='Missing';
run;

You could report this weird phnomenon to sas support.

[xxformat_com]

I've just created a ticket by the tech support.