"Unavailable" is a chrachter type field.
You need to create a new numeric variable using
data temp;
set have;
new_variable = input(old_variable, ?? best.);
run;
in this case the non numeric value will be assigned as missing value
and that is what you need for statistics and analyze.
Using this also converts the ranges to missing values so the values for eg say 10-20 ,20-30,... are even replaced with missings
Setting them to missing > removed from analysis. SAS will discard any record from analysis where any of the model variables are missing. If you don't assign them a "valid" category then you may as well use where clause to subset the data as they would be excluded anyway.
Or take a pass at imputing but I wouldn't go that route unless the number of "missing" or "unavailable" is large relative to the sample size. How large? depends on the actual data.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.