Inner Join Merge

krg1140 — Thu, 11 Mar 2021 00:31:17 GMT

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;

Re: Inner Join Merge

ChrisNZ — Thu, 11 Mar 2021 01:22:24 GMT

1. Use the appropriate icon to paste code

2. What about

where audit_fees_4.company_fkey=firm_data.CIK and audit_fees_4.FYEAR=firm_data.FYEAR