topic Re: Recode a variable in SAS Programming

Recode a variable

LoPez_Diaz — Fri, 08 Mar 2019 12:06:31 GMT

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

Re: Recode a variable

RW9 — Fri, 08 Mar 2019 12:18:53 GMT

Use a format:

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

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;

Re: Recode a variable

LoPez_Diaz — Fri, 08 Mar 2019 13:02:02 GMT

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

Re: Recode a variable

Kurt_Bremser — Fri, 08 Mar 2019 13:04:49 GMT

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

Re: Recode a variable

Kurt_Bremser — Fri, 08 Mar 2019 13:05:47 GMT

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

Re: Recode a variable

RW9 — Fri, 08 Mar 2019 13:18:01 GMT

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.

Re: Recode a variable

LoPez_Diaz — Fri, 08 Mar 2019 13:35:16 GMT

Thank you all for your help .

Have a great day.