Follow the steps below to import an Excel file into SAS OnDemand for Academics and Create a SAS data set
1) Login to SAS OnDemand for Academics
2) Select a folder under Files(Home) to upload the data to
3) Under 'Server Files and Folders on the left hand side, choose the 'Upload' option
4) select 'Choose Files' and find the file on your computer
5) Select 'Upload'
6) right click on the file in your folder and choose 'Import Data'
This will generate code.
If you wish to edit this code. Choose 'Edit'
7) Run this code to generate the SAS Dataset.
NOTE: By default the dataset will be put into your WORK library.
You can change this by editing the OUT= statement in the PROC IMPORT procedure.
I hope this helps!
Editor's note: SAS trainer @DomWeatherspoon created this video to help new users of SAS OnDemand for Academics get started.
... View more