pobel 发表于 2012-10-2 22:51 
data test;
input b & $20. c $;
cards;
I use cat class functions to do all concatenations. It just a litter easy and flexible in my opinion.
code=cat("proc sql; create table a as select *, count(*) from ss.", left(c),
" group by ",b," having count(*) > 1; quit;");