anyone know how to get rid of duplicate x-axis values with not value in sas

[hlamoureux]

[ballardw · Accepted solution]

Show your code for the graph

What is the format for the x-axis variable.

This sort of behavior usually points to a format that does not display decimals and the axis wants to use decimals because of the range of values.

Fixes could be supply a Values= list on an xaxis statement, make the axis discrete which is often appropriate for Code values, change the format to display decimals

Which is best depends on the actual data involved.

[hlamoureux]

data LUscores;
set WORK.'lu scores'n;
format sid 8.6;
format fpdtop 8.6;


sid=sidscore*1;

FPDtop=fpdScoreTOP*1;







run;
proc univariate data=luscores;
var

SID

fpdTOP
converted_PBJ_FUNDED_RATE

Factor_trust_BAI_score
DNAccountValidationScore
FraudPoint
FPDMIDScore
NCGNSMIDScore
FTCheckAdvisorScore
LendProtectScore
PMTScore
FPDScore
;
histogram;
run;

[ballardw]

If you want Proc Univariate to only display single values try adding the MIDPOINT option to your Histogram statement.

I think from your given picture this might work if your values are only integers 0 to 6.

Histogram  /midpoints=0  1 2 3 4 5 6;

If your variables have different ranges of values you would specify a separate histogram statement listing the variables before the / and the specific values for those variables.

Note: if your data is originating from a 0 to 10 scale or similar for ALL the variables and you just don't have some values for some variables you could set the midpoints to use the entire scale and then all the graphs would use the same midpoints.