BookmarkSubscribeRSS Feed

Hi,

 

I have created the PROC Format below which i thought would capture all scenarios but my output is getting a value for '.'

 

Any idea why please

 

value ppd
LOW - 0 = "UTD"
0 <-1 = "LT 1 PPD"
1 <-2 = "1 PPD"
2 <-3 = "2 PPD"
3 <- HIGH = "3+ PPD";

4 REPLIES 4
Kurt_Bremser
Super User

You either need to name a specific label for missing values

. = 'Missing'

or use OTHER as range to "catch" all values that have not been covered by your ranges:

OTHER = 'Everything else'

 

Thanks, but I would have thought that the ranges specified would cover them all off so I wouldn't expect any missing values.

Kurt_Bremser
Super User

Although a missing value is considered smaller than any other numeric value in comparisons, it is not included in a range that starts with low. That only covers non-missing values. Your intention is probably met best by doing this:

data have;
input inval;
cards;
.
-1
0
1
2
3
4
;
run;

proc format library=work;
value ppd
  .,LOW - 0 = "UTD"
  0 <- 1 = "LT 1 PPD"
  1 <- 2 = "1 PPD"
  2 <- 3 = "2 PPD"
  3 <- HIGH = "3+ PPD"
;
run;

data want;
set have;
outval = put(inval,ppd.);
run;

proc print noobs;
run;

Output:

inval    outval

   .     UTD     
  -1     UTD     
   0     UTD     
   1     LT 1 PPD
   2     1 PPD   
   3     2 PPD   
   4     3+ PPD  

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

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
  • 4 replies
  • 28226 views
  • 1 like
  • 2 in conversation