Merging CRSP and Compustat for Book-to-Market Ratio Analysis
Learn how to merge CRSP and Compustat data to create book-to-market ratios by adding Permno as a unique identifier. Utilize CCM table for the merge process and implement SAS code for data manipulation. Enhance your understanding of financial data analysis with Wharton Research Data Services.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
4. Merge CRSP and Compustat. B/M Ratio
Merging CRSP and Compustat Add Permno (CRSP Identifier) to Compustat data. Using CCM (CRSP-Compustat Merge) table. Merge CRSP and Compustat data. Create Book to Market Ratios: Book Equity Year t -1 / ME December Year t-1 having ME June Year t is positive. 2 Wharton Research Data Services
CCM SAS Code 3 Wharton Research Data Services
4 Wharton Research Data Services
