How to view Symbol Tables?

[Nietzsche]

Hello.

Is there a quick way to view the Global or Local Symbol Table(s)? I wish to see my current macro variables.

Thank you in advance.

[PaigeMiller · Accepted solution]

Look at SASHELP.VMACRO

[yabwon]

... or by SQL:

proc sql;
  select * from dictionary.macros;
run;

Bart

[s_lassen]

You just submit

%put _user_;

to see the macro variables that you yourself have created, and

%put _automatic_;

To see the system generated macro variables.

Inside a macro you can use

%put _local_;

to see locally defined macros, and 

%put _global_;

to see globally defined macro variables.

[yabwon]

... and:

%put _all_;

to see everything.

Bart

[Nietzsche]

I tried

%put _all_;  and
%put _local_;

My local variables symbol tables are not being displayed. 

Does the %put _all_; and %put _local_; have to be inside the macro definition for it to be displayed in the log?

[s_lassen]

Yes, local variables only exist inside the macro, so you have to put it inside the macro definition.

[Nietzsche]

thank you

[yabwon]

Go with Maxim 1:

Read

1) here (whole branch): https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/mcrolref/n10i4tmalsyhgxn1hj4ud13ff074.htm

2) here: https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/mcrolref/p0ivgabci0y2den1usf43mxdkpgp.htm

and

3) here: https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/mcrolref/p1lhhti7fjxgb1n1fuiubqk11h4d.htm

Bart

[Nietzsche]

---

@yabwon wrote:

Go with Maxim 1:

Read

1) here (whole branch): https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/mcrolref/n10i4tmalsyhgxn1hj4ud13ff074.htm

2) here: https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/mcrolref/p0ivgabci0y2den1usf43mxdkpgp.htm

and

3) here: https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/mcrolref/p1lhhti7fjxgb1n1fuiubqk11h4d.htm

Bart

---

Thank you for your input.