topic Re: proc sgplot: valuesformat= vs. variable format in Graphics Programming

proc sgplot: valuesformat= vs. variable format

xxformat_com — Wed, 04 Sep 2024 07:14:26 GMT

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;

Re: proc sgplot: valuesformat= vs. variable format

Ksharp — Wed, 04 Sep 2024 08:31:26 GMT

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.

Re: proc sgplot: valuesformat= vs. variable format

xxformat_com — Wed, 04 Sep 2024 12:50:21 GMT

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