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!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.