Can someone help me fomat this

[hlamoureux]

[ballardw · Accepted solution]

You need to provide:

1) How did you make that

2) Describe what is wrong

3) Describe what the correction should look like

and if you want tested code

4) Example data in the form of data step code.

If you don't want the values with that negative number then likely either a WHERE statement or data set option to filter values such as: Where variablename >=0;

If you want the negative value to be treated as a different number that is likely going to involve modifying your data set.

[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;

[hlamoureux]

I would like it to start at the right the LHS is all -1.0's which I can ignore however I do not want to delete the record as there may be other score I want to examine.

[hlamoureux]

Thank you ballardw

[hlamoureux]

Maybe I should do a separate histogram for the above field so I can incorporate a where statement and then the other fields are not missed due to the above field being filtered

[ballardw]

Use a graph procedure such as SGPLOT for the graphs. You have more control of appearance and the procedure does not modify the data.

Proc Univariate is more intended as exploratory and less for producing publication or presentation ready graphics.

An xaxis statement in SGplot can filter the range to values to display as well.

[hlamoureux]

Ty