topic Re: dummy variables in SAS Programming

dummy variables

jenim514 — Wed, 24 Feb 2016 20:58:49 GMT

I'm creating some dummy variables for analysis, and I need help with a step...

I have four different variables that indicate an ER visit, if coded a specfic value (all different values). So I have this first part:

data want;

set have;

if admsrc='0' then ER=1;

if admtype='1' then ER=1;

if typsvc1='K' then ER=1;

if appttype_r='EROOM' then ER=1;

if ppsprod='01' then ER=1;

run;

but how to I set the rest of the ER values to 0? I tried adding the 'else ER=0' at the end, but that didn't output the values correctly.

Thanks for your assistance!!

Re: dummy variables

Reeza — Wed, 24 Feb 2016 21:06:34 GMT

Use IF/ELSE IF/ELSE rather than listing individual IF statements.

In a block as below, the first condition that is evaluated as true and then the rest are NOT tested.

Otherwise, each condition is tested and can set the value.

data want;
set have;
if admsrc='0' then ER=1;
else if admtype='1' then ER=1;
else if typsvc1='K' then ER=1;
else if appttype_r='EROOM' then ER=1;
else if ppsprod='01' then ER=1;
else ER=0;
run;

Re: dummy variables

FreelanceReinh — Fri, 04 Mar 2016 12:29:44 GMT

Or a bit shorter:

data want;
set have;
ER=(admsrc='0' | admtype='1' | typsvc1='K' | appttype_r='EROOM' | ppsprod='01');
run;