topic Re: Creating a New Variable Based on Old in SAS Procedures

Creating a New Variable Based on Old

anissak1 — Thu, 07 Mar 2019 22:16:39 GMT

Hello. I'm new to SAS. I have a seemingly easy question but none of the conventional "create new variables" rules

seem to apply directly. Details below. I created a mini dataset to illustrate. Thank you! Anissa

First column has different types of tests - text format. Second column has results - numeric.

I want a third column with numeric value from column two, but only when column 1 is Test2.

OUTCOME NAME	RESULT	New Variable with TEST 2 only?

TEST1	4	.
TEST2	1	1
TEST3	2	.
TEST2	3	.
TEST4	2	2

Re: Creating a New Variable Based on Old

Astounding — Thu, 07 Mar 2019 22:21:18 GMT

This should do the trick:

data want;
set have;
if upcase(outcome_name) = 'TEST2' then newvar=result;
run;

Re: Creating a New Variable Based on Old

anissak1 — Thu, 07 Mar 2019 22:48:45 GMT

data want;
set have;
if upcase(outcome_name) = 'TEST2' then newvar=result;
run;

Re: Creating a New Variable Based on Old

novinosrin — Thu, 07 Mar 2019 22:46:29 GMT

hI @anissak1 Welcome to SAS communities. I am afraid you accidentally marked your thank you comment as the solution. Please switch to the correct solution. Have a good time here.

Re: Creating a New Variable Based on Old

anissak1 — Thu, 07 Mar 2019 22:50:22 GMT

Thank you for letting me know.