topic Scan function in SAS Programming

Scan function

SASdevAnneMarie — Wed, 14 Sep 2022 16:31:56 GMT

Hello Experts,

I would like to scan all the phrase after 5 space.

I have this code : Ligne2 = scan(ligne,5,'') , but as result I have only one word.

Do you know please, how to scan all phrase after 5st space ?

Thank you for your help !

Re: Scan function

Reeza — Wed, 14 Sep 2022 16:35:58 GMT

LIGNE2 = substr(ligne, 5);

SUBSTR() will extract everything from the 5th character onwards.

SCAN() with 5, looks for 5th term with a delimiter (space). Given your stated requirements I think SUBSTR() is the correct function for you usage.

@SASdevAnneMarie wrote:

Hello Experts,

I would like to scan all the phrase after 5 space.

I have this code : Ligne2 = scan(ligne,5,'') , but as result I have only one word.

Do you know please, how to scan all phrase after 5st space ?

Thank you for your help !

Re: Scan function

Kurt_Bremser — Wed, 14 Sep 2022 16:40:02 GMT

Please show us examples for the string you want to scan, and what you want to extract from them.

Re: Scan function

Tom — Wed, 14 Sep 2022 17:08:42 GMT

@SASdevAnneMarie wrote:

Hello Experts,

I would like to scan all the phrase after 5 space.

I have this code : Ligne2 = scan(ligne,5,'') , but as result I have only one word.

Do you know please, how to scan all phrase after 5st space ?

Thank you for your help !

Scan does return ALL. It returns the nTH term.

1    data _null_;
2      line = 'one  two  three four five six seven';
3      line2 = scan(line,5,' ');
4      put (line line2) (=$quote.);
5    run;

line="one  two  three four five six seven" line2="five"

If you want the result to be "five six seven" then use CALL SCAN() and SUBSTRN().

6    data _null_;
7      line = 'one  two  three four five six seven';
8      call scan(line,5,position,length,' ');
9      line2=substrn(line,position);
10     put (line line2) (=$quote.);
11   run;

line="one  two  three four five six seven" line2="five six seven"