%let SPDSWDEB=YES;

proc sql;
   create table work.P_RISK as
          select PRR_PID_PRODUCT_ID from SPDWRKDI.VLS_PRODUCT_RISK
                 where  prxchange("s/[^0-9]//",-1,
                        VLS_PRODUCT_RISK.PRR_CDE_RISK_TYPE) in ('160', '161','180',
                        '200','241','242','243','244','245','246','248','249','250',
                        '251','390','460');

  

whinit: WHERE PRXCHANGE('s/[^0-9]//', -1, PRR_CDE_RISK_TYPE) in ('160', '161','180',
                           '200', '241', '242', '243', '244', '245','246', '248', '249',
                           '250', '251', '390', '460')
   whinit: wh-tree presented
                  /-FUNC = [PRXCHANGE()]
              /-FLST---|
             |         |--LITC = ['s/[^0-9]//']
             |         |--LITN = [-1]
             |          \-NAME = [PRR_CDE_RISK_TYPE]
    --IN-----|
             |          /-LITC = ['160']
              \-SET----|
                       |--LITC = ['161']
                       |--LITC = ['180']
                       |--LITC = ['200']
                       |--LITC = ['241']
                       |--LITC = ['242']
                       |--LITC = ['243']
                       |--LITC = ['244']
                       |--LITC = ['245']
                       |--LITC = ['246']
                       |--LITC = ['248']
                       |--LITC = ['249']
                       |--LITC = ['250']
                       |--LITC = ['251']
                       |--LITC = ['390']
                        \-LITC = ['460']
     whinit returns: ALL EVAL2


NOTE: Table WORK.P_RISK created, with 0 rows and 1 columns.