DATA Step, Macro, Functions and more

Creating a dummy variable if text contains certain words

Accepted Solution Solved
Reply
Contributor
Posts: 73
Accepted Solution

Creating a dummy variable if text contains certain words

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
;

Accepted Solutions
Solution
‎01-13-2018 09:24 PM
PROC Star
Posts: 1,296

Re: Creating a dummy variable if text contains certain words

Posted in reply to Agent1592
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;

View solution in original post


All Replies
Solution
‎01-13-2018 09:24 PM
PROC Star
Posts: 1,296

Re: Creating a dummy variable if text contains certain words

Posted in reply to Agent1592
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;
PROC Star
Posts: 1,296

Re: Creating a dummy variable if text contains certain words

Posted in reply to novinosrin

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;
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 118 views
  • 1 like
  • 2 in conversation