Home > Business Databases > Updated conditional statements feature in WRDS

Updated conditional statements feature in WRDS

WRDS conditional statements

An example of nested conditional statements, taken from WRDS help pages.

Wharton Research Data Service (WRDS) is praised for offering a consistent user interface across the many databases that it houses, so, when a new search feature is released, it will be available for all users. They have updated the conditional statements builder and made it more powerful and easy to use. We will look at Compustat Global in this example.

What is the conditional statement builder?

To quote WRDS support, you can “build unlimited conditional statements using the list of variables, comparison operators, desired values, and logical operators”. The conditional statement builder still forms part of Step 2: Apply your company codes, but you will need to come back after completing Step 3 Query variables before it will work.

How do I use the conditional statement builder?

Search the entire database

As before, you can choose to select companies individually, upload a list, or “Search the entire database”. Choose this last option if you wish to use the conditional statement builder to reduce the scope of your search using any query variable. For example, you may want to search for companies located in one country, or those with total assets over a threshold, or those in a particular sector. Note that you will need to include the relevant query variable in Step 3: Query variables before applying the conditional statement builder.

Select query variables

Scroll back up to Step 2, click “Activate Conditional Statement Builder”.

Activate conditional statement builder

Add rules one at a time, selecting one of the chosen query variables and a condition (equals, not equals, greater than, begins with, and so on). You can choose to join with AND or OR logical operators. You can add groups of statements and join them.

Build your statements

What help is available?

You must take care to use the right units, scale and codes. To check the acceptable values to use, check the Variable Descriptions tab at the top of the page, or perform a small search and look at the kind of results it gives.

There is a short help page by WRDS on conditional statements, click the link labelled “How does this work?” above the builder.

Advertisements
Categories: Business Databases Tags:
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s