topic Using do loop in proc sql to iterate over a timeframe in New SAS User

Using do loop in proc sql to iterate over a timeframe

asalunkh — Tue, 19 Mar 2019 15:56:34 GMT

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!

Re: Using do loop in proc sql to iterate over a timeframe

Tom — Tue, 19 Mar 2019 16:00:36 GMT

Why would you use SQL?

Why not just write a data step instead?

Re: Using do loop in proc sql to iterate over a timeframe

Kurt_Bremser — Tue, 19 Mar 2019 16:58:01 GMT

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.

Re: Using do loop in proc sql to iterate over a timeframe

PGStats — Tue, 19 Mar 2019 18:14:25 GMT

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;