12-17-2016 10:07 PM - last edited on 12-18-2016 01:01 AM by Reeza
I know you can change the lables for variables but how do I change record values?
For example, I have a variable named state and then the abbreviations for 50 states, how can I change and label them to the full name?
Ex: CA = California
12-17-2016 10:24 PM
There are different approaches to change the variable values, either you could try with if then else condition or simply using the format
example1: if then else
Data want; set have; if var='CA' then var1='California'; else if var='TX' then var1='Texas'; run; example 2: with format, we need to create the format first and to the same variable we could apply that format with format statement. proc format; value $states 'CA'='California' 'TX'='Texas'; run; data want; set have; format var $states.; run;
12-17-2016 11:04 PM
format var $states.;
12-18-2016 12:47 AM
@sconn Your code appears correct but note that a format changes how a variable is displayed but not the underlying value.
So, if it's not working, your starting point isn't necessarily what you think, IE CA isn't CA but something else.
Look at a proc contents of your dataset before and after you apply the format and try the IF version.
Post the proc contents if you need help debugging.