topic Re: What is the max number index for i in the loop below? in SAS Programming

What is the max number index for i in the loop below?

GN0001 — Thu, 15 Jul 2021 23:08:40 GMT

I have this code and I want to see how to loop works.

Proq sql;
select max(index) into :lst
from my tables;

%macro thisSample;
options spools;
%do i = 1 %to &lst.;
data _null_:
set frommypreviousread;
if $i = index then do;

what is the first value in the loop for &i = index;

if index is max(index)?

Regards,

blueblue

Re: What is the max number index for i in the loop below?

japelin — Thu, 15 Jul 2021 23:23:05 GMT

try this.

%put &=lst;

%put &=i;

in %do loops.

you can get value in macro variable.

And

if $i = index then do;

is this typo?

it may be "&i".

Re: What is the max number index for i in the loop below?

Sajid01 — Fri, 16 Jul 2021 00:18:11 GMT

The first value for &i will be one.
It can be verified by making changes as follows. This will put the value oi i in every iteration.

%do i = 1 %to &lst.;
%put &=i;
data _null_: