Hello Experts,   I want to call a macro variable in case statement in proc sql with list of values. I have a table with all the list of values with column name - Empcode. I want to create a macro variable &empcd. which holds all the values within Empcode field ie "EM12","EM34" etc. This then will be used in proc sql case statement ie proc sql; create table emp_list as ( select a.*, case when a.emp_id in (&empcd.) then "Match" end as analysis from employee a ); quit;   I am thinking this as an alternative approach, rather than using 2 tables with left join to achieve the same output.   Many thanks. ... View more

Hello,   I have 2 variables in a dataset viz child code and parent code. I want to filter for all the childrens within a parent code. Eg: Child code Mother code 2 1 3 2 4 2 5 2 6 3 7 6 8 7   From above sample dataset, If i select 2 I want all the childrens and grand childrens under 2 ie 3, 4, 5, 6, 7, 8 and if i select 3 as a parent code then 6, 7, 8 etc..   Kindly help..   Thanks, Ravi ... View more