Get Started

Importing SAS files

In this exercise, you'll figure out how to import a SAS file as a DataFrame using SAS7BDAT and pandas. The file 'sales.sas7bdat' is already in your working directory and both pandas and matplotlib.pyplot have already been imported as follows:

import pandas as pd
import matplotlib.pyplot as plt

The data are adapted from the website of the undergraduate text book Principles of Econometrics by Hill, Griffiths and Lim.

This is a part of the course

“Introduction to Importing Data in Python”

View Course

Exercise instructions

  • Import the module SAS7BDAT from the library sas7bdat.
  • In the context of the file 'sales.sas7bdat', load its contents to a DataFrame df_sas, using the method .to_data_frame() on the object file.
  • Print the head of the DataFrame df_sas.
  • Execute your entire script to produce a histogram plot!

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

# Import sas7bdat package
from ____ import ____

# Save file to a DataFrame: df_sas
with SAS7BDAT('sales.sas7bdat') as file:
    ____

# Print head of DataFrame


# Plot histogram of DataFrame features (pandas and pyplot already imported)
pd.DataFrame.hist(df_sas[['P']])
plt.ylabel('count')
plt.show()
Edit and Run Code