Using SAS on IUanyWare, how do I import a comma-delimited (CSV) file from my IU Box account?

Before you can access your Indiana University Box account from an IUanyWare application, you must authorize access in the IU Cloud Storage portal. For instructions, see Configure your storage preferences. Alternatively, you can set up desktop access to your Box account using WebDAV; however, Box does not officially support WebDAV connections. For instructions, see Access an IU Box account with FTPS or WebDAV.

In SAS on IUanyWare, you can use the Import Wizard to import a comma-delimited (.csv) file from your IU Box account:

  1. In the menu bar, click File, and then select Import Data.
  2. In the "Import Wizard" dialog box, select Standard data source, use the drop-down list to select Comma Separated Values (*.csv), and then click Next.
  3. In the "Select File" window, click Browse, and then:
    1. In the "Open" window, on the left, click This PC.
    2. Double-click the Box icon.
    3. Navigate through your Box folders to locate your file, and then click to select it.
    4. Click Open.

    Alternatively, if you configured WebDAV access to your Box account, click This PC, and then double-click the appropriate network drive (in Windows) or server (in OS X) to access your Box folders and locate your file.

  4. Click Next, and then, under "Library", use the drop-down list to choose the libref corresponding to the library in which you want to store the CSV data.
    Note:
    To be available in the drop-down list, the appropriate libref must be associated with the library before you open the Import Wizard.
  5. Under "Member", enter a valid data set name, and then click Finish. The data from the CSV file should appear in the library you selected.

    Alternatively, click Next 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 Browse to select an existing file, and then click Finish. 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;

If you have questions about using statistical and mathematical software at Indiana University, contact Research Analytics. Research Analytics is located on the IU Bloomington campus at Woodburn Hall 200; staff are available for consultation Monday-Friday 9am-noon and by appointment.

Note:
For details about availability of UITS services during winter break, see UITS winter break support hours.

This is document bdwf in the Knowledge Base.
Last modified on 2017-12-08 14:47:47.

  • Fill out this form to submit your issue to the UITS Support Center.
  • Please note that you must be affiliated with Indiana University to receive support.
  • All fields are required.

Please provide your IU email address. If you currently have a problem receiving email at your IU account, enter an alternate email address.

  • Fill out this form to submit your comment to the IU Knowledge Base.
  • If you are affiliated with Indiana University and need help with a computing problem, please use the I need help with a computing problem section above, or contact your campus Support Center.

Please provide your IU email address. If you currently have a problem receiving email at your IU account, enter an alternate email address.