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 onUpload
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.
PROC IMPORT
instead of Import Data
utilityThe 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
Share Share Tweet