topic Re: %let and Scan Function! in SAS Programming

%let and Scan Function!

SASPhile — Wed, 03 Jun 2009 14:57:44 GMT

%let dat=Abc_2009_05;
%let date=scan("&dat",2,'_')||'_'||scan("&dat",3,'_');

What is to be done to make &date to resolve to 2009_05?

Re: %let and Scan Function!

sbb — Wed, 03 Jun 2009 15:06:35 GMT

If you have a standardized character string format, you can generalize your code to %INDEXC the first occurence of "_" and then %SUBSTR from there. The use of SCAN is incorrect as you have described in your posted code, by the way.

Scott Barry
SBBWorks, Inc.

Re: %let and Scan Function!

SASPhile — Wed, 03 Jun 2009 15:15:30 GMT

Hi Scott,
I tried this and it worked:
%let date=%scan(&dat,2,'_')_%scan(&dat,3,'_');

Re: %let and Scan Function!

ChrisNZ — Thu, 04 Jun 2009 03:22:20 GMT

It should be [pre]
%let date=%scan(&dat,2,_)_%scan(&dat,3,_); [/pre]
You are using ' as delimiters in your example, which you don't need or mean to.