Just wondering if anyone has codes to get data from WRDS>Compustat>North America
I would like to get Fundamentals Quarterly, with date range Jan/2010 to Dec/2011,
Consolidation Level C
Industry Format INDL FS
Data Format STD
Population Source D
Quarter Type Fiscal View
Company Status Active Inactive
I am looking for variables like Company Name, Current Assets-Total (ACTQ), Non-Current Assets-Total (ANCQ), Assets-Total (ATQ), etc..
I have company codes such as CIK (0000731859, 0001097575, 0000827165, 0001102238, 0001114605, 0000810208, …… ) and Ticker (and also CUSIP) for the companies that I am looking for.
Can I use these codes?
Or I have to get GVKEY to use in SAS code if I want to get the data, if so, any suggestions on how to get GVKEY using CIK or Ticker or CUSIP
Thanks and appreciate your help
Why would you not use the WRDS web query form for Compustat data, which allows you to specify all the filters you mention? You can also have a local text file of CUSIPs (and a second one of tickers, and third one of CIK's) to drive the company selection in the web query. Just choose the "upload a plain text file" option.
It even produces SAS (or STATA or CSV, or XLSX) files for download.
I would assume under Support/Sample Programs but you have to be logged in and I don't have an account.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.