Hello, I have the following dataset var 1 var2 var3 var4 region 1 2000 num1 num2 region1 2001 num3 num4 region1 32002 num5 num6 ... region1 2018 num19 num20 region2 2000 num21 num22 region2 ... regionn... I need to create a new variable for each region for each year which computes the sum of var3 for year i + var4 for year (i+1) Since I have 100 regions and periods, I want a macro... I tried to create dummy variables for each year but I don't know how to invoke the dummy for year(i+1) and I don't know what to do with my dummies... %macro EWD; %DO i=1950 %TO 2016; %put bin%eval(&i+1); sum=var3*bin&i+var4*bin%eval(&i+1)); %end; %mend EWD_2; data new; set essi; %EWD_2; run;
... View more