Hello, I have 3 character data fields: field_1; field_2; field_3 --> all character fields (format $5.) with both letters and numbers. I have been able to extract records using the if field_1= '20B' (as an example). I am trying to create a categorical variable based on specific conditions: Category 1 = extract records where any 2 of the 3 fields must contain/start with '20B' and '300' Category 2 extract records where any 2 of the friends must contain/start with '20B' and '400' OR (contain/start with '20B' in any 1 of the 3 fields, so long that the other 2 fields don't equal '300' or '400' [or the other 2 fields are empty]) Category 3, 4, 5.. etc. will be based on conditions based on field_1 only: Category 3 = Field_1 >= '150' & <= '170' Category 4= Field_1 >= '500' & <= '600' I tried doing this using arrays and a few other approaches, but it's not working for me. Not sure how to go about approaching this. Any help would be appreciated! Thanks in advance!
... View more