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!
Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.
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.