The File Specification Line
Previous Topic  Next Topic 

Input File

The input data file is chosen using the second line of the Transfer dialog box, the File Specification line.


If your files are named using the standard file extensions for Stat/Transfer, given below, you will ordinarily use the Browse control to select a file.


When you click on Browse, a standard File Open dialog box will open.  To select the input file, first make sure that the path is the correct ones for your input file.  If not, change to the correct one.


Next, you need to select the correct file.  Note that a wildcard file specification, '*.ext' has been created for the File Name entry, where 'ext' is the Stat/Transfer standard extension for the type of input data file you have selected.


All of the files in the current directory with this extension will appear in a list box below the File Name line.  Either use this list and click on the name of the file you wish to use or type the name on the File Name line.


The ? Button

If you click on the '?' button beside the File Specification line, you can obtain information on the file type currently displayed.


International Character Sets

If you have a problem reading international character sets, please see the Encoding Options entry in the Options dialog box.


                                      Standard File Extensions

            


1-2-3

wk*


Access

mdb


ASCII - Delimited                

txt, csv


ASCII - Delimited  with Schema  

stsd (Schema file)


ASCII - Fixed Format

sts (Schema file)


dBASE and compatibles        

dbf


DDI Schemas

xml


Epi Info

rec


EViews

wf1


EXCEL

xls


FoxPro

dbf


Gauss                            

dat


GenStat

gwb


HTML

htm*


JMP

jmp


LIMDEP

lpj


Matlab

mat


Mineset

schema, sch


Minitab

mtw


NLOGIT

lpj


ODBC

[none]


OpenDocument Spreadsheet

ods


OSIRIS

dict, dct


Paradox

db


Quattro Pro

wq?, wb?


R

rdata


RATS

rat


SAS for Windows and OS/2

sd2, sas7bdat


SAS for the Macintosh and Unix

ssd01, sas7bdat


SAS CPORT

stc


SAS Transport Files

xpt, tpt


S-PLUS

[none]


SPSS Data Files

sav


SPSS Portable Files

por


SPSS "Syntax" and Data Files

sps


Stata

dta


Stata Program and Data Files

do


Statistica

sta


SYSTAT

sys


Triple-S

xml

       

See also:

Selecting Worksheet Pages

Selecting Tables for Access and ODBC Input

Selecting Members of SAS Transport Files

Most Recently Used File Lists