topic Re: Create a base from several bases in a library in SAS Programming

Create a base from several bases in a library

Sk1_SAS — Thu, 04 Mar 2021 20:03:41 GMT

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!

Re: Create a base from several bases in a library

Reeza — Thu, 04 Mar 2021 20:35:52 GMT

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

Re: Create a base from several bases in a library

Sk1_SAS — Thu, 04 Mar 2021 20:24:36 GMT

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_).

Re: Create a base from several bases in a library

SASKiwi — Thu, 04 Mar 2021 20:29:36 GMT

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

Re: Create a base from several bases in a library

Sk1_SAS — Thu, 04 Mar 2021 20:36:40 GMT

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.

Re: Create a base from several bases in a library

Reeza — Thu, 04 Mar 2021 20:47:09 GMT

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;

Re: Create a base from several bases in a library

Sk1_SAS — Thu, 04 Mar 2021 20:49:22 GMT


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 😞