topic Get list of data sets exists in permanent library in SAS Programming

Get list of data sets exists in permanent library

Ronein — Sun, 06 Jun 2021 05:50:57 GMT

Hello

In a permanent library called labqret there are multiple data sets.

Some of the data sets there have the name labqret.ABC_TS_YYMMB

For example:

labqret.ABC_TS_2106B (It means June 2021)

labqret.ABC_TS_2105B (It means MAY 2021)

labqret.ABC_TS_2104B (It means April 2021)

and so on

I want to write a program that create a macro variable called memlist with names of data sets that exists in library labqret only with names labqret.ABC_TS_YYMMB.

The problem is that I get null result

proc sql noprint ;
%let memlist=_null_;
  select catx('.',libname,memname)
    into :memlist separated by ' '
    from dictionary.members 
    where libname='labqret'
      and ((memname like 'ABC_TS_%'))
  ;
quit;
%put &memlist;

Re: Get list of data sets exists in permanent library

Kurt_Bremser — Sun, 06 Jun 2021 07:00:29 GMT

libnames and memnames are all uppercase in the dictionary tables.

Re: Get list of data sets exists in permanent library

ballardw — Sun, 06 Jun 2021 13:11:18 GMT

Exact same error as in your post https://communities.sas.com/t5/SAS-Programming/Get-obs-without-null-values/m-p/542668 from March 2019.