topic Re: Can someone help me fomat this in Graphics Programming

Can someone help me fomat this

hlamoureux — Fri, 22 Jul 2022 14:05:58 GMT

Re: Can someone help me fomat this

ballardw — Fri, 22 Jul 2022 14:20:31 GMT

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.

Re: Can someone help me fomat this

hlamoureux — Fri, 22 Jul 2022 14:42:25 GMT

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;

Re: Can someone help me fomat this

hlamoureux — Fri, 22 Jul 2022 14:44:02 GMT

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.

Re: Can someone help me fomat this

hlamoureux — Fri, 22 Jul 2022 14:44:19 GMT

Thank you ballardw

Re: Can someone help me fomat this

hlamoureux — Fri, 22 Jul 2022 14:50:36 GMT

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

Re: Can someone help me fomat this

ballardw — Fri, 22 Jul 2022 16:19:03 GMT

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.

Re: Can someone help me fomat this

hlamoureux — Mon, 25 Jul 2022 12:54:38 GMT