https://communities.sas.com/t5/Statistical-Procedures/merging-compustat-global-annual-data-and-compusat-global/m-p/391399#M20430 <P>How can I merge CRSP(price) monthly and COMPUSTAT annual data?</P><P>Should I merge using specific month(December) or make average of the year?</P><P>or just go with 12 maximum same data set with only the price varying?</P><P>&nbsp;</P><P>Thank you in advance <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Tue, 29 Aug 2017 07:11:28 GMT SKKUsoohongpark 2017-08-29T07:11:28Z https://communities.sas.com/t5/Statistical-Procedures/merging-compustat-global-annual-data-and-compusat-global/m-p/391399#M20430 <P>How can I merge CRSP(price) monthly and COMPUSTAT annual data?</P><P>Should I merge using specific month(December) or make average of the year?</P><P>or just go with 12 maximum same data set with only the price varying?</P><P>&nbsp;</P><P>Thank you in advance <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Tue, 29 Aug 2017 07:11:28 GMT https://communities.sas.com/t5/Statistical-Procedures/merging-compustat-global-annual-data-and-compusat-global/m-p/391399#M20430 SKKUsoohongpark 2017-08-29T07:11:28Z https://communities.sas.com/t5/Statistical-Procedures/merging-compustat-global-annual-data-and-compusat-global/m-p/391400#M20431 <P>Use PROC EXPAND as in this example</P> <P>&nbsp;</P> <P><A href="http://support.sas.com/documentation/cdl/en/etsug/63939/HTML/default/viewer.htm#etsug_expand_sect005.htm" target="_blank">http://support.sas.com/documentation/cdl/en/etsug/63939/HTML/default/viewer.htm#etsug_expand_sect005.htm</A></P> Tue, 29 Aug 2017 07:13:01 GMT https://communities.sas.com/t5/Statistical-Procedures/merging-compustat-global-annual-data-and-compusat-global/m-p/391400#M20431 PeterClemmensen 2017-08-29T07:13:01Z