topic Re: Multiple Variables into one variable in SAS Data Management

Multiple Variables into one variable

rotana — Tue, 05 Jun 2018 16:36:18 GMT

Does anyone know if there's an efficient way to create a single variable from multiple variables. For example, person was asked if they've ever had a condition, then asked to specify the condition. When the data was entered, each condition was listed as its own binary (yes/no) variable without standardizing the variable names.

Condition X Y Z

1 1 0 0

1 0 0 1

0 0 0 0

1 0 1 0

I want it to look like this:

Condition Condition_type

1 X

1 Z

1 Y

Thanks!

Re: Multiple Variables into one variable

Reeza — Tue, 05 Jun 2018 16:47:10 GMT

Use WHICHN to find the value of the one with the 1 and then VNAME to get the name of the variable:

array myVars(*) x y z;
index = whichn(1, of myVars(*));
if index ne 0 then VarName = vname(myvars(index));

@rotana wrote:

Does anyone know if there's an efficient way to create a single variable from multiple variables. For example, person was asked if they've ever had a condition, then asked to specify the condition. When the data was entered, each condition was listed as its own binary (yes/no) variable without standardizing the variable names.

Condition X Y Z

1 1 0 0

1 0 0 1

0 0 0 0

1 0 1 0

I want it to look like this:

Condition Condition_type

1 X

1 Z

0

1 Y

Thanks!

Re: Multiple Variables into one variable

novinosrin — Tue, 05 Jun 2018 16:47:14 GMT

data have;
input Condition         X           Y           Z;
cards;
1                      1            0           0
1                      0            0           1
0                      0            0           0  
1                      0            1           0
;


data want;
set have;
array t(*) x--z;
temp=whichn(1, of t[*]);
if  temp then condition_type=vname(t(temp));
drop temp;
run;

Re: Multiple Variables into one variable

Astounding — Tue, 05 Jun 2018 20:45:00 GMT

Is it impossible for a person to have two conditions?