topic Re: how to gather all the macro variable name and value into a dataset in SAS Enterprise Guide

how to gather all the macro variable name and value into a dataset

alepage — Thu, 11 May 2023 15:56:24 GMT

Hello,

I am using a proc http procedure to send information to an API Web Site. During the SAS code execution, one macro variable name ex; ContactId&i is generated as well as its value. For 5000 contacts, I will have something like ContactId1 - ContactId5000 and their corresponding string value.

I do not want to keep the log file because they are too big. So, I wonder how to gather the macro variable name and value into a dataset where each iteration create a new macro variable and how to update the dataset.

Re: how to gather all the macro variable name and value into a dataset

Astounding — Thu, 11 May 2023 16:11:31 GMT

SAS is automatically doing this for you. Take a look at (and copy from if you so choose) dictionary.macros.

Re: how to gather all the macro variable name and value into a dataset

alepage — Thu, 11 May 2023 16:14:50 GMT

Could you please provide a SAS snippet code that show how to do that

Re: how to gather all the macro variable name and value into a dataset

Reeza — Thu, 11 May 2023 16:29:23 GMT

Consider adding an append before your drop the result data set.

proc append base=results data=results&i force;
run;

Re: how to gather all the macro variable name and value into a dataset

ballardw — Thu, 11 May 2023 16:43:23 GMT

@alepage wrote:
Could you please provide a SAS snippet code that show how to do that

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

Will send all of the macro variable information to the result window.

Obviously could create a data set using the Create table <name you want> as syntax.

Could also filter with a Where name is like condition.