Import a CSV file from an IU Cloud Storage location using SAS on IUanyWare
Note:
Before you can access files in IU Cloud Storage from an IUanyWare application, you must Set your storage preferences in the IU Cloud Storage portal.
In SAS on IUanyWare, to import a comma-delimited (.csv
) file from an IU Cloud Storage location:
- In the menu bar, click , and then select .
- In the "Import Wizard" dialog box, select , use the drop-down list to select , and then click .
- In the "Select file" window, click
- In the "Open" window, on the left, click .
- Double-click the icon for the cloud storage option that contains your file.
- Locate your file, click to select it, and then click .
, and then:
- Click
libref
corresponding to the library in which you want to store the CSV data.Note:To be available in the drop-down list, the appropriatelibref
must be associated with the library before you open the Import Wizard.
, and then, under "Library", use the drop-down list to choose the - Under "Member", enter a valid data set name, and then click
Alternatively, click
to generate and save a file containing a PROC IMPORT statement you can use to import the data again from the same source. Enter a filename or click to select an existing file, and then click . The resulting PROC IMPORT statement will look similar to this:PROC IMPORT OUT= WORK.data DATAFILE= "I:\mydata\data.csv" DBMS=CSV REPLACE; GETNAMES=YES; DATAROW=2; RUN;
. The data from the CSV file should appear in the library you selected.
If you have questions about using statistical and mathematical software at Indiana University, contact the UITS Research Applications and Deep Learning team.
For help with IUanyWare, contact your campus Support Center, or search this Knowledge Base.
This is document bdwf in the Knowledge Base.
Last modified on 2023-11-07 10:21:15.