Ujjawal, I think it's more of a quoting issue. You need the values for the in operator to be enclosed in quotes. You can get the quotes as part of the macro variable value by formatting them with the $quote. format. Since I made up the data values, I used 25 as the limit for your conditional processing, you can change that to whatever is appropriate for your data. Here's my code and I hope it's what you want: data def; input DSTRCT_Code $ ; cards; A B D A B D C C A A A B B ; proc freq data=def; table DSTRCT_Code / out= abcd; run; proc print data=abcd; run; PROC SQL ; * NOPRINT;  ****I took out noprint just to make sure I was getting results; select dstrct_code format=$quote10.  into :charvarname separated by ',' from abcd having PERCENT <= 25 and DSTRCT_Code is not null; QUIT; %put charvarname=&charvarname; PROC SQL NOPRINT; Select DSTRCT_Code INTO : charvarname2 separated by "_" from abcd having PERCENT <= 25 and DSTRCT_Code is not null; QUIT; ... View more