Create a base from several bases in a library

[Sk1_SAS]

Hi Team,

I need to create one base if the base name is >= 202004.. Is it possible? 

I tried this code, but it put all the bases together.

DATA MIS;
SET LIB._MIS:;
RUN;

name of the bases:

lib.MIS_201910
lib.MIS_201911
lib.MIS_201912
lib.MIS_202001
lib.MIS_202002
lib.MIS_202003
lib.MIS_202004
lib.MIS_202005
lib.MIS_202006
lib.MIS_202007
lib.MIS_202008
lib.MIS_202009
lib.MIS_202010
lib.MIS_202011
lib.MIS_202012
lib.MIS_202101
lib.MIS_202102
lib.MIS_202103

Thanks!

[Reeza]

Can you assume the last one will always be the current month?

If so you could do something like:

set lib.mis_202004 - lib.mis_%sysfunc(today(), yymmn6.);

EDIT: corrected to remove PUTN(), thanks to @SASKiwi 

Here is a reference that illustrates how to refer to variables and datasets in a short cut list:
https://blogs.sas.com/content/iml/2018/05/29/6-easy-ways-to-specify-a-list-of-variables-in-sas.html

[Sk1_SAS]

Yes, the last one is the current month.

I tried, and this error appears:

ERROR: Required operator not found in expression: today()
ERROR: Argument 1 to function PUTN referenced by the %SYSFUNC or %QSYSFUNC macro function is not a number.
ERROR: Invalid arguments detected in %SYSCALL, %SYSFUNC, or %QSYSFUNC argument list. Execution of %SYSCALL statement or %SYSFUNC
or %QSYSFUNC function reference is terminated.
ERROR: Missing numeric suffix on a numbered data set list (LIB.MIS_202004-LIB.MIS_).

[SASKiwi]

This works better: %sysfunc(today(), yymmn6.);

[Sk1_SAS]

the data format did not work.

ERROR: File LIB.MIS_202013.DATA does not exist.
ERROR: File LIB.MIS_202014.DATA does not exist.
ERROR: File LIB.MIS_202015.DATA does not exist.
ERROR: File LIB.MIS_202016.DATA does not exist.
ERROR: File LIB.MIS_202017.DATA does not exist.
ERROR: File LIB.MIS_202018.DATA does not exist.
ERROR: File LIB.MIS_202019.DATA does not exist.
ERROR: File LIB.MIS_202020.DATA does not exist.
ERROR: File LIB.MIS_202021.DATA does not exist.
ERROR: File LIB.MIS_202022.DATA does not exist.

[Reeza · Accepted solution]

Use double -- instead of single - check the link in the previous post for all the options.

Here is a reference that illustrates how to refer to variables and datasets in a short cut list:
https://blogs.sas.com/content/iml/2018/05/29/6-easy-ways-to-specify-a-list-of-variables-in-sas.html

Or create a macro variable from sashelp.vtables.

proc sql noprint;
select memname into :Table_list separated by " "
from sashelp.vtable where libname = "LIB" and memname >= "MIS_202004";
quit;

%put &table_list;

[Sk1_SAS]

DATA WANT;
set lib.MIS_202004--LIB.MIS_%sysfunc(today(), yymmn6.);
run;

22
76
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, _DATA_, _LAST_, _NULL_.

ERROR 76-322: Syntax error, statement will be ignored.

Not working 😞