Select Page

Make your metadata queries more versatile by checking for multiple conditions in a single pass!  When using the OR condition, remember to prefix subequent attributes with the @ symbol.  See below for testing whether a Stored Process user is in a certain set of groups:

%let _MetaPerson=John Smith;
data _null_;
   length obj type $256 id $20;
      “@Name=’SASAdministrators’ or @Name=’ETL Developers’]”!!
   if (rc) then Call symputx(‘Isamemberc’,‘Yes’);
   else Call symputx(‘Isamemberc’,‘No’);

%put “Is &_MetaPerson in groups ETL developer or SAS Administrator??”;
%put “&Isamemberc”;