topic Re: Proc Format No Errors in Log in New SAS User

Proc Format No Errors in Log

superman1 — Sun, 14 Mar 2021 22:33:11 GMT

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?

Re: Proc Format No Errors in Log

PaigeMiller — Sun, 14 Mar 2021 22:36:07 GMT

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.

Re: Proc Format No Errors in Log

superman1 — Sun, 14 Mar 2021 22:42:04 GMT

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?

Re: Proc Format No Errors in Log

superman1 — Sun, 14 Mar 2021 23:16:58 GMT

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