Yes, both deduped. data test; merge alldata (in=a) pubdata3 (in=b); by course; if a and not b then flag=1; else if a and b then flag=2; else flag=3; run; 623 observations in total flag =1 - 38 observations flag =2 - 551 observations flag=3 - 34 observations Same as with if statements. Only thing I can think of is that in one of the datasets I had to manipulate the data to get the by variable (course) in the right format. In my first run through I got the 'by variables of multilple length...' message. I fixed it (I think) and don't get the error message. But when I run proc contents, this is how the variables are displayed... could this be the problem?
... View more