https://communities.sas.com/t5/SAS-Programming/Control-firm-pick/m-p/876046#M346141 <P>Dear Madam/Sir,</P><P>My goal is to have unique control firms (gvkey2) in a particular year that match between gvkey/merge_year in dataset1 and gvkey1/year in dataset 2. It could be multiple control firms (gvkey2) matched with gvkey in dataset 1 (=gvkey1 in dataset2) in a particular year.&nbsp;I attach a part of dataset2 (the original file contains 8 million observations) and dataset1.</P><P>Any programming advice will be highly appreciated.</P><P>&nbsp;</P><P>Thanks</P><P>Joon1</P> Tue, 16 May 2023 16:40:26 GMT joon1 2023-05-16T16:40:26Z https://communities.sas.com/t5/SAS-Programming/Control-firm-pick/m-p/876046#M346141 <P>Dear Madam/Sir,</P><P>My goal is to have unique control firms (gvkey2) in a particular year that match between gvkey/merge_year in dataset1 and gvkey1/year in dataset 2. It could be multiple control firms (gvkey2) matched with gvkey in dataset 1 (=gvkey1 in dataset2) in a particular year.&nbsp;I attach a part of dataset2 (the original file contains 8 million observations) and dataset1.</P><P>Any programming advice will be highly appreciated.</P><P>&nbsp;</P><P>Thanks</P><P>Joon1</P> Tue, 16 May 2023 16:40:26 GMT https://communities.sas.com/t5/SAS-Programming/Control-firm-pick/m-p/876046#M346141 joon1 2023-05-16T16:40:26Z https://communities.sas.com/t5/SAS-Programming/Control-firm-pick/m-p/876097#M346168 <P>Nobody is going to download those files and nobody (certainly not me) is going to understand or undertake your problem as written.&nbsp;</P> <P>&nbsp;</P> <P>A little bit more explanation, a working data step, an example of desired results, and things you've tried will g a long way toward helping someone help you.&nbsp;&nbsp;</P> Tue, 16 May 2023 20:55:11 GMT https://communities.sas.com/t5/SAS-Programming/Control-firm-pick/m-p/876097#M346168 HB 2023-05-16T20:55:11Z