Linking Yearly GDP Growth Data to daily Outcomes

[Heinrich Zitzewitz]

Hejo community,

I have a panel data set of 50.000 rows withing daily data for the loan supply of banks. As I want to conduct a DiD regression on the impact of CapitalRequirements on banks lending supply, I want to link the GDP growth to my estimation.

The data set is from year 2010-2019.

How do I link the yearly GDP growth to my regression?

"reg DealAm TotalA GDPGrowthEU Inflation" My Regression ends up in only 20 Obs, instead of 50.000, because Inflation and GDP only fill in 20 rows.

I want to link the GDP and Inflation to all 50.00 rows.

Thanks in advanced.

Heinrich

[Jared Greathouse]

Can you define what precisely we mean by "link" them? Heinrich Zitzewitz ?


It seems like you have missing data. Use dataex to show your data, and we'll figure out what the issue is

[Heinrich Zitzewitz]

Hejo Jared, thanks a lot for the response.

below my dataexample. I have BankName, DealAm, DealDate, Year1(for my period dummy), Year ( for GDP, Inflation) and Bankid.

So the problem is that I want wo link, for example for 2014, the GDP growth of 0.16 to all Deals which happen in the year 2014, for all Banks. Furthermore, I try to get rid of "repeated time values within panel", because I have several Deals at one day and for each bank there are ca. 2000 rows distributet ind 2010-2019 deals.

I hope this makes the problem clear. Dont know if this is the correct way of using dataex.

Thanks in advance.

input str68 BankName double DealAm int(Date Year1 Year) double(GDPGrowthEU Inflation) float bankid
"KBC Group" 8.900e+08 18288 2010 2010 .022 .018 12
"KBC Group" 8.900e+08 18288 2010 2011 .018 .029 12
"KBC Group" 7.800e+09 18291 2010 2012 -.007 .026 12
"KBC Group" 7.800e+09 18291 2010 2013 0 .013 12
"KBC Group" 7.800e+09 18291 2010 2014 .016 .004 12
"KBC Group" 2.500e+10 18305 2010 2015 .023 .001 12
"KBC Group" 2.500e+10 18305 2010 2016 .02 .002 12
"KBC Group" 2.500e+10 18305 2010 2017 .028 .016 12
"KBC Group" 2.500e+10 18305 2010 2018 .021 .018 12
"KBC Group" 2.500e+10 18305 2010 2019 .016 .014 12
"KBC Group" 2.100e+09 18308 2010 . . . 12
"KBC Group" 2.100e+09 18308 2010 . . . 12
"KBC Group" 2.100e+09 18308 2010 . . . 12
"KBC Group" 3.500e+08 18311 2010 . . . 12
"KBC Group" 5.000e+09 18319 2010 . . . 12

format %tdnn/dd/CCYY Date
[/CODE]