Hi everyone,
I was wondering if there is any way to conserve the left blancs with SQL. See the following example
data tmp;
cat="First level ";
output;
cat=" Second level";
output;
cat=" Third level";
output;
;
run;
proc sql noprint;
select distinct cat into :var_levels separated by "#"
from tmp;
quit;
%put &var_levels;
I obtain this output
Third level#Second level#First level
and I like to have
Third level# Second level# First level.
From the doc 🙂
notrim
separated by "#" notrim
Hth,
Eric
Thanks, like in almost everywhere the text is not trim I have not think about a possible option to do it
Hi,
I think SQL will trim off the leading blanks by default, I don't know of a way to switch it off. However you can easily fool it:
data tmp;
cat="First level ";
output;
cat="_Second level";
output;
cat="__Third level";
output;
;
run;
proc sql noprint;
select distinct cat into :var_levels separated by "#"
from tmp;
quit;
%put %sysfunc(tranwrd(&var_levels,_, ));
Depends on what you want it for really. If I am doing rtf output then I would put the rtf code in the variable. Alternatively if you are creating a string from the 3 levels, then a retain, if last then output, should work. Or you could tranpose them etc.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.