Hello Let's say that in the data set I have there are 13 variables called : ID ,X0-X11 Let's say that the task is to create a series of new 11 variables called W1-W11 that their values will be as following: W1=(X1-X0)/X0; W2=(X2-X1)/X1; and so on W11=(X11-X10)/X10;   What is the way to write it by defining Arrays? How many one dimensional-Arrays should be defined? What is the way to do it by defining one two-dimensional-Array? I am trying to write the code. What do you think? Is it correct? Please note that I defined two one-dimensional arrays but with different dim (For Array XXX the dim is 12 and for WWW the dim is 11) Data Tbl2; SET tbl1; ARRAY  XXX(12)  X0-X11; ARRAY WWW(11) W1-W11; DO i=1  TO 11; WWW{i}=(XXX{i+1}-XXX{i})/XXX{i}; end; Run;   ... View more

Hello I need to run a dynamic report every week. In the report there are 12 user defined macro variables (m0,m1,m2,m3,m4,m5,m6,m7,m8,m9,m10,m11). For each customer there  is one row with 13 fields: ID X_&m0 X_&m1 X_&m2 X_&m3 X_&m4 X_&m5 X_&m6 X_&m7 X_&m8 X_&m9 X_&m10 X_&m11 In the code there are 3 parts: part1- calculate % change in var X between each consecutive months part2-For each % change need to build indicator if there is %increase higher than 50%,or %decrease higher than 50%,or other. Part3-Need to calculate How many increases in more than 50% occurred and How many decreases in more than 50% occurred     My question: Is there a way to write this long code by a more clever way? Please note that by writing a long code as I did there might be typing errors   /*part1- Find % change of X between each 2 consecutive months*/ PCT_X&m1._&m0.=(X_&m1.-X_&m0.)/X_m0. ; PCT_X&m2._&m1.=(X_&m2.-X_&m1.)/X_m1. ; PCT_X&m3._&m2.=(X_&m3.-X_&m2.)/X_m2. ; PCT_X&m4._&m3.=(X_&m4.-X_&m3.)/X_m3. ; PCT_X&m5._&m4.=(X_&m5.-X_&m4.)/X_m4. ; PCT_X&m6._&m5.=(X_&m6.-X_&m5.)/X_m5. ; PCT_X&m7._&m6.=(X_&m7.-X_&m6.)/X_m6. ; PCT_X&m8._&m7.=(X_&m8.-X_&m7.)/X_m7. ; PCT_X&m9._&m8.=(X_&m9.-X_&m8.)/X_m8. ; PCT_X&m10._&m9.=(X_&m10.-X_&m9.)/X_m9. ; PCT_X&m11._&m10.=(X_&m11.-X_&m10.)/X_m10. ; /*Part2*/ IF PCT_X&m1._&m0.>50% then Ind_X&m1._&m0.=1; else IF PCT_X&m1._&m0.<-50% then Ind_X&m1._&m0.=-1; else Ind_X&m1._&m0.=0; IF PCT_X&m2._&m1.>50% then Ind_X&m2._&m1.=1; else IF PCT_X&m2._&m1.<-50% then Ind_X&m2._&m1.=-1; else Ind_X&m2._&m1.=0; IF PCT_X&m3._&m2.>50% then Ind_X&m3._&m2.=1; else IF PCT_X&m3._&m2.<-50% then Ind_X&m3._&m2.=-1; else Ind_X&m3._&m2.=0; IF PCT_X&m4._&m3.>50% then Ind_X&m4._&m3.=1; else IF PCT_X&m4._&m3.<-50% then Ind_X&m4._&m3.=-1; else Ind_X&m4._&m3.=0; IF PCT_X&m5._&m4.>50% then Ind_X&m5._&m4.=1; else IF PCT_X&m5._&m4.<-50% then Ind_X&m5._&m4.=-1; else Ind_X&m5._&m4.=0; IF PCT_X&m6._&m5.>50% then Ind_X&m6._&m5.=1; else IF PCT_X&m6._&m5.<-50% then Ind_X&m6._&m5.=-1; else Ind_X&m6._&m5.=0; IF PCT_X&m7._&m6.>50% then Ind_X&m7._&m6.=1; else IF PCT_X&m7._&m6.<-50% then Ind_X&m7._&m6.=-1; else Ind_X&m7._&m6.=0; IF PCT_X&m8._&m7.>50% then Ind_X&m8._&m7.=1; else IF PCT_X&m8._&m7.<-50% then Ind_X&m8._&m7.=-1; else Ind_X&m8._&m7.=0; IF PCT_X&m9._&m8.>50% then Ind_X&m9._&m8.=1; else IF PCT_X&m9._&m8.<-50% then Ind_X&m9._&m8.=-1; else Ind_X&m9._&m8.=0; IF PCT_X&m10._&m9.>50% then Ind_X&m10._&m9.=1; else IF PCT_X&m10._&m9.<-50% then Ind_X&m10._&m9.=-1; else Ind_X&m10._&m9.=0; IF PCT_X&m11._&m10.>50% then Ind_X&m11._&m10.=1; else IF PCT_X&m11._&m10.<-50% then Ind_X&m11._&m10.=-1; else Ind_X&m11._&m10.=0; /*Part3*/ Total_increases_More50PCT=SUM( (Ind_X&m1._&m0.=1), ( Ind_X&m2._&m1.=1), ( Ind_X&m3._&m2.=1), ( Ind_X&m4._&m3.=1), ( Ind_X&m5._&m4.=1), (Ind_X&m6._&m5.=1), (Ind_X&m7._&m6.=1), ( Ind_X&m8._&m7.=1), ( Ind_X&m9._&m8.=1), ( Ind_X&m10._&m9.=1), ( Ind_X&m11._&m10.=1)); Total_Decreases_More50PCT=SUM( (Ind_X&m1._&m0.=-1), ( Ind_X&m2._&m1.=-1), ( Ind_X&m3._&m2.=-1), ( Ind_X&m4._&m3.=-1), ( Ind_X&m5._&m4.=-1), (Ind_X&m6._&m5.=-1), (Ind_X&m7._&m6.=-1), ( Ind_X&m8._&m7.=-1), ( Ind_X&m9._&m8.=-1), ( Ind_X&m10._&m9.=-1), ( Ind_X&m11._&m10.=-1)); Total_NoChanges_MoreLess50PCT=SUM( (Ind_X&m1._&m0.=0), ( Ind_X&m2._&m1.=0), ( Ind_X&m3._&m2.=0), ( Ind_X&m4._&m3.=0), ( Ind_X&m5._&m4.=0), (Ind_X&m6._&m5.=0), (Ind_X&m7._&m6.=0), ( Ind_X&m8._&m7.=0), ( Ind_X&m9._&m8.=0), ( Ind_X&m10._&m9.=0), ( Ind_X&m11._&m10.=0));   ... View more

Hello friends,  I need to run a monthly report .   This report is using tables of last 6 months in order to create control limits.   This report code includes Macro with 2 parameters.(let's say that macro name is Dave). Each month I need to run 6 macros (Then control limits will be calculated from results of these 6 macro runs)   For example: In this month (We are in October 2019) I need to run the following macros: %Dave(1910,'01OCT2018'd) ; %Dave(1909,'01SEP2018'd) ; %Dave(1908,'01AUG2018'd) ; %Dave(1907,'01JUL2018'd) ; %Dave(1906,'01JUN2018'd) ; %Dave(1905,'01MAY2018'd) ;   Next month (November 2019) I need to run the following macros: %Dave(1911,'01NOV2018'd) ; %Dave(1910,'01OCT2018'd) ; %Dave(1909,'01SEP2018'd) ; %Dave(1908,'01AUG2018'd) ; %Dave(1907,'01JUL2018'd) ; %Dave(1906,'01JUN2018'd) ;   As you can see first parameter of macro has structure of YYMM (year of 2 digits and month of 2 digits). The reason is that each table name includes YYMM name on it.   As you can see second parameter of macro has structure of '01MonthNameYear'd (like date9. format). The reason is that for each customer I need to check if he/she is a new customer or not. The criteria is to check date 1 year before YYMM   My question: Let's say that the only user defined variable is  %let last=1910; and then I need to run all automatically. How can I do it please?    Thanks Dave ... View more