Hello, I would like to build a report in  stored process (EG). I have a problem writing code / loop in EG. The report should filter on a few optional fields. Let's call it: A B C. D In the report, I should be able to search either one field or several, e.g. only C, AD connection, ABC connection, etc. I don't want to list all possible combinations in the code. Could you please help me? ... View more

Hey, how can i do this LIKE '[^A-D][^A-Z][^A-Z][^0-9]%' in SAS? I want to leave only those cases that do not have the letters A to D in the first place, the letters A to Z in the second and third places and the numbers 0 to 1 in the fourth place. Sample data below: FU321007 18AC90104 ACZ879876 15BA10226 18AC77472 CSR646689 AA9601648 AAA655447 ... View more