Connecting to WRDS Platform via Stata

November 6, 2019

Members of the Harvard Business School community can now access the Wharton Research Data Services (WRDS) platform via Stata. Stata connects to WRDS through ODBC, a standard application programming interface for accessing database management systems. For this reason, it is important to follow these comprehensive step-by-step instructions: https://www.stata.com/blog/wrds/Stata_WRDS.pdf.

When setting up the connection, please keep a few things in mind:

  • Be sure to have your WRDS username and password (the same information you use to login on the WRDS website) on hand.
  • Know whether your machine is 64-bit or 32-bit.
    • Windows users can check this by typing “Control Panel” in the Start menu. From there, go to “System and Security,” and then click “System”. The operating system will be listed under “System type.”

Screenshot of "System" window with OS information highlighted.

  • Once you link Stata to the WRDS server, you will only be able to access the tables for which HBS has a subscription. Therefore not all of the tables you see listed may be available. If you get an error in STATA that reads “permission denied SQLSTATE=42501,” HBS does not have a subscription to this dataset. You can check the subscriptions available to you by logging into your WRDS account.