topic Re: Multiple dummy variables to one dummy variable in SAS Programming

Multiple dummy variables to one dummy variable

Mdormond — Sun, 27 Jul 2014 18:49:51 GMT

I've asked this question in a similar manner in a previous post- but I wanted to clarify what I was asking. I currently have about 7 dummy variables all pertaining to psychological outcome (anxiety, stress, multiple personalities, etc) coded as 1=yes and 0=no. I would like to collapse all of these variables into one "psych condition" variable with 1=yes and 0=no. The variable would get a value of 1 if any of the 7 psychological outcomes had a value of 1. I've tried coding it a few different ways, but every time I overwrite the previous value and end up with every observation having a value of zero. Is there an easier way to do this?

Re: Multiple dummy variables to one dummy variable

stat_sas — Sun, 27 Jul 2014 19:18:46 GMT

data want;

set have;

psychological_outcomes=0;

if anxiety=1 or stress=1 or personalities=1 or var4=1 or var5=1 or var6=1 or var7=1 then psychological_outcomes=1;

run;

Re: Multiple dummy variables to one dummy variable

data_null__ — Mon, 28 Jul 2014 12:03:14 GMT

Make an array of the dummy variables and use whichn

data code;
   array v[3] 8; 
   input (v)(
1.);
   new = not not whichn(1,of v);
   cards; 
000
001
010
011
100
101
110
111
;;;;
   run; 
proc print; 
   run;

Re: Multiple dummy variables to one dummy variable

RichardinOz — Mon, 28 Jul 2014 12:33:49 GMT

Data want ;

Set have ;

outcome = max (anxiety, stress, multiple, etc1, etc2, etc3, etc4) ;

Run ;

Richard