Hello
I am recoding some values with proc format statement and I want to recode the "blanks" or the missing data to "Missing" ? How would I do that?
I already tried this and it didnt work. it still says "Frequency missing= 5" in my proc freq statement and does not recode my missing data.
Proc format library=example;
value $catjt '.'= 'Missing';
run;
"proc freq statement"
Try this to get a Missing label:
Proc format;
value $catjt
' ' = 'Missing';
run;
No need to recode the missing values.Try using option MISSING on the TABLES statement instead.
This is the correct syntax - you can look it up yourself in the documentation. If you select a statement in the SAS editor with your mouse and press F1 then you should get syntax help.
Proc freq data=Example.mydata;
tables cat / missing ;
format cat $catjt.;
run;
Try this to get a Missing label:
Proc format;
value $catjt
' ' = 'Missing';
run;
Thank you that worked along with the proc freq comment!
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.