Search the site...

SASCRUNCH TRAINING
  • Home
  • Member's Area
  • How to Start
  • SAS Interface
  • Creating a Data Set
  • Practical SAS Training Course
  • SAS Certified Specialist Training Program
  • Proc SQL Course
  • Introduction to Time Series Analysis
  • SAS Project Training Course
  • Full Training / Membership
  • Sign up
  • About us
  • Contact us
  • Home
  • Member's Area
  • How to Start
  • SAS Interface
  • Creating a Data Set
  • Practical SAS Training Course
  • SAS Certified Specialist Training Program
  • Proc SQL Course
  • Introduction to Time Series Analysis
  • SAS Project Training Course
  • Full Training / Membership
  • Sign up
  • About us
  • Contact us
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:
Picture

​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:
Picture

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:
Picture

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].
Picture
Don't know how to start? We will give you a hand:
  • Download the data
  • How do I import the CDM data?
  • What are CDM data sets?
  • What is the project goal?​
Picture
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.
What are CDM Data Sets?
Already a member? Go to member's area.