The macro variable tpidvar is blank so the if statement is if tdpid= then do and that will result in an error:   == My test log == 24 data test; 25 set sashelp.class; 26 if sex= then do; __ 22 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, ;, <, <=, <>, =, >, ><, >=, AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL, NOTIN, OR, ^=, |, ||, ~=. 27 put 'A'; 28 end; ___ 161 ERROR 161-185: No matching DO/SELECT statement. 29 run;   BR Fredrik ... View more

I don't think you can achieve that in VA, I tried some different ways  but did not get what I think you want 🙂 I have done this a couple of times and in all of them I have flattened the hierarchy in base-code before I loaded it into VA. Like: data test; length uid mid 8 uname mname $32; input uid mid uname; datalines; 1 10 usr1 2 10 usr2 3 20 usr3 4 20 usr4 5 30 usr5 6 40 usr6 7 50 usr7 10 100 mgr10 20 100 mgr20 30 200 mgr30 40 300 mgr40 50 . mgr50 100 1000 mgr100 200 1000 mgr200 300 . mgr300 1000 . mgr1000 ; run; proc sql; create table hier as select a.uname, b.uname as mgrname_lev1, c.uname as mgrname_lev2, d.uname as mgrname_lev3 from test a left join test b on a.mid = b.uid left join test c on b.mid = c.uid left join test d on c.mid = d.uid order by 1,2,3,4 ; quit; ... View more

Something like this?   data test; length dx1-dx4 $32; input dx1-dx4; datalines; a45981 b c d a b45981 c d a b c45981 d a b c d45981 a b c d ; run;   data test2; set test; if prxmatch( '/.*45981.*/', cats(OF dx1-dx4)) then delete; run; ... View more