I agree with SASKiwi. It looks like you need to change your libname path to refer to your server file path. Something like: %let serverinfo=xxx.xx.com; libname mywork '/user/mywork' server=serverinfo; ... View more

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