Hello and I want to get one step more complex. I created following analysis using . %MACRO LOOPING( START=,END=); proc freq data=have_&START._&END; tables name*category/ chisq cl ALL; output out=testy_&START._&END(KEEP=_PCHI_ P_PCHI L_RROR U_RROR) pchi ALL; exact or; weight count; run; DATA FINAL_&START._&END; SET TESTY_&START._&END; GROUP = "&START._&END"; WHERE _PCHI_ ^=.; RUN; %MEND; %LOOPING(START=1,END=2); %LOOPING(START=1,END=3); %LOOPING(START=1,END=4); %LOOPING(START=1,END=5); %LOOPING(START=1,END=6); %LOOPING(START=1,END=7); %LOOPING(START=1,END=8); %LOOPING(START=1,END=9); %LOOPING(START=2,END=3); %LOOPING(START=2,END=4); %LOOPING(START=2,END=5); %LOOPING(START=2,END=6); %LOOPING(START=2,END=7); %LOOPING(START=2,END=8); %LOOPING(START=2,END=9); %LOOPING(START=3,END=4); %LOOPING(START=3,END=5); %LOOPING(START=3,END=6); %LOOPING(START=3,END=7); %LOOPING(START=3,END=8); %LOOPING(START=3,END=9); %LOOPING(START=4,END=5); %LOOPING(START=4,END=6); %LOOPING(START=4,END=7); %LOOPING(START=4,END=8); %LOOPING(START=4,END=9); %LOOPING(START=5,END=6); %LOOPING(START=5,END=7); %LOOPING(START=5,END=8); %LOOPING(START=5,END=9); DATA final_want; SET FINAL_1_2 FINAL_1_3 FINAl_1_4 FINAL_1_5 FINAL_1_6 FINAL_1_7 FINAL_1_8 FINAL_1_9 FINAL_2_3 FINAL_2_4 FINAL_2_5 FINAL_2_6 FINAL_2_7 FINAL_2_8 FINAL_2_9 FINAL_3_4 FINAL_3_5 FINAL_3_6 FINAL_3_7 FINAL_3_8 FINAL_3_9 FINAL_4_5 FINAL_4_6 FINAL_4_7 FINAL_4_8 FINAL_4_9 FINAL_5_6 FINAL_5_7 FINAL_5_8 FINAL_5_9 ; run; It exactly gives what I want but I am wondering if I can shortened the code since it has a lot repetitive component. I am doing chi square test comparing each group and providing necessary values. I am thinking if it is possible to insert Proc freq statement within hash table creation statement so that it gives more cleaner code. Thank you
... View more