Proc Format No Errors in Log

[superman1]

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?

[PaigeMiller · Accepted solution]

Is it possible in the data set you are working with, Nevada is actually NEVADA (uppercase)? Your format won't work on uppercase character strings.

[superman1]

Oh well yes I should of specified alittle more, NEVADA and OHIO are both uppercase. I also have another state which is NEW YORK and that wont change to "USA" in my proc formats statement. What should I do then?

[superman1]

thank you I was able to solve it with some of your advice