Data Import

Below is the step-by-step guide on how to import the data files.

Step 1: save and unzip the project_1_sdtm_dm.zip file in your 'myfolders' folder:

​Note: you need to save the folder in your 'myfolders' folder only if you are using the SAS University Edition. If you are using SAS 9.4 or SAS EG, you can save the file anywhere on your system where SAS can access.

The folder contains four Excel spreadsheets:

Step 2: Open SAS Studio and run the code below:
​Libname CDM '/folders/myfolders/Project_1_SDTM_DM';

PROC IMPORT DATAFILE= "/folders/myfolders/Project_1_SDTM_DM/DEATH.xlsx"
            DBMS=XLSX OUT= CDM.DEATH;
     GETNAMES=YES;
RUN;

After execution, the code above should have imported the DEATH data set. You can find it in the CDM library:

You can use the same code to import the other three data sets.

Important Note

​Did you get the following error message?

ERROR: Physical file does not exist

This message means there is an incorrect directory path in your code.

If you're using SAS Studio, the paths below are incorrect:
​
"C:\SASUniversityEdition\myfolders\Project_1_SDTM_DM/DEATH.xlsx"
"C:\myfolders\Project_1_SDTM_DM/DEATH.xlsx"

Please note that SAS Studio runs on a virtual machine. It doesn't connect directly to your C drive. 

Whenever you have a C drive (or any other drive) in your directory path, it is incorrect.

Correct:

"/folders/myfolders/Project_1_SDTM_DM"

The path above is the correct path. For more information about data import, please visit data set [9-14].
Want to talk to an instructor?

Fill out the form below if you want to:
  • Ask a question about the project or
  • Schedule a live-chat appointment or
  • Receive the solution for the project

*You can schedule a live chat appointment during these periods:
  • Every Wednesday 9-11 am EST
  • Every Sunday 9-11 am EST
Fill out my online form.