creating new variables derived from multiple rows per ID
Hello , I am trying to create one variable (type2) from multiple rows per ID using variable type. I want to covert a table like this one:IDtype1A1A1B2A2A3B3B3B To:IDtype21C2A3B Where type2 is: If type is always A then type2=A;If type is always B then type2=B;If type is a combination of A and B then type2=C; Thanks
thurnay_s