If you query the label attribute of an SQL view with the ATTRC function
in SAS Component Language (SCL) in either an SCL program or the DATA
step, the function returns a missing value instead of the label.

To circumvent this problem, you can use PROC CONTENTS to create an
output dataset with the table information and query the MEMLABEL column
for the label. For example, in an SCL program, you can execute the
following code to retrieve the label of the view MYLIB.MYVIEW:

   dcl char(40) viewLabel;
   INIT:
      submit continue sql;
         select memlabel: into my_macro_var
            from dictionary.tables
            where libname="WORK" and memname="MYSQLVIEW"
              and memtype="VIEW";
      endsubmit;
      viewLabel = symget('my_macro_var');
    return;

Operating System and Release Information