Hi all. Hopefully an easy one for you! In T-SQL i used to write something along the lines of Select * from Table1 Where field1 like '[A-Z]%' That would select all records from Table1 where field1 started with any character between A and Z. It would not bring back records starting with a number or a non alphanumeric. If i did ... Where field1 like '[A-Z][0-9]%' it would return al rows starting with one letter and then a number.. like "S2 Antfarm" How can i do this in SAS? ... View more

Hi. I have two columns. One containing a vehicle make and the other a vehicle model. For example: Column1               Column2 VOLVO                 LR55VL In some instances (from poor validation at data entry most probably), Column2 often contains the value from Column1 within the string. Example: Column1               Column2 VOLVO                 VOLVO - LR55VL I was hoping to use the COMPRESS function like COMPRESS(Column2, Column1) but that looks at the individual characters in column1 and compresses them ALL out of Column2 resulting in Column1               Column2 VOLVO                  - R55 How can I do something similar to compress but force it to contstrain the compression with the entire string in column1? In this example, i was hoping to achieve and output of Column1               Column2 VOLVO                  - LR55VL Thanks in advance! ... View more