I am standardizing unit names, however many of them contain a non-standard indicator at the end of the unit name (it denotes geographically separated but part of the same unit). I need to remove this final string so these units can later be combined into one unit. Typically I would substring this, but the indicator 1) does not occur on every unit name, 2) is not in a standard position in the string, and 3) the final sting itself isn't consistent in the use of digit vs character starting in position 3 (see below).    Examples of the unit names: SURGICAL OPS OLA900 SURGICAL OPS OLHC00 EDU AND TRNG OL0IZH EDU AND TRNG OL0PZR LEGAL OLCS00 LEGAL OLA200   The final sting always starts with " OL". Searches have brought me to PRXCHANGE, but as I've read in forums and found out myself, the syntax is particularly confusing. What is your best practice recommendation in this situation?  ... View more

Good afternoon,    I am cleaning longitudinal data in a wide format. Each individual in the dataset has 1-5 records and I am implementing some logic steps to determine which 2 records to keep for each person. I could create a dummy variable and label each row 1_2 or 2_4 to indicate which records to keep, then later run a PROC SQL to pull the records, but I am wondering if it's possible to use the unique identifier for each record *as* the dummy variable. Examples below:   Here is what I have that works: When Vaccine1 = Vaccine2 and days_between2 >= 60 then "1_2" When Vaccine2 is missing then "1" Else "F"   BUT is it possible to do something like this?: When Vaccine1 = Vaccine2 and days_between2 >= 20 then "ImmRecID1_ImmRecID2" When Vaccine2 is missing then "ImmRecID1" Else "F"   As written it doesn't work, but any tips to tell SAS "Use the value from 'ImmRecID1' and 'ImmRecID2' here" would be awesome! The customer would prefer it's returned to a long format when we are finished, so I will need a list of all the unique record identifiers in the end. Any other suggestions are also welcome! ... View more