Hi All,
I have a situation like, I have two macro varibales "Y2008" & "Y2009" with the values of 7 , 3 respectively. on the otherside, my data files has one variable "YEAR_END" and two obervarion with the values of 2008 & 2009. I have to resolve this YEAR_END vairbal with the above macro values (7 ,3) .
Please do see my code,
%let Y2008 = 7 ;
%let Y2009 = 3 ;
data data1;
input YEAR_END $4.;
out_var = &Y.&YEAR_END. ; <-- here i am getting error
cards;
2008
2009
;
run;
I want the output of data1 is,
out_var = 7 YEAR_END=2008
out_var =3 YEAR_END=2009
Kindly note, i don't want to hard code if condition , like, if YEAR_END=2008 then out_var = &Y2008
Thanks,
... View more