Using do loop in proc sql to iterate over a timeframe

[asalunkh]

Hello, I am new to SAS and learning basics at the moment.

I want to do insert values in my table for a particular date frame - say, a week. How should I write this in proc sql using a do loop so I don't have to write 7 similar queries for each date? Thank you!

[Tom]

Why would you use SQL?

Why not just write a data step instead?

[Kurt_Bremser]

From where do you get the data for the week to be inserted?

How does your existing table look like?

Is the data to be inserted already stored in a similar structure as your base table?

By giving us data for our orientation, you enable us to find a proper solution.

Data drives code.

[PGStats]

There is no iteration construct in SQL syntax. To insert data for a week you can say something like:

insert into mainTable
select ...
from otherTable
where date between '01jan2018'd and '07jan2018'd;