Creating a New Variable Based on Old

[anissak1]

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

[Astounding]

This should do the trick:

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

[anissak1 · Accepted solution]

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

[novinosrin]

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. 

[anissak1]

Thank you for letting me know.