Get list of data sets exists in permanent library

[Ronein]

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;

[Kurt_Bremser]

libnames and memnames are all uppercase in the dictionary tables.

[ballardw]

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.