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 |
Result = cats(Char, Code);
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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: