For what it's worth, I found that using CASE within a PROC SQL SELECT statement worked for me. Sharing the example code in case it is useful. PROC SQL; CREATE TABLE SET_A AS SELECT *, (CASE WHEN FIELD LIKE 'APPL%' THEN 'A' WHEN FIELD LIKE 'SYS%' THEN 'B' ELSE '' END ) AS NEW_FIELDNAME FROM SOURCE_TABLE WHERE OTHER_CRITERIA = 'XXX'; RUN;
... View more