- Using PROC SQL, perform an inner join to merge Audit Fees 2 and Firm Data. Merge observatiosn where COMPANY_FKEY equals CIK and observations have the same fiscal year (FYEAR).
So far I have: but I'm not sure how to also make it ensure they have the same FYEAR? Any advice?
proc sql;
create table Firm_Audit as
select *
from audit_fees_4, firm_data
where audit_fees_4.company_fkey=firm_data.CIK
quit;