BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
1 ACCEPTED SOLUTION

Accepted Solutions
ballardw
Super User

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.

View solution in original post

7 REPLIES 7
ballardw
Super User

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
Obsidian | Level 7

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
Obsidian | Level 7
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
Obsidian | Level 7
Thank you ballardw
hlamoureux
Obsidian | Level 7
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
Super User

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
Obsidian | Level 7
Ty

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 7 replies
  • 774 views
  • 1 like
  • 2 in conversation