Skip to Main Content
HBS Home
  • About
  • Academic Programs
  • Alumni
  • Faculty & Research
  • Baker Library
  • Giving
  • Harvard Business Review
  • Initiatives
  • News
  • Recruit
  • Map / Directions
Research Computing Services
  • Online Requests
  • FAQ
  • Blog
  • Contact Us
  • About Us
  • Faculty Projects
  • Training
  • Compute Cluster & Data Storage
  • Data Practices
  • Help
  • …→
  • Harvard Business School→
  • Research Computing Services→
  • Compute Cluster and Data Storage
    • Compute Cluster and Data Storage
    • Compute Cluster
    • Data Storage
    • Database Server
    • Other Research Computing Environments
    →
  • Database Server
    • Database Server
    • Configuration Files Recommended for Connecting
    • MySQL Client
    • NaviCat
    • NoMachine
    • ODBC
    • Python
    • R
    • SAS
    • Stata
    • Tableau
    • Terminal
    →
  • SAS→

Database Server

Database Server

  • Configuration Files Recommended for Connecting
  • MySQL Client
  • NaviCat
  • NoMachine
  • ODBC
  • Python
  • R
  • SAS
  • Stata
  • Tableau
  • Terminal

SAS

SAS

  • Compute Cluster
  • Data Storage
  • Database Server
    • Configuration Files Recommended for Connecting
    • MySQL Client
    • NaviCat
    • NoMachine
    • ODBC
    • Python
    • R
    • SAS
    • Stata
    • Tableau
    • Terminal
  • Other Research Computing Environments
5ms

SAS on your Local Windows Machine

SAS uses ODBC to connect to MariaDB. Please refer to our ODBC section on how to set up your ODBC driver and configure your Data Source.

Once your connection settings are validated you may launch SAS and assign your MariaDB database in the libname statement. In the example below 'myMariaDB' points to a personal database while 'projectMariaDB' points to a project database. In the first libname statement datasrc= 'RCS_MariaDB' refers to the personal database that was already set up in ODBC Data Source; and datasrc= 'MariaDB2' in the second libname statement refers to the project database that was also established in ODBC Data Source.

libname myMariaDB odbc user= 'username' password= 'password' datasrc= 'RCS_MariaDB'; libname projectMariaDB odbc user= 'username' password= 'password' datasrc= 'MariaDB2';

Once your libname statements are successfully run you can continue on with your SAS codes.

ǁ
Campus Map
Research Computing Services (RCS) 
Harvard Business School
Baker Library, B90, 25 Harvard Way
Boston, MA 02163
Phone: 617.495.6100
Email: research@hbs.edu
→Map & Directions
→More Contact Information
→Terms Of Service
  • Make a Gift
  • Site Map
  • Jobs
  • Harvard University
  • Trademarks
  • Policies
  • Accessibility
  • Digital Accessibility
Copyright © President & Fellows of Harvard College