Combine column

[Konkordanz]

hi,

Ive two column (Char,Code) and I just want to combine them (into result). But how? Could you pls help me with SAS- and SQL-command? Thank you!

Char	Code	Result
KA	14523	KA14523

[PeterClemmensen]

Result = cats(Char, Code);

[PaigeMiller]

Yes, the simplest answer is given by @PeterClemmensen 

However, you might want to familiarize yourself with the entire family of CAT functions as they may be helpful in other situations

CAT

CATQ

CATS

CATT

CATX

DOGX (<- there is no such thing)

[ballardw]

If your code variable is numeric you need to consider cases of differing number of digits and what you expect for the result. If you always want 5 digits in the combined value and the Code value is less than 10000 you may need to control the conversion to character as the default may not yield the desired need.

data example;
   char ='ABC';
   code = 3;
   combined= cats(char,code);
   combined2 = cats(char,put(code,z5.));
   put combined= combined2=;
run;

Yields:

combined=ABC3 combined2=ABC00003

The automatic conversion to character for the CAT (and most functions) will use a BEST format which may have fewer digits than you want/need/expect.