Hi Everyone, To find the Highest value within a give window, I use the proc expand. Now I want to find the Highest value for a number of window say from 3 to 5. I can run the proc 3 times as below. However, I would like to make it kind of "do from START to END" so it will provide more flexibility and make the code better controlled. Can you please help me with that? Thank you so much. HHC data have; input var1 var2; datalines; 3 2 4 2 0 5 8 9 6 11 100 20 20 60 40 25 10 6 50 29 100 20 run; proc expand data=have out=want; convert var1=max_3/transformout=(MOVmax  3); convert var1=max_4/transformout=(MOVmax  4); convert var1=max_5/transformout=(MOVmax  5); run; ... View more

Hello Everyone, I have the following problem and would like to seek your help. My file has variable Target (taking value 0 or 1) and different family of condition variables: A1, A2 ... ; B1, B2 ... Bn; C1…Cn. I have a code below that create a summary of number of taget=0 and target=1 for each combination of variable and value say A1B1C1 (0, 0,0),           A1B1C1 (0, 0, 1)  ….. A1B1C2 (0, 0,0),           A1B1C2 (0, 0, 1)  ….. …. And then get the ratio of there 2 number. This code only get 1 variable from 1 family. Now, I am trying to modify the code so that the output file will create combination within each family, up to a chosen value of combination. Such as: A1        B1        C1 A1A2    B1        C1                    (family A has 2 level of combination) … A1        B1        C1 A1        B1B2    C1 A1        B1B2B3            C1        (family B has 3 level of combination) …. A1A2    B1B2    C1 A1A2    B1BB3 C1                    I should be able to dictate the maximum within family combination. Any help is very much appreciated. Thank you, HHC data have;                                                                                                                                 input target a1-a3 b1-b3 c1-c3;                                                                                                         datalines;                                                                                                                           0 1 1 1 1 1 1 2 3 4                                                                                                                     0 0 0 1 1 0 0 1 2 4                                                                                                                     1 0 0 1 1 0 0 1 2 4                                                                                                                     1 1 0 0 0 1 1 1 2 1                                                                                                                     1 0 0 0 1 0 1 2 0 2                                                                                                                     0 1 1 1 1 0 0 1 3 0                                                                                                                     0 0 0 0 1 0 0 1 2 3                                                                                                                     1 0 1 1 0 1 0 0 0 1                                                                                                                     0 1 0 0 0 0 0 1 1 1                                                                                                                     ;;;;                                                                                                                                       run;                                                                                                                                                                                                                                                                         data temp(keep=_a_: _b_: _c_: target);                                                                                                  set have;                                                                                                                              length _a_name _b_name _c_name $ 20;                                                                                                   array _a{*} a:;                                                                                                                        array _b{*} b:;                                                                                                                        array _c{*} c:;                                                                                                                        do i=1 to dim(_a);                                                                                                                       do j=1 to dim(_b);                                                                                                                       do k=1 to dim(_b);                                                                                                                      _a_name=vname(_a{i}); _b_name=vname(_b{j}); _c_name=vname(_c{k});                                                                       _a_value=_a{i}; _b_value=_b{j}; _c_value=_c{k};                                                                                                                                                                                                                                 output;                                                                                                                                end;                                                                                                                                  end;                                                                                                                                    end;                                                                                                                                    run;                                                                                                                                                                                                                                                                            proc sql;                                                                                                                               create table want as                                                                                                                    select _a_name,_b_name, _c_name,_a_value,_b_value, _c_value,sum(target=1)/sum(target=0) as Ratio                                         from temp                                                                                                                                group by  _a_name,_b_name,_c_name,_a_value,_b_value, _c_value;                                                                       quit;                                        ... View more

Hi Everyone, I want to run a process every 3 month from 1990-2013. I setup my macro like that: %macro Myproblem (m=,y=); data period; set original_data:           if m-3<month<=m+3 and year=y; ... .... %mend; %myproblem (m=3,y=1990); %myproblem (m=6,y=1990); ... ... %myproblem (m=12,y=2014); Sure this code run but I believe that there should be a more efficient way rather than listing all (m=,y=). Could you suggest a better way in this case? (I know another way that make 02 files, 1 is the marco itself ; and 1 is for the m and y running together with calling the macro file.) Thank you so much. HHC ... View more

Hi Everyone,   I have a macro as follow: %macro myproblem (X=); ... ... data final_&X; set ....; %mend;   % myproblem(X=1); % myproblem(X=2); % myproblem(X=3);   of course after running that macro, I have final_1, final_2, final_3. I want to create a data file call FINAL that is the combination of the above 3 files based on SQL like: proc sql; create table FINAL as select * from final_1 full join final_2 on final_1.name=final_2.name; quit; proc sql; create table FINAL as select * from FINAL full join final_3 on final_1.name=final_2.name; quit;   I wonder how can I "include" that sql section in the MAcro so it will do the combination anytime new file final_i is created. The critical point is that I have nothing to start with at the first iteration (X=1) to do the SQL.   Any help is very much appreciated.   Have a nice weekend.   HHC   ----------------- %if ( &RR=5 and &sl_code=0 ) %then %do; data single_factor_Buy_f; set single_factor_Buy;run; %end; %else %do; proc sql; create table single_factor_Buy_f as select * from single_factor_Buy_f as a left join single_factor_Buy as b on a.a_name = b.a_name and a.a_value = b.a_value; quit; %end; ... View more