topic Re: Creating a dummy variable if text contains certain words in SAS Programming

Creating a dummy variable if text contains certain words

Agent1592 — Sun, 14 Jan 2018 01:20:36 GMT

Dear SAS community:

I have a dataset and would like to create a column in my data that is a dummy variable equal to 1 if the text contains "Estimates do not reflect" and equal to 0 if the text is "Estimates reflect". How is this possible?

Thanks!

data have;
input col $50.;
datalines;
DEC16 Estimates do not reflect adoption
Mar17 Estimates reflect adoption
JUN15 Estimates do not reflect adoption
SEP17 Estimates reflect adoption
;

Re: Creating a dummy variable if text contains certain words

novinosrin — Sun, 14 Jan 2018 02:15:41 GMT

data have;
input col $50.;
datalines;
DEC16 Estimates do not reflect adoption
Mar17 Estimates reflect adoption
JUN15 Estimates do not reflect adoption
SEP17 Estimates reflect adoption
;

data want;
set have;
if findw(col,'Estimates do not reflect')>0 then dummy=1;
else if findw(col,'Estimates reflect')>0 then dummy=0;
run;

Re: Creating a dummy variable if text contains certain words

novinosrin — Sun, 14 Jan 2018 02:19:47 GMT

find works-->

data want;
set have;
if find(col,'Estimates do not reflect')>0 then dummy=1;
else if find(col,'Estimates reflect')>0 then dummy=0;
run;