topic Re: Creating a variable dependent on previous variable in SAS Programming

Creating a variable dependent on previous variable

pbraud — Wed, 25 Sep 2013 20:39:26 GMT

Hi, I am trying to calculate a varible in SAS which is dependant on the previously calculated varibles. I thought this would be simple with the following code but it does not compute.

data test1;

set rate;

if id_perd = '1' then Dis_fact= 1/(1+((Swap_Spot_Rate)/12));

else if id_perd > '1' then Dis_fact = (1/(1+((Swap_Spot_Rate)/12)))*lag(Dis_fact);

run;

Is it possible to calculate a varible dependant on the previously calculated varible in sas? All help would be appreciate. Thanks! Patrick B.

Re: Creating a variable dependent on previous variable

data_null__ — Wed, 25 Sep 2013 20:49:19 GMT

You can probably just RETAIN DIS_FACT instead of LAGing, and just use DIS_FACT on the right instead of LAT(DIS_FACT);

Re: Creating a variable dependent on previous variable

Astounding — Wed, 25 Sep 2013 20:49:41 GMT

Patrick,

It should be as easy as 1 2 3.

First, make sure that RATE does not already contain a variable named DIS_FACT.

Second, get rid of the LAG function entirely.

Third, add this statement to the DATA step:

retain dis_fact;

That should do it.

Re: Creating a variable dependent on previous variable

pbraud — Wed, 25 Sep 2013 21:35:00 GMT

Thanks for the help!

Re: Creating a variable dependent on previous variable

pbraud — Wed, 25 Sep 2013 21:35:08 GMT

Thanks for the help!