topic Re: how to store_user_ in SAS Programming

how to store_user_

GeorgeSAS — Tue, 27 Jun 2017 20:50:36 GMT

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!

Re: how to store_user_

Astounding — Tue, 27 Jun 2017 21:12:51 GMT

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.

Re: how to store_user_

ballardw — Tue, 27 Jun 2017 21:13:53 GMT

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;

Proc Sql;

create table want as

select *

from dictionary.macros

;

quit;