topic Re: Searching conditional on substring? in SAS Programming

Searching conditional on substring?

UniversitySas — Wed, 17 Oct 2018 21:20:32 GMT

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!

Re: Searching conditional on substring?

novinosrin — Wed, 17 Oct 2018 21:17:45 GMT

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

Re: Searching conditional on substring?

UniversitySas — Wed, 17 Oct 2018 21:23:11 GMT

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;

Re: Searching conditional on substring?

ballardw — Wed, 17 Oct 2018 21:42:55 GMT

@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.

Re: Searching conditional on substring?

UniversitySas — Fri, 19 Oct 2018 17:16:01 GMT

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

Sorry for the mixup!