I want to rename 276 variables. The old names are nL1-nL276  and the new name to be recoded to is contained in a macro variable (&L)   This is the code I came up with but it only renames nL1 and not the rest of the 275 variables.   %macro rename(oldvarlist, newvarlist); %let k=1; %let old = %scan(&oldvarlist, &k); %let new = %scan(&newvarlist, &k); %do %while(("&old" NE "") & ("&new" NE "")); data xx; set xx; rename &old = &new; run; %let k = %eval(&k + 1); %let old = %scan(&oldvarlist, &k); %let new = %scan(&newvarlist, &k); %end; %mend rename; %rename(nL1 - nL276, &L); ... View more

I have this large data set comprising of over 1000 subjects and about 3000 variables which are ICD9 codes (Dx1- Dx3000).  Dx represents the ICD diagnosis codes for each visit and is represented here as  1-4 My dataset looks similar to this:       I would like to get the distinct disease count for each subject. For example: subject 1 has 4 visits but 3 distinct diagnosis.                       subject 2 has 4 visits and 4 distinct diagnosis   Thanks.     ... View more