topic Re: How to view Symbol Tables? in SAS Programming

How to view Symbol Tables?

Nietzsche — Wed, 15 Mar 2023 11:55:48 GMT

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.

Re: How to view Symbol Tables?

PaigeMiller — Wed, 15 Mar 2023 12:02:45 GMT

Look at SASHELP.VMACRO

Re: How to view Symbol Tables?

s_lassen — Wed, 15 Mar 2023 12:07:30 GMT

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.

Re: How to view Symbol Tables?

yabwon — Wed, 15 Mar 2023 12:15:31 GMT

... and:

%put _all_;

to see everything.

Bart

Re: How to view Symbol Tables?

yabwon — Wed, 15 Mar 2023 12:17:49 GMT

... or by SQL:

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

Bart

Re: How to view Symbol Tables?

Nietzsche — Fri, 17 Mar 2023 06:49:34 GMT

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?

Re: How to view Symbol Tables?

s_lassen — Fri, 17 Mar 2023 07:03:37 GMT

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

Re: How to view Symbol Tables?

Nietzsche — Fri, 17 Mar 2023 07:24:34 GMT

thank you

Re: How to view Symbol Tables?

yabwon — Fri, 17 Mar 2023 07:36:14 GMT

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

Re: How to view Symbol Tables?

Nietzsche — Fri, 17 Mar 2023 09:02:07 GMT

@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.