I need to filter data in SAS/IML with a USE or READ statement by specifying rows where a variable DOES NOT start with certain characters. SAS/IML supports a where clause with the =: operand, such as USE mydata where(myID =: "AB"); to select rows where the myID variable starts with AB. In my application, I only know that I do not want rows that begin with AB, but SAS/IML does not seem to support a statement like: USE mydata where(myID ^=: "AB");
I know I can preprocess the data before calling IML, but I would like to find a way to filter the incoming data directly in IML.
... View more