Hi,

I have a question regarding the first.variable and last.variable question.

Basically, my data have 2 or more types with the same ID (in my example, I just showed two types). I will need to create a flag variable that if the record has both A & B type, I will need to flag it to "BOTH" like scenario 1 & 2. If it has only one type, the flag variable will just show the type like scenario 3 & 4. By using first and last variable, I had no problem to flag scenario 3 & 4 but I didn't know how to handle scenario 1 & 2.

Thanks.

Scenario 1:

ID TYPE FIRST_TYPE LAST_TYPE FINAL 1234 A 1 0 BOTH 1234 A 0 1 BOTH 1234 B 1 1 BOTH

Scenario 2:

ID TYPE FIRST_TYPE LAST_TYPE FINAL 1234 A 1 0 BOTH 1234 A 0 1 BOTH 1234 B 1 0 BOTH 1234 B 0 1 BOTH

Scenario 3:

ID TYPE FIRST_TYPE LAST_TYPE FINAL 1234 A 1 0 A 1234 A 0 0 A 1234 A 0 1 A

Scenario 4:

ID TYPE FIRST_TYPE LAST_TYPE FINAL

1234 B 1 0 B 1234 B 0 1 B

_________________________________________________________________ Let the new MSN Premium Internet Software make the most of your high-speed experience. http://join.msn.com/?pgmarket=en-us&page=byoa/prem&ST=1