Hi, I would like to check if data set qt's variable names belong to variables names of another data set rit. The below is how I did it, but when I use 'name in &ritnames' in following code, I need those ritnames in quotation marks, but they are not. How to add these quotation marks to the variables in &ritnames to make it work? Or someone can suggest another way to achieve the same purpose without using my way? Thanks. %let rit = gw.rit; %let qt = gw.qt; proc sql noprint; select name into :ritnames separated by "," from dictionary.columns where libname="%upcase(%scan(&rit,1))" and memname="%upcase(%scan(&rit,2))"; select name into :qtnames separated by "," from dictionary.columns where libname="%upcase(%scan(&qt,1))" and memname="%upcase(%scan(&qt,2))" and name in (&ritnames); quit;
... View more
