topic Re: Create a new variable from combining separate variables in SAS Programming

Create a new variable from combining separate variables

achen — Tue, 20 Dec 2022 03:12:29 GMT

My data:

ID number treatment

1 14 Placebo

2 20 Placebo

3 10 Active

4 15 Active

Want a variable that looks like "number (treatment)". For example, 14 (Placebo), 20 (Placebo), 10 (Active), 15 (Active). This will be added to the dataset above (4th column).

Re: Create a new variable from combining separate variables

Astounding — Tue, 20 Dec 2022 08:36:45 GMT

Try:

data want;
set have;
newvar = catt(number, " (", treatment, ")" ;
run;

Re: Create a new variable from combining separate variables

achen — Thu, 29 Dec 2022 11:39:42 GMT

Thank you! Works great. The code is missing ), but it was an easy fix.