Using data files with statistical and mathematical software on IUanyWare

When using local data files (i.e., files on a disk drive, such as a computer hard disk or flash drive) on IUanyWare, you need to point the IUanyWare program to your local (client) machine. With programs that use graphical user interfaces, you can do this by finding the appropriate computer and directory in the "Open" dialog box in the File menu (see When I use an IUanyWare application, how do I save my files?).

In other software packages that require syntax (or have the option of using syntax), you may be required to type a path to access a file. See the following syntax examples for the specific application you are using.

Each software section lists three examples: one to read in a software-specific file (or library), one to import a Microsoft Excel file, and one to read in a tab-delimited text file (with three variables and variable names in the first row). All examples are set up such that the desired files are in the hard disk location of C:\Temp; be sure to customize your locations and commands as necessary for your specific file.

Note:
Due to compatibility issues between 64-bit and 32-bit Excel files, we recommend that you save Excel files as CSV files if you find errors importing Excel files.

On this page:


Windows

Minitab

Minitab data file
WOpen "\\Client\C$\Temp\test.MTW".
Excel file
WOpen "\\Client\C$\Temp\test.xlsx"; 
FType; 
Excel. 
Tab-delimited text file
WOpen "\\Client\C$\Temp\test.txt"; 
FType; 
Text; 
DecSep; 
Period;  
Field; 
Tab; 
TDelimiter; 
DoubleQuote. 

R

R does not have its own data format. Additionally, UITS does not recommend that you import data into R directly from an Excel file. Rather, you should save the Excel spreadsheet as a CSV file or a text file and use one of the following commands:

  data <- read.csv("//Client/C$/Temp/Test.csv", header=T) 

  data <- read.table("//Client/C$/Temp/test.txt", header=T)

SAS

SAS library
LIBNAME st "\\Client\C$\Temp";
Excel file
PROC IMPORT OUT= work.newdata 
   DATAFILE= "\\Client\C$\Temp\test.xlsx" 
   [additional statements]
RUN; 
Tab-delimited text file
DATA work.newdata;
   INFILE "\\Client\C$\Temp\test.txt";  
   [additional statements]
RUN;

SPSS

SPSS data file
GET FILE='\\Client\C$\Temp\test.sav'. 
Excel file
GET DATA 
  /TYPE=XLSX 
  /FILE='\\Client\C$\Temp\test.xlsx' 
  [additional statements]
EXECUTE.
Tab-delimited text file
GET DATA
  /TYPE=TXT
  /FILE='\\Client\C$\Temp\test.txt'
  [additional statements]
EXECUTE.

Stata

Stata data file
use "\\Client\C$\Temp\test.dta", clear
Excel file
import excel "\\Client\C$\Temp\text.xlsx", clear
Tab-delimited text file
insheet using "\\Client\C$\Temp\test.txt", clear

Mac

The above examples will work on a Mac when you put your files in the Temp folder in your home directory (e.g., /Users/<username>/Temp). If your files are on the desktop, you can change the path to \\Client\C$\Users\<username>\Desktop\. For example, to read an Excel file to Stata, the code becomes:

  import excel "\\Client\C$\Users\<username>\Desktop\test.xlsx", clear

By default, the path \\Client\C$\ points to the home directory on your Mac unless you have configured it otherwise. You will need to structure your file path accordingly.

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.

This is document bbtr in the Knowledge Base.
Last modified on 2017-07-27 10:26:53.

  • 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.