topic Re: add variables and multiple space in SAS Programming

add variables and multiple space

hhchenfx — Fri, 19 Oct 2018 02:24:24 GMT

Hi Everyone,

I have few string var1 var2 var3.

I want to add all 3 strings and between each string, I want to have 3 spaces.

I try: new_var=cats(var1, " ", var2, " ", var3)

But it doesn't work.

Any suggestion, please.

Thank you.

HHCFX

novinosrin — Fri, 19 Oct 2018 02:27:46 GMT

use catx

new_var=catx( " ", var1,var2,var3)

andreas_lds — Fri, 19 Oct 2018 05:34:51 GMT

The function cats uses strip+trim on each argument, so nothing is appended. Using catx - as suggested by @novinosrin - solves the issue.

singhsahab — Fri, 19 Oct 2018 14:05:30 GMT

Hello,

You have to use catx function as suggested by novinosrin Sir. or you can use call routine call catx().

data _null_;
length var1 $20.;
var2="Hello";
var3="SAS";
call catx(' ',var1,var2,var3);
put var1=;
run;

hhchenfx — Fri, 19 Oct 2018 17:09:43 GMT

Thanks a lot.
HHC