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
;
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;
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;
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;
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.