With the following dataset, how do you code a macro that will create variables per ID that reports the values for each variable (bp, weight, bc) that corresponds to the last form_number? And keep the original variable in the dataset? The number of forms per ID may vary. data test, input ID$ bp weight bc form_number; datalines; 1 120 78 178 1 1 134 80 177 2 1 143 . 176 3 2 111 58 . 1 3 154 55 160 1 3 178 56 144 2 ; run; what we need is the following new dataset: ID bp weight bc form_number late_bp late_weight late_bc 1 120 78 178 1 143 80 176 1 134 80 177 2 . . . 1 143 . 176 3 . . . 2 111 58 . 1 111 58 . 3 154 55 160 1 178 56 144 3 178 56 144 2 . . .   ... View more

I have this dataset data test; input store$ type1 type2; datalines; 1 1 0 1 0 1 2 0 0 2 0 1 3 1 0 3 0 0; run;   We need to only filter stores that meet both type1=1 and type2=1. In this case, only store 1 satisfies this condition.  ... View more