topic Re: Macro variables count in SAS Programming

Macro variables count

BrahmanandaRao — Fri, 19 Mar 2021 14:19:10 GMT

in work library  i assigned below macro variables i want assigned macro variables count in session

%let a=Alfred;
%let b=William;
%let c=Philp;

how to get macro variables count in a library

Re: Macro variables count

Tom — Fri, 19 Mar 2021 14:04:20 GMT

I don't understand what the question is.

Re: Macro variables count

BrahmanandaRao — Fri, 19 Mar 2021 14:11:07 GMT

how can we get macro variables count in a library

for example i assigned three macro variables in a work library

Re: Macro variables count

PaigeMiller — Fri, 19 Mar 2021 14:13:49 GMT

@BrahmanandaRao wrote:

how can we get macro variables count in a library

for example i assigned three macro variables in a work library

Please explain further. Macro variables are not associated with a library.

Re: Macro variables count

Tom — Fri, 19 Mar 2021 14:21:41 GMT

Macro variables are not related to librefs or datasets.

You an query the DICTIONARY.MACROS metadata.

For example to find the number of GLOBAL macro variables you could use this query.

proc sql ;
select count(*) as n_macros
from  dictionary.macros where scope='GLOBAL' and offset=0 
;

Re: Macro variables count

BrahmanandaRao — Fri, 19 Mar 2021 14:29:12 GMT

I assigned macro a b c using let

Re: Macro variables count

Reeza — Fri, 19 Mar 2021 16:02:12 GMT

Macro variables are per session so you can query the sashelp vmacro table for all user created macros in a session similar to other dictionary tables.