How to Upload Data to SAS OnDemand for Academics

In this tutorial, we will show you how to upload files to SAS OnDemand for Academics, allowing you to use files stored on your computer within the SAS OnDemand for Academics.

SAS OnDemand for Academics is a web-based version of SAS Studio, allowing you to access SAS for free without requiring installation of SAS on your computer.

When uploading a file to SAS OnDemand for Academics, the file can be in any format like CSV, Excel, text etc. The file does not need to be in the SAS data file format (.sas7bdat).

To use a file that's saved on your computer, follow these two simple steps.

First, upload the file to your SAS OnDemand for Academics account.
Import the uploaded file using either Import Data utility or PROC IMPORT procedure.

Please refer to the video below to follow the steps for uploading and importing a file into SAS OnDemand for Academics.

Steps to upload and import a file into SAS OnDemand for Academics.

Go to the desired folder where you want to import the file. It is located on the left-hand side of the screen under Server Files and Folders pane.
Right click on the folder and then click on Upload Files.
Click on Choose Files and then locate and select the file you want to import. Then click on Upload button
Once done, the file should be appeared in the folder you selected in step 1.
In the folder where file is imported, locate the imported datafile and then right click on it and select the Import Data option.
Click on the Run button to start importing.
SAS Studio will import the CSV file and create a new dataset. By default, the imported dataset will be available in the WORK library.

The Import Data utility automatically show the file information and generate SAS code for importing.

Upload Data to SAS OnDemand for Academics

Import Data using PROC IMPORT instead of Import Data utility

The basic syntax of PROC IMPORT is as follows. The following SAS code creates a SAS dataset named MYDATA in the temporary library called WORK.

PROC IMPORT DATAFILE='/home/deepanshu88us0/mydata/customers.csv'
	DBMS=CSV
	OUT=WORK.MYDATA;
	GETNAMES=YES;
RUN;

Make sure to change the location of the file and dataset name in the above code. To learn more about PROC IMPORT procedure, click on the link - PROC IMPORT: Detailed Guide

About Author:
Deepanshu Bhalla

Deepanshu founded ListenData with a simple objective - Make analytics easy to understand and follow. He has over 10 years of experience in data science. During his tenure, he worked with global clients in various domains like Banking, Insurance, Private Equity, Telecom and HR.

While I love having friends who agree, I only learn from those who don't
Let's Get Connected Email LinkedIn