CODEWITHSUNDEEP
loopsforeachstata
rajvijay
rajvijay

Reputation: 1721

Stata year-quarter for loop

I am trying to create a loop in Stata. I run a model for the data <= year and <= quarter. Then predict one year look ahead. That is the model is run all time points upto the loop, while the prediction happens in the next quarter out of sample. So my question is how do I handle so that when yridx = 2000, and qtr = 4, the next quarter inside the loop look ahead would be year = 2005, and year = 1.

foreach yridx of numlist 2000/2012 {
forvalues qtridx = 1/4 {

regress Y X if year <= yridx and qtr <= qtridx
predict
}
}

Upvotes: 0

Views: 1257

Answers (1)

Nick Cox
Nick Cox

Reputation: 37208

It sounds as if it would be much easier to work in terms of quarterly dates. Here is one of several ways to do it. 

gen qdate = yq(year, qtridx) 
forval m = `=yq(2000,1)'/`=yq(2012, 4)' { 
    regress Y X if qdate <= `m' 
    predict <whatever> 
}

Upvotes: 1

Related Questions