Dear Stata community readers,
I’m matching firms loan data with firms accounting data in an international sample and I need to match firms’ fiscal year ending accounting data priori to the firms’ loan issuance. For example, suppose firm A obtained a loan in 01/05/2022. I would like to write a code in stata to match firm A loan data with the closest fiscal year ( 11/10/2021) ending to show the true impact on loan spread. My merging code : merge 1:m using a country name , firms’ ticker. Help is greatly appreciated