Recode a variable

[LoPez_Diaz]

Hello , 

I have a data set of multiple dates , and for each data a maturity 

the maturities in the data are coded in numbers , for example  2 means 52 weaks , 3 means 2 years , 4 means 5 years ....

I want to recode this variable so that for each number I get the text instead. 

Thank you in advance

[RW9 · Accepted solution]

Use a format:

http://support.sas.com/documentation/cdl/en/proc/65145/HTML/default/viewer.htm#n1c16dxnndwfzyn14o1kb...

That is exactly what they are for.

proc format;
  value tmp
    2="52 weeks"
    3="2 years";
run;

data want;
  set have;
  format var1 var2 tmp.;
run;

[LoPez_Diaz]

Hello and thank you for your fast reply 

I'm new to sas , and i'm discovering this functions.

so when I used your code , I got the following error : 

28 6="2Y";
_
180
ERROR 180-322: Statement is not valid or it is used out of proper order.

Any clue ? 
Thank you 

[Kurt_Bremser]

When encountering problems, ALWAYS post the log of the whole step. The cause of the ERROR is further up.

[Kurt_Bremser]

And use the {i} button for posting logs, to conserve content and formatting.

[RW9]

The error tells you the issue, that statement is used incorrectly.  So its likely something before that has gone wrong.  As you haven't shown the full log however there is no way I can tell.  Refer to the code I presented and see what is different with your code, and then post the log here, all relevant log output.

[LoPez_Diaz]

Thank you all for your help .

Have a great day.