These two lines of code are actually one line in my SAS code. This is great, but to pull the data down onto our computer, we need a different program.
The fourth line of code references the backend table and calls this table intl. We can either log on to the backend and look at the full tables, or we can pull data directly via the SAS connection. The data dictionary we pulled above made it look like AUOP was concatenated with both the auditor and the opinion, but it appears in the dataset that these are actually separate variables. The online menu buttons link to these and pulls specific variables, however, there are more variables available on the backend than what appear to be available via the online menu. If one searches for AUOP within this page, AUOP will not be found. If we want to know if a particular variable is available via the online menu, we can take a look at the contents of the SAS table and do a keyword search for the variable we want. Note that the menu list feeds from a specific SAS table on the backend of Compustat. There is a circular question mark button the right of each variable which will pull up examples or definitions of the variable.
To pull data in this way, the user browses through the online menu and clicks the variables needed.
Log onto WRDS - Compustat - Global - Fundamentals Annual - Manuals and Overviews - Compustat Global (FTP) Version Data Manual - Auditors Codes. If you are going to use the.do files and.sas files included in this document, you must have the same folder on your c-drive.ĭo not create this within your documents or user folder Go directly onto your C-drive to create this folder.
0 kommentar(er)
