topic how to generate a macro variable for each row using Call symputx in SAS Enterprise Guide

how to generate a macro variable for each row using Call symputx

alepage — Thu, 18 May 2023 14:39:52 GMT

How to generate a new macro variable for each row?

Data ConsentInfo&j.;
length record $4000;
set info_1;
i=_n_;
record=cats("'", '{ "firstName" : ',' "',firstName,'", ',' "lastName" : ','"',lastName,'", ','"email" :',
'"',email,'"}',"'");
call symputx('NewRecord',record,'g');	
run;

Re: how to generate a macro variable for each row using Call symputx

Tom — Thu, 18 May 2023 14:54:19 GMT

You have to use a different macro variable NAME to prevent writing the same macro variable over and over.

call symputx(cats('NewRecord',i),record,'g');

Re: how to generate a macro variable for each row using Call symputx

alepage — Thu, 18 May 2023 15:45:43 GMT

Is it possible to add a %put NewRecord || i;

If after that I do a call execute how can I passed each macro variable

Re: how to generate a macro variable for each row using Call symputx

Tom — Thu, 18 May 2023 15:57:23 GMT

Are you asking how to USE the macro variables once you have them?

You can type their full name:

%put &NewRecord1 ;
%put &NewRecord2 ;

You can use another macro variable to help you build up the name you want to reference. You will need to double up the first &. The && will be converted to & and signal to the macro processor to scan the text again to resolve the resulting macro variable reference.

%let i=1;
%put &&NewRecord&i ;