topic Re: Storing a value of each iteration of do loop in SAS Programming

Storing a value of each iteration of do loop

jhabikaskumar26 — Mon, 24 May 2021 05:27:32 GMT

I want to create a macro variable suffix1 suffix2... Suffix12 variable such that
suffix1= 11 12 13
Suffix2= 21 22 23 so on
I tried using two do loop for it. But after each iteration new value get replaced with old one without storing it. Please do help me if anyone knows how I can code it in sas studio.

Re: Storing a value of each iteration of do loop

Kurt_Bremser — Mon, 24 May 2021 06:58:51 GMT

Please show your current attempt.

Re: Storing a value of each iteration of do loop

jhabikaskumar26 — Mon, 24 May 2021 07:37:44 GMT

I have attached below a pdf which contains snapshot of code and log. In that we can observe that suffix12 resolves to 123 in last iteration but I want it should contains 121 122 123.

Re: Storing a value of each iteration of do loop

Kurt_Bremser — Mon, 24 May 2021 07:45:08 GMT

Your pdf does not display in the preview.

Please post code by copy/pasting the text into a window opened with the "little running man" button, and logs and other fixed-format text into a window opened with the </> button.

Re: Storing a value of each iteration of do loop

jhabikaskumar26 — Mon, 24 May 2021 08:46:18 GMT

%macro data;
%do i=1 %to 12;
%do j=1 %to 3;
%let suffix&i.=&i&j;
%put &&suffix&i;
%end;%end;
%mend data;

%data;

SYMBOLGEN:  Macro variable I resolves to 12
SYMBOLGEN:  Macro variable J resolves to 1
MLOGIC(DATA):  %PUT &&suffix&i
SYMBOLGEN:  && resolves to &.
SYMBOLGEN:  Macro variable I resolves to 12
SYMBOLGEN:  Macro variable SUFFIX12 resolves to 121
121
MLOGIC(DATA):  %DO loop index variable J is now 2; loop will iterate again.
SYMBOLGEN:  Macro variable I resolves to 12
MLOGIC(DATA):  %LET (variable name is SUFFIX12)
SYMBOLGEN:  Macro variable I resolves to 12
SYMBOLGEN:  Macro variable J resolves to 2
MLOGIC(DATA):  %PUT &&suffix&i
SYMBOLGEN:  && resolves to &.
SYMBOLGEN:  Macro variable I resolves to 12
SYMBOLGEN:  Macro variable SUFFIX12 resolves to 122
122
MLOGIC(DATA):  %DO loop index variable J is now 3; loop will iterate again.
SYMBOLGEN:  Macro variable I resolves to 12
MLOGIC(DATA):  %LET (variable name is SUFFIX12)
SYMBOLGEN:  Macro variable I resolves to 12
SYMBOLGEN:  Macro variable J resolves to 3
MLOGIC(DATA):  %PUT &&suffix&i
SYMBOLGEN:  && resolves to &.
SYMBOLGEN:  Macro variable I resolves to 12
SYMBOLGEN:  Macro variable SUFFIX12 resolves to 123
123
MLOGIC(DATA):  %DO loop index variable J is now 4; loop will not iterate again.
MLOGIC(DATA):  %DO loop index variable I is now 13; loop will not iterate again.
MLOGIC(DATA):  Ending execution.
91

Here, I want macro variable suffix12= 121 122 123. Please do help me in modifying my existing code.

Re: Storing a value of each iteration of do loop

Kurt_Bremser — Mon, 24 May 2021 10:06:19 GMT

See this:

%macro data;
%do i=1 %to 12;
  %let suffix&i=;
  %do j=1 %to 3;
    %let suffix&i. = &&suffix&i. &i&j;
  %end;
  %put &&suffix&i;
%end;
%mend data;

%data

Re: Storing a value of each iteration of do loop

jhabikaskumar26 — Mon, 24 May 2021 10:58:27 GMT

Thank you for the help! It works.