/* data have */ Class Time_0 Time_1 Time_2 A 1 2 4 B 0 3 9 C 3 6 0 /* data want */ Class _01 _12 A 2 2 B 1 3 C 2 0    Rule 1: In data 'want', column '_01' = column 'Time_1' / 'Time_0' from data 'have'.                '_12' = 'Time_2' / 'Time_1'.                .... Rule 2: If divisor = 0 then result = 1.   Because my actual data have more than 100 'time' columns: Time_0-Time_&Num  (Num is a global macro variable), would prefer using a loop rather than hardcode it. Thanks. ... View more

We have two datasets:   /* dataset A */ Period num_1 num_2 num_3 4/2001 - 6/2001 62 14 35 /* dataset B */ Time_Period 1/2001 - 3/2001 4/2001 - 6/2001 7/2001 - 9/2001 10/2001 - 12/2001   The output dataset would look like: /* dataset want */ Time_Period num_1 num_2 num_3 1/2001 - 3/2001 0 0 0 4/2001 - 6/2001 62 14 35 7/2001 - 9/2001 0 0 0 10/2001 - 12/2001 0 0 0   Not sure how to achieve that? maybe merge or join?   ... View more

So we have one dataset: Start_date End_date Month_Interval 01JAN2001 31DEC2002 6   with 'Start_date', 'End_date' having date values, and 'Month_Interval' having numeric values.   We want to create a new dataset based on the data above:   Time_Period 1/2001 - 6/2001 7/2001 - 12/2001 1/2002 - 6/2002 7/2002 - 12/2002 with 'Time_Period' having character values.   Basically the interval starts on '01JAN2001', there are 6 months in each interval, and the period ends on '31DEC2002'.   How should we achieve this? ... View more

So I have two datasets: /* dataset A */ Col_1 Col_2 Col_3 Col_4 Row_1 3 2 5 7 Row_2 4 1 0 6 Row_3 11 8 3 1 /* dataset B */ Col_1 Col_2 Col_3 Col_4 Row_1 10 6 1 3 Row_2 2 0 8 3 Row_3 1 2 9 4 The final dataset that I need would look like: /* dataset output */ Col_1 Col_2 Col_3 Col_4 Row_1 13 21 27 37 Row_2 6 7 15 24 Row_3 12 22 34 39 Bascially 1st sum up the same cells from dataset A and dataset B. then calculate the cumulative sum starting from Col_1.    e.g. the Col_3, Row_2 cell value in output dataset would be calculated as: (4+2) + (0+1) + (0+8) = 15; the Col_2, Row_1 cell: (10+3)+(2+6) = 21.   It is quite easy to do in Excel, not sure how to do it in SAS?  ... View more

Currently using the following codes to generate one set of tables:   %let Num_category = 3; %macro table; %do _j=1 %to &Num_category; proc tabulate data=input.data out=output.sum_classA_typeA_&_j; /* use the same input dataset */ class v1; var Period_1 - Period_23; where class = 'classA' and type = 'typeA'; /* specify class and type here */ table (v1 =''), (Period_1 - Period_23) * (sum='No.') *f=comma9.2 / box ='name' printmiss; quit; data output.sum_classA_typeA_&j; set output.sum_classA_typeA_&j; ... run; proc sort data=output.sum_classA_typeA_&j; by ID; run; %end; %mend table; %table;   Now the problem is, there are more classes and types than just 'classA' and 'typeA'. Is there a way to create new loops to run the macro above?   One possible approach might be creating two arrays: 1.  classA  classB  classC; 2.  typeA  typeB  typeC; Each time will take one value from array1 and one value from array2, and generate a new set of tables: e.g.  output.sum_classA_typeB_&j;  and then keep going: output.sum_classA_typeC_&j; output.sum_classB_typeA_&j; ...   It's very easy to achieve this task in other languages (e.g. R, python), not sure how to do it in SAS enterprise guide?   Thanks. ... View more

I have a macro variable, named 'Num_period', which was used to create new columns. %global Num_period; %let Num_period=23; Now, names for those new columns have a pattern like: Period_1_Sum, Period_2_Sum, ... , Period_23_Sum.   Now we would like to use a loop, and a rename function in data step to rename all columns to: 0, 1, 2 ... 22;   The codes I expect would be something like: data test; set train; do i = 1 to &Num_period; rename Period_{i}_Sum {i}-1; end; run; The codes provided above aren't correct obviously. Could you provide the correct way of doing it?   Thanks. ... View more

There are a bunch of global macro variables with assigned value.   I would like to use a loop to do some stuff in a macro. At the beginning of the macro, will need to define a new macro variable, and retrieve value from those global macro variables.   My code is:   %let Period_1 = 11; %let Period_2 = 22; %let Period_3 = 33; %global Period_temp; %macro test; %do _j=1 %to 3; %let Period_temp = &&&(Period_&_j); /* something might be wrong here */ ... %end; %mend test; %test; %PUT _ALL_; run; /* The log shows: GLOBAL PERIOD_1 11 GLOBAL PERIOD_2 22 GLOBAL PERIOD_3 33 GLOBAL PERIOD_TEMP &(Period_3) /* which is not 33 */ */ Clearly Period_temp is not picking up 'the numeric value', i.e. 11, 22, or 33.   How should I change the code? --------------------------------------------------------------------------------------------------------------------------------- What if I want Period_temp to be some calculation result involving Period_1, Period_2, Period_3? e.g. Period_temp = 11 + 22 * 33; How should I change the code? ... View more