How to save _user_ defined macro into a dataset? read the text file created below?
proc printto log="c:\temp\testlog.txt"; run; %put _user_; proc printto ; run;
Thanks!
What are you going to do with the results?
Note that there exists a data view you can address as SASHELP.Vmacro or with proc sql Dictionary.Macros that contains all of the macro variable definitions at the time you inspect. The following will have all variables. Add Where Scope ne 'AUTOMATIC' to get the macro variables you declared.
Data want;
set sashelp.vamacro;
run;
or
Proc Sql;
create table want as
select *
from dictionary.macros
;
quit;
You would be better off using existing tools for this purpose.
Use PROC SQL to take a look at dictionary.macros ... you should find all macro variables there, with fields that identify which ones are user-created. It should be easy enough to save a subset of that, as a SAS data set.
The one tricky part: macro variables that are longer than 200 characters are saved in 200-character chunks, across multiple observations. Of course with your %PUT _USER_ statement, those would pose a problem as well.
What are you going to do with the results?
Note that there exists a data view you can address as SASHELP.Vmacro or with proc sql Dictionary.Macros that contains all of the macro variable definitions at the time you inspect. The following will have all variables. Add Where Scope ne 'AUTOMATIC' to get the macro variables you declared.
Data want;
set sashelp.vamacro;
run;
or
Proc Sql;
create table want as
select *
from dictionary.macros
;
quit;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.