Hi Everyone,                                                                                                                            I have 2 data files, one is original and one is list of condition/filter.                                                               The original has id, target (take value 0 or 1) and a number of variables.                                                              The filter list the condition for a given set of variables(say var1 =0 and var2=1).                                                                                                                                                                                             I want to see how many record in the original file having target =1 and how many having target =0                                       IF filter1 OR filter2 is met.                                                                                                           So for that combination of filter1 OR filter2, there are 2 record with target=0 and 1 record with target=1.                                                                                                                                                                                                                                                                                                             I intend to create combinations of up to 4 filters                                                                                                                                                                                                                              I want the output file look like:                                                                                                                                                                                                                                               1st_filter 2nd_filter 3rd_filter 4th_Fitler N_target0 Ntarget1                                                                          1           2          .           .          2        1                                                                                                                                                                                                                        It is so challenging and I still cannot handle it.                                                                                                                                                                                                                               Any help is very much appreciate.                                                                                                       (I personally prefer to use the DO LOOP approach)                                                                                                                                                                                                                               Many thanks.                                                                                                                                                                                                                                                                                                                                                                                                            data originial;                                                                                                                         input id target var1 var2 var3 var4 var5;                                                                                               datalines;                                                                                                                              1 0 0 1 2 4 0                                                                                                                           2 0 0 1 2 4 1                                                                                                                           3 1 0 1 4 6 0                                                                                                                           4 1 0 8 6 9 8                                                                                                                           5 1 1 3 6 8 11                                                                                                                          6 1 8 6 5 3 4                                                                                                                           7 0 9 6 5 3 4                                                                                                                           ;                                                                                                                                                                                                                                                                               data filter;                                                                                                                            input filter_id cond1 $ value1 cond2 $ value2 cond3 $ value3;                                                                           datalines;                                                                                                                              1 var1 0 var2 1 var3 2                                                                                                                  2 var1 0 var5 0 . .                                                                                                                     3 var2 1 var4 4 . .                                                                                                                     4 var4 3 var5 4 var1 6                                                                                                                  5 var1 3 var5 4 var1 6                                                                                                                  ;                                                                                                                                                                                                                                                                               ... ... View more

Hi Everyone, I want to analyze the lag value of a variable. Sure I can create lag1, lag2... lag100 variable and do the "array var(*) lag1-lag100;" However, I wonder if there is any shorter way for the code such as array var(*) lag1(x)-lag10(x); Thank you for your help. HHC data have(drop=i); do i=1 to 10000; x=ranuni(-1); output; end; run; data want; set have; array var(*) lag1(x)-lag10(x); do i=1 to dim(lag); if lag(i)>0 then t=1; end; run; ... View more

Good morning Everyone, I am trying to build a set of SAS programs in which a master file will call and execute a number of SAS file say code1 code2 .. code100.. Each component code(i) is independent from each other, so code(i) will be simply executed sequencially. I don't know about setting up such a system. Could you please help me with the master file? Thank you for your help. HHC ... View more

Hi Everyone, I want to calculate moving quartile not include current record. This post below is the moving including current record. https://communities.sas.com/message/173630 I thought it could be a{1:252} but clearly, it doesn't work. Can you fix it for me or can you suggest other method? Thank you, HHC data have(drop=i); do i=1 to 10000; x=ranuni(-1); output; end; run; data want; set have; array a{0:251} _temporary_ ; a{mod(_n_,252)}=x; pct_20=pctl(20,of a{*}); run; ... View more

Hi, I have a dataset with var1 var2 ...var100. I want to code the below macro idea: %macro test(x=); Data have; if var_&x = 3 OR var_&(X-1)=3 OR var_&(x-4)=3 then find=1; run; %mend; so if X=10, the code will check var10, var9 and var6 value. Yes, I can make it %macro test( x=, y=, z=) . But I wonder if we can do anything similar this idea. Thank you, HHC ... View more

Hi Everyone, My data is as below. I want to create 3 variable New1 New2 New3 to store the value of the following comparison: If var1>max_1 then New1=1; else New1=0; If var1>max_2 then New2=1; else New2=0; If var1>max_3 then New3=1; else New3=0; I try to do it with Array. My problem is that I don't know how to tell SAS to create the Array of New1 New2 New3 automatically within the last section of the code. Thank you for your help. HHC data have; input var1 max_1 max_2 max_3; datalines; 3 2 2 3 4 2 8 9 0 5 5 63 8 9 1 2 6 11 4 6 100 20 5 9 run; data want; set have; array max(3) max_3-max_3; do i=1 to 3; if var1>max then NEW_VARIABLE=1; end; run; ... View more