DATA Step, Macro, Functions and more

Loop thru values in a data set

Reply
Contributor
Posts: 58

Loop thru values in a data set

I am an experienced developer in everything but SAS.

 

I have a Dataset --->   "Periods" with a single column and 12 periods:

 

YYYYPP

201605

201604

201603

201602

....

...

 

I want step thru each data format in the Periods table, run an query to pull based on each of the 12 dates, by setting the current period equal to a variable and using the variable as criteria for the pull. 

 

I can do all parts of this except the looping part of the code. 

This is my approach and I can't get it to work.

 

%Macro macro1;

%Do i = 1 %To 12 %By 1;

 

call symputx ('YYYYPP',trim(YYYYPP));

 

RunQuery using &YYYYPP.

 

%end

%Mend macro1; %macro1;

 

Any Help is appreciated in advance.

 

Thank you.

 

Super User
Posts: 5,426

Re: Loop thru values in a data set

Posted in reply to Kody_devl

Typically, this is done via a call execute() in a data _null_ step.

But what kind of pull do you need to do?

Perhaps it could be solved in a simple SQL join?

Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 196 views
  • 0 likes
  • 2 in conversation