topic Re: Question about FIND function in New SAS User

Question about FIND function

zihdonv19 — Wed, 17 Jun 2020 18:11:29 GMT

Given the following dataset:

libname results 'c:\cert\output';
data results.output03_1 (drop=n);
set cert.input03;
n=find(major,'and','i');
if n^=0 then do;
second_major=subtr(major,n+4);
major=subtr(major,1,n-2);
end;
run;

What do the above bold parts "i" "n+4" and "n-2" mean?

Thanks!

Re: Question about FIND function

novinosrin — Wed, 17 Jun 2020 18:15:39 GMT

i - case insensitive search

n- starting position of the word searched in the string

n+4 - starting position from which substr will start to extract chars

n-2- evaluates to length of chars that the substr will extract

Please get hold of SAS functions by example- A book by author Ron cody

Re: Question about FIND function

PaigeMiller — Wed, 17 Jun 2020 18:19:07 GMT

You can also look up what SAS functions do, and what the options do, here:

Alphabetical List of All SAS 9.4 Functions