About kiwi

kiwi · ‎05-20-2016

I'm trying to pull in fields called Mort1, Mort2, Mort3, etc. depending on what value is in my variables, MortDuration&i. This returns text of Mort1, Mort2, etc. instead of the values: %LET i=1; %DO k=&i %TO &j; CAT(Mort,Calculated MortDuration&i) as Mortality&i, %LET i=%EVAL(&i+1); %END; If I replace the variable I want with a constant, it works: %SYSFUNC(CAT(Mort,1)) as Mortality&i, (only it always returns Mort1) And this returns an error: %SYSFUNC(CAT(Mort,Calculated MortDuration&i)) as Mortality&i, Here is my original non-macro, very ugly code that was working: ifn(Calculated MortDuration1=0,Mort0,ifn(Calculated MortDuration1=1,Mort1,ifn(Calculated MortDuration1=2,Mort2,ifn(Calculated MortDuration1=3,Mort3,ifn(Calculated MortDuration1=4,Mort4,.... etc. as Mortality1,

kiwi · ‎05-17-2016

Thank you. I was trying to get away from making hundreds of columns, but I don't think I can avoid it. Each policy will have 120 years of mortality rates. I think I'd be worse off by transposing it? I'll think about it though. Still new to programming so I appreciate the help!

kiwi · ‎05-17-2016

Thank you! This helped!

kiwi · ‎05-16-2016

I'm trying to figure out a way to use a loop and/or macro to simplify this code where I'm setting up 99 columns (ExposureUnits01, ExposureUnits02, etc.) PROC SQL; CREATE TABLE EXAMPLE02 AS SELECT Policy, UNITS01* ExposureCount01 as ExposureUnits01, UNITS02* ExposureCount02 as ExposureUnits02, UNITS03* ExposureCount03 as ExposureUnits03, UNITS04* ExposureCount04 as ExposureUnits04, /*(… ETC…)*/ UNITS99* ExposureCount99 as ExposureUnits99 FROM EXAMPLE01; QUIT;

Online Status	Offline
Date Last Visited	‎05-20-2016 05:23 PM

Code to change text to variable?

Re: Help with More Efficient Code

Re: Help with More Efficient Code

Help with More Efficient Code

Code to change text to variable?

Re: Help with More Efficient Code

Re: Help with More Efficient Code

Help with More Efficient Code