From: SAS_learner on
Guys I am doing something like this for my table, I was under the
impression that all the macros generated nature is Character then why is
this I am getting an error could anybody can explain it.

87 proc sql noprint;
88 select count(itt) into : total
89 from d_header ;
90 select '(N='!!&total!!')' into : atotal
91 from d_header ;
ERROR: Concatenation (||) requires character operands.
92
93 %put value of &total ;
value of 161
94 %put value of &atotal ;
value of N = 161
95 quit;