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"   ... View more

I am using a proc format statement with a "value" to recode some words in each a variable column. It is a large data set so I will show an example of my code below. Proc format library=example; value $catjt 'California', 'Texas', 'Nevada', 'Ohio' = 'USA'; Run; PROC FREQ DATA=example.dsets; tables cat run; Again This is just an example because the data is so large but in my frequency table the states such as "Nevada" and "Ohio" have not been changed to "USA" and I check my log and there are no errors at all. What could be the problem? ... View more