topic Re: Scan function not working. why? in SAS Data Science

Scan function not working. why?

devarayalu — Mon, 25 Jun 2012 13:07:47 GMT

11 data one;

12 string = ',leading, trailing,and multiple,,delimiters,,';

13 length word $20;

14 do until(word='');

15 count+1;

16 word=scan(string, count, ',', 'm');

----

ERROR 72-185: The SCAN function call has too many arguments.

17 output;

18 end;

Haikuo — Mon, 25 Jun 2012 13:39:57 GMT

Works as being expected for me on SAS 9.2, Winxp 64bit.

65 data one;

66 string = ',leading, trailing,and multiple,,delimiters,,';

67 length word $20;

68 do until(word='');

69 count+1;

70 word=scan(string, count, ',', 'm');

71 output;

72 end;

73 run;

NOTE: The data set WORK.ONE has 1 observations and 3 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

Although after you stressed 'm' modifier, you only get one missing 'word'.

Haikuo

Tom — Mon, 25 Jun 2012 14:19:50 GMT

Looks like you are running an older version of SAS where SCAN function does not support the modifiers.