WRDS

3 search methods

1. Browser-based access: Go to the WRDS website using form-based queries
2. Command Line Access: WRDS Cloud is accessible via SSH.
3. Interactive applications (connecting Remotely): Using stat programmes like PC-SAS, R, Matlab, and Stata on your desktop computer

1) Web Queries

Available to all account types.

WRDS offers a common interface and consistent data format across all databases or datasets.

1. Start by selecting a database from the Current Subscription list on the left menu.
2. Narrow it down to a desired dataset.
3. Select a data range.
4. 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
5. Select variables
   These are 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.
6. 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
7. Click the Submit Query button

2) Connecting Remotely

Available to the account types: Faculty and Ph.D.

WRDS data is further accessible remotely from your workstation or laptop, through many popular programming applications.
You can connect to WRDS and access WRDS datasets in the following interactive applications:

• SAS via PC-SAS/Connect
• Python via Jupyter Notebooks or Spyder
• R via RStudio
• MATLAB
• Stata

Look for more information on Programming at WRDS

3) The WRDS Cloud

Available to anyone with a WRDS faculty, staff, research assistant (RA), PhD account, or Masters account and is included in your WRDS subscription.

WRDS also provides a high performance computing cluster we call the WRDS Cloud. This system gives you command-line access to a powerful research computing system that provides direct access to all of our data and includes support for many powerful research programming languages. 

The WRDS Cloud is accessible via SSH, a way of easily and securely connecting to WRDS. Once connected, you can access WRDS data directly in your favorite programming languages. Languages supported on the WRDS Cloud:

• SAS
• Python
• R
• Stata (requires active Stata license with StataCorp)

Concerning access to the WRDS Cloud and how to use it, look for more information

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.

1. Select date and frequency range of date
2. Select database search method
3. Select variables
4. Select output format

The WRDS website offers documentation and a description of all databases available.

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

Get data (Data Dashboard): You can access the datasets using this query form. Here you can find datasets by browsing in the Content list.

Search WRDS: here you can search and download information by entering your search criteria. You can filter your search results by Site Map, Content Type, Vendor, Programming Language, Concept, and Region

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 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