Create dummy if certain number is in variable

Amber_Nicole94 — Thu, 24 Aug 2017 18:24:03 GMT

I am trying to create a dummy variable that signals to me if a certain number sequence is found in a variable. So i have the "Variable" field, and am trying to create the "In Sequence" field (dummy can be yes/no or 1/1 either works for me.

EXAMPLE: Does variable include 830 ?

Variable In Sequence?

LPAR0198308 YES

TRAE8307028 YES

MK109362791 NO

P01823974830 YES

WQTUAR2930 NO

I am using SAS EG 7.1

Re: Create dummy if certain number is in variable

Astounding — Thu, 24 Aug 2017 18:28:41 GMT

The INDEX function works here. One possibility:

in_sequence = (index(variable, '830') > 0);

Re: Create dummy if certain number is in variable

Amber_Nicole94 — Thu, 24 Aug 2017 18:33:42 GMT

That worked! Thanks!

topic Create dummy if certain number is in variable in SAS Programming

Create dummy if certain number is in variable

Re: Create dummy if certain number is in variable

Re: Create dummy if certain number is in variable