Hi, Need some tips about how to do clustering for categorical variables. Any epaper or thoughts are appreciated. Thanks, _kamal ... View more

Hi, I'm working to write a macro that is intended to join 8 tables one to one and get output as a 8 different joined tables, and want to do it at once using a macro. Below is my code, but it did n't workout. Please somebody help me to correct and understand it. I've 8 data_1&i.&k tables (like data_20123 - data_201314-one table for each quater for each month), also I've 8 target1&i.q&j (like target12q1-target13q4  ----8 tables). And key to join table is id. Below are the code. %macro test1; %do i= 2 %to 3 %by 1; %do j= 1 %to 4 %by 1; %do k= 3 %to 12 %by 3; proc sql; create outdata_201&i.q&j as select T1*,T2.target from data_201&i.&k as T1 left join target1&i.q&j as T2 on T1.id=T2.id; %end; %end; %end; quit; %mend test1; %test1 /***********************************/ Please see the attached file for the dataset codes. /******************************/ Though code worked, but it gave me misleading output. Each output table has same id and same observations. For example all the 4 output  tables for year 2012 has the the same obs as 2012 quater 4 tables has, and same for 2013 output dataset. Thanks, _kamal Message was edited by: Kamal KC ... View more