topic scan if no value between 2 delimiter in SAS Programming

scan if no value between 2 delimiter

tinaz5012 — Wed, 12 May 2021 14:20:20 GMT

Hi All,

I am trying to get the month or the following dates. The problem is when I use scan(dt,2) and if there is no value between 2 delimiter, it will be skipped. Also, there is no means to know what is the delimiter. Could you please advise how can I get '2021//03' as year 2021 month missing and day 03?

Here are my testing code:

data yymmdd_de;
infile datalines delimiter=','; 
input dt $50.;
datalines;
21 03 14
21/03/14
21-03
21//03
21   03
;

data test;
set yymmdd_de;
m=scan(dt,2);
run;

Here is the result:

Many thanks in advance!

Re: scan if no value between 2 delimiter

Reeza — Wed, 12 May 2021 14:27:07 GMT

data test;
set yymmdd_de;
m=scan(dt,2, "/- ", 'm');
run;

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/lefunctionsref/p0jshdjy2z9zdzn1h7k90u99lyq6.htm

m or M

specifies that multiple consecutive delimiters, and delimiters at the beginning or end of the string argument, refer to words that have a length of zero. If the M modifier is not specified, then multiple consecutive delimiters are treated as one delimiter, and delimiters at the beginning or end of the string argument are ignored.

Re: scan if no value between 2 delimiter

tinaz5012 — Wed, 12 May 2021 14:31:37 GMT

Appreciate your response, it solve my problem. Thank you