Hi guys, I have a question about member enrolling and dropping. Suppose there are Jan, Feb, March, ... Dec 2016 member data, total 12 dataset. In each dataset, variables are the same (>100 variables). Would like to see who drops and who enrolls. My code is as following: %LET measure = var1; data enroll (keep=MEMBERID &measure flag) drop (keep=MEMBERID &measure flag); merge Jan2016Data (keep=MEMBER &measure IN=a) Feb2016Data (keep=MEMBER &measure IN=b); by member; if b then flag="enroll"; if a then flag="drop"; if &measure ^= ""; /*there are many missing value which need to be excluded basing on the requirement*/ if a ^= b; if flag="enroll" then output enroll; if flag="drop" then output drop; run; Issure: 1. how to make &measure in Feb2016Data not to overwrite Jan2016Data? 2. Why sas result is different than my manual result (compared in excel)? Is there anything wroing? (no error msg in log) Thanks!! Viv
... View more