Guides: WRDS: How to Search

How to Search - in Brief (Web Query)

WRDS offers a common interface and consistent data format across all databases or datasets. Start by selecting a database from the Current Subscription list on the left menu. Then narrow down to a desired dataset.

On the search form, proceed with the following:

Select a data range
Select entities / companies. There are additional options for entering codes:

manually enter codes
upload a file containing entities / companies codes. This file should contain codes recognized by WRDS and saved in "Formatted Text" format
retrieve saved codes from "my WRDS"
search across the entire database

Select variables - that is the items you want to include in your output report. Each dataset has its own specific set of variables. Use the Conditional Statements to screen the companies when you search across the entire database.
Select the output format: choose among fixed-width text (*txt), comma-delimited format (*.csv), Excel (*.xls), HTML table (*.htm), SAS Windows and Solaris (*.as7bdat), SPSS file (*.sav) and more
Cick the Submit Query button

How to Search - in Detail (Web Query)

Requirements:
Firefox, Chrome, Safari or Internet Explorer (IE7 or greater).
When you have a compatible web browser you have access to a wide array of data using the same web-based interface on all datasets / databases.

How to run a web query in four steps:
Web query has the same general format for all databases in WRDS.
You need to complete four steps before submitting your request. For the largest databases, choosing the entire database is not an option because of the size of the databases, which exceed 2GB.

Basic Search Tips in the WRDS

Follow this link to see a WRDS Demo. You don't have to be registered in order to look into this demo.

The WRDS web site offers the documentation and description of all databases available.

Each database is accompanied by a general description, various components of the database, descriptions of variables, access to
manuals and a FAQ section.

Get data: You may also access the datasets using this query form. Here you can find datasets by browsing in the subject list.

Search WRDS: here you can search and download information by entering your own search criteria. In Advanced Search you can
limit your search to certain areas: Support Section, Data Query Forms, News, Forums, Knowledge Base.

Additional resources are available from any WRDS web page by clicking on the "support" tab located at the top of your screen. You will
find several listings including:

WRDS FAQ: This resource contains the most detailed information on using WRDS, including a system overview, data content
and access, and extensive help on using SAS and FORTAN programs to extract data.
SAS FAQ: This is an excellent resource for users just getting started with SAS.
Online Manuals: All electronic manuals published by vendor providers (i.e. CRSP) are available under this link.
Downloads: TCP script for connecting to WRDS via SAS/CONNECT

Three ways to search WRDS

There are three search methods to search into WRDS:

Browser-based access: Go to the WRDS website using form-based queries
Command Line Access: Through a UNIX terminal session
Interactive applications: Using stat programmes like PC-SAS, R, Matlab, and Stata on your desktop computer

Note! In this guide main focus will be on the "Browser-based Access".

Three ways to search WRDS
A short description on how to search WRDS - in three ways

Searching the WRDS - step by step search in COMPUSTAT

Searching the WRDS - a small guide
In the attached document you'll find a small step-by-step guide on how to perform a search in COMPUSTA via WRDS