topic Re: INDEXC in SAS Programming

INDEXC

Siddharth123 — Sun, 17 Apr 2016 08:14:21 GMT

Hi All,

I am not getting expected results when using INDEXC (please see code below). I would expect all records in the dataset UnSure rather than in For_Sure -

DATA TEST;
INPUT Name $50.;
INFILE DATALINES;
DATALINES;
DREFT ESTATES LTD
POTTERSLANE LTD
;
RUN;

DATA For_Sure UnSure;
SET TEST;
IF indexc(Name, "GOVERNMENT") > 0
OR indexc(Name, "COLLEGE") > 0 then OUTPUT For_Sure;
ELSE OUTPUT UnSure;
RUN;

Any help will be greatly appreciated.

Thank you

Re: INDEXC

Siddharth123 — Sun, 17 Apr 2016 08:51:07 GMT

Hi All,

I figured out that I need to use INDEX rather than INDEXC to solve this problem.

Kind regards

Re: INDEXC

RW9 — Mon, 18 Apr 2016 08:58:09 GMT

Yes, function indexc() searchs for one single character in the string, where index() searchs for the whole text. You can compress your code somewhat, if <> is looking for a binary 1 or 0 result, so index() or findw() (which i show below) will return 0 if not present, so 0 result, and anything is positive and considered true (also, please dont code all in capitals, it makes reading it very hard):

data test;
  input name $50.;
datalines;
DREFT ESTATES LTD
POTTERSLANE LTD
;
run;

data for_sure unsure;
  set test;
  if findw(name,"GOVERNMENT") or findw(name,"COLLEGE") then output for_sure;
  else output unsure;
run;