i want to create a macro loop in which i will provide it with monthly datasets and it will merge them per quarter after applying some exclusions    The below macro DOES NOT work i have added only to show how i believe the above can be coded    First, macro excl applies some exclusions to all monthly_data and then in macro append i want to create 2 quarter datasets to include the monthly data from excl    At the end i want to have the below two datasets  - quarter_1 (this must include month_1 to month_3 from the excl macro) -quarter_2  (this must include month_4 to month_6 from the excl macro)   However, the macro should be general in case that more months added for example 9 or 12 and so on   %let monhtly_data = month_1 month_2 month_3 month_4 month_5 month_6; %let outcome_names = quarter_1 quarter_2; %macro excl; %let k=%sysfunc(countw(&monhtly_data)); %do i=1 %to &k; %let monthly_var = %scan(&monhtly_data,&j); data excl_data_&i; set &monthly_var ; run; %end; %mend; %excl; %macro append; %let k=%sysfunc(countw(&monhtly_data)); %do i=1 %to &k; %let raw_dt = %scan(&monhtly_data,&i); proc append data=&outcome_names data=excl_data_&i force; run; %end; %mend; %append; ... View more

i have 2 variables OURBAND and SURBAND and want use the proc rank    Below are the proc freq of the variables and their ranks   I don't understand why for the variable OURBAND the proc rank creates only 1 rank (while has 5 different values) and at the same time the SURBAND with 9 different values has 5 ranks?     OURBAND OURBAND Frequency Percent Cumulative Cumulative Frequency Percent 1 20 0.67 20 0.67 2 92 3.07 112 3.73 3 42 1.4 154 5.13 4 7 0.23 161 5.37 5 2839 94.63 3000 100 SURBAND SURBAND Frequency Percent Cumulative Cumulative Frequency Percent 1 998 33.27 998 33.27 2 13 0.43 1011 33.7 3 32 1.07 1043 34.77 4 1102 36.73 2145 71.5 5 185 6.17 2330 77.67 6 248 8.27 2578 85.93 7 330 11 2908 96.93 8 37 1.23 2945 98.17 9 55 1.83 3000 100 Rank for Variable OURBAND rank1 Frequency Percent Cumulative Cumulative Frequency Percent 0 3000 100 3000 100 Rank for Variable SURBAND rank2 Frequency Percent Cumulative Cumulative Frequency Percent 0 998 33.27 998 33.27 3 1147 38.23 2145 71.5 7 433 14.43 2578 85.93 8 330 11 2908 96.93 9 92 3.07 3000 100   proc rank data=test_1 group=10 out=check_rank ties=low; var &varnum; ranks rank1-rank&vmcnt; run; proc freq data=check_rank; table ourband surband rank1 rank2; run; ... View more