I have two data tables produced from previous code. I need to create a loop which takes a data value given in one table, looks it up in another table and spits out a range of data.
One data set is dates with corresponding inflation points from the CPI. The other data table contains pairs of dates that represent an inflation episode. I would like to use the second date set (inflationepisodes) to filter the first table (cpi points) for data of just one episode for the entire time series.
So for example, in the picture below: the code would reference inlfationepisodes, and find all the data for the first inflation episode in a seperate table (ie, all data in cpi from 1968:02 to 1971:10), preferably this would be in a loop and spit out the data needed for each inflation episode.
I know these inflationepisodes are not accurate this is just for a school project I just need to figure out the looping process.