Searching conditional on substring?

[UniversitySas]

Hello,

For example; I am trying to keep records which only have the string "street" or "corn" in them, regardless of position/upper/lowercase or anything else - how would I go about doing this?

data source;
INFILE DATALINES ;
 input ID VAR & $19. CLASSIFICATION $ ;
 DATALINES;
201  PepsiCo  XYZ  
201  111 main street  XYZ  
201  Charity  XYZ  
331  CocaCola  XYZ  
331  1823 unicorn street  XYZ  
331  Charity  XYZ  
331  Nike  XYZ  
331  123 brock avenue  XYZ  ;
RUN;

For instance: I tried: 

DATA substrings;
	SET source;
IF indexw(var,'street');
RUN;

but it creates an empty data set.

any help is much appreciated, cheers!

[novinosrin]

post a sample of your data  that's readable and what your required output plz

[UniversitySas · Accepted solution]

Sorry - don't know why it didn't copy properly before - edited it now.

Edit: Never mind, got it:

DATA string;
	SET source;
WHERE varname contains 'street';
RUN;

[ballardw]

---

@UniversitySas wrote:

Sorry - don't know why it didn't copy properly before - edited it now.

Edit: Never mind, got it:

DATA string;
	SET source;
WHERE varname contains 'street';
RUN;

---

Does your data set contain a variable named VARNAME? Or are you attempting to use the VARNAME function. If the later then this won't work.

[UniversitySas]

That's correct. My input code in the original post should have the column "Varname" instead of "VAR".

Sorry for the mixup!