Date: Tue, 3 Feb 2004 08:51:08 -0500
Reply-To: "Fehd, Ronald J. (PHPPO)" <rjf2@CDC.GOV>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Fehd, Ronald J. (PHPPO)" <rjf2@CDC.GOV>
Subject: Re: Listing values of macro variables
Content-Type: text/plain; charset="us-ascii"
> From: Dean Hjelle [mailto:DHjelle@OTPCO.COM]
> I think I read or heard that there is now a command that will
> list the value of all macro variables that have been assigned
> in a program but have been unable to find it. Does anyone
> know what this command is?
as already provided
%Put _ALL_;%*more than you wanted to know: includes SYS*;
%Put _user_;%*user-defined macro variables;
within a macro:
SAShelp.vMacro and Dictionary.Macro
contain the SYS* macro variables in sorted order
but the user-defined mVars are in some automagically determined order
which doesn't relate to being alphabetized.
PROC Print data = SAShelp.vmacro;%*contains _ALL_;
PROC Print data = SAShelp.vmacro
(where = (Scope eq 'GLOBAL');
PROC SQL;select * from Dictionary.Macros;quit;
PROC SQL;select Name ,Value
where Scope eq 'GLOBAL'
order by Name
see macro Put_User
Ron Fehd the macro maven CDC Atlanta GA USA RJF2@cdc.gov
RTFM: I'm an engineer, I don't get paid to know,
I get paid to know which Dictionary.Table it is in