I am following up on two earlier posts regarding using SAS On Demand for Academics. The version of EM has been upgraded to 6.1, which means that I am now able to upload and reach non-SAS files on the SAS Server – hurray!
- Find the directory path for your course on the SAS server. Login into SODA (https://support.sas.com/ctx3/sodareg/user.html). Near the appropriate course that you registered, click on the “info” link. Scroll down to the line starting with “filename sample” and you’ll find the directory path.
- Upload the file of interest to the SAS server via FTP. Note that you can upload txt and csv files but not xls or xlsx files. The hostname is sascloudftp.sas.com . You will also need your username and password. Upload your file to the path that you found in #1.
- To read the file in SAS SODA EM, start a new project. When you click on its name (top left), you should be able to see “Project Start Code” in the left side-bar. Click on the …
- Now enter the SAS code to run for this project. The following code will allow you to access your data. The trick is both to read the file and to put it into a SAS Library where you will be able to reach it for modeling. Let’s assume that you uploaded the file sample.csv:
libname mylibrary ‘/courses/…/’; THIS IS YOUR PATH
filename myfile ‘/courses/…/sample.csv’; USE THE SAME PATH
infile myfile DLM=’2C0D’x firstobs=2 missover;
input x1 x2 x3 …;