File Format Specification
Previous Topic  Next Topic 

Standard Extensions and File-Type Tags

When a COPY command is given, Stat/Transfer tries to determine the file types of both the input and output files by looking for standard extensions.


An alternative for specifying the file type is to use a "file-type tag" instead of a standard extension.  In some cases, this tag is needed even when standard extensions are used.


See the table below for a list of the standard extensions and file-type tags used by Stat/Transfer. A list of standard extensions and file-type tags can be obtained by typing:


   help formats


at the command prompt.


Standard Extensions

If you use standard file extensions for your input and output file names, these will usually tell the Stat/Transfer command processor what kind of file is to be read or written.  Occasionally you will need to add a file-type tag as well.


File-Type Tags

File-type tags are needed in two different situations:




Distinguishing Versions of an Output File Type

In those cases where different versions of a given file type use the same standard extension, the standard extension will not enable Stat/Transfer to distinguish between different versions on output. To write a version other than the default version, the output file name must be preceded by a file-type tag, which identifies the appropriate output version. 


Note: For JMP files, a file type tag may be necessary on input as well.


Whenever the same standard extension appears in the table below for a given file type, you must use a file-type tag.  The default version is marked with an asterisk.


File Names without Standard Extensions

If your file does not have a standard extension, you must precede the file name by a file-type tag, which indicates the file type.


For example, if you want to write a Windows SAS file that has a .dat extension instead of an .sas7bdat extension, you can type


  copy  indata.xls   sas outdata.dat


where 'sas' indicates that the output file is to be a SAS Windows file, while the standard extension .xls identifies the input file as an Excel worksheet.


Distinguishing Between File Names and File-type Tags

The command processor uses the presence of a period '.' to differentiate between extensions and file-type tags.  Therefore, when using the COPY command, you must either use a period in your file name or, if the name does not contain a period, then you must use one after the file name.


For example, if you have a Stata file named populat, and you are going to a 1-2-3 file, populat.wk3 , the COPY command would look like:


   copy stata populat.   populate.wk3


The file-type tag must be used since the input file does not have a standard extension.  The period after the file name tells Stat/Transfer that this is the file name.


The standard extensions and file-type tags used by the command processor are:



File Type

Extension

File-Type Tag

Default


1-2-3

wk?

123



Access

mdb

access



ASCII - Delimited                

txt, csv

delim



ASCII - Delimited with Schema

stsd (Schema file)

stdelim



ASCII - Fixed with Schema

sts (Schema file)

stfixed



dBASE and compatibles        

dbf

xbase



DDI Schemas

xml

ddi



Epi Info

rec

epi



EViews

wf1

eviews



Excel 2007+

xlsx

excelx



Excel 97+

xls

excel

   **


Excel Version 2

xls

excel2



FoxPro

dbf

xbase



Gauss '96

dat

gauss



GenStat

gwb

gwb



HTML

htm*

html



JMP Version *

jmp

jmp*



     Please see the discussion of JMP in the Supported Files Section.



LIMDEP

lpj

lpj



Matlab 7

mat

matlab7

   **


Matlab

mat

matlab



Mineset

schema, sch

mineset



Minitab

mtw

minitab



Mplus

inp

mplus



NLOGIT

lpj

nlogit



ODBC

[none]

odbc



OpenDocument Spreadsheet

ods

od



OSIRIS

dict, dct

osiris



Paradox

db

paradox



Quattro Pro

wq?, wb?

quattro



R

rdata

r



RATS

rat

rats



SAS V6 (Windows and OS/2)

sd2

sas2



SAS V6 (Mac, Unix-HP, Sun, IBM)

ssd01

sas1



SAS V7and V8

sas7bdat

sas



SAS V9

sas7bdat

sas9

  **


SAS CPORT

stc

cport



SAS Transport Files

xpt, tpt

sasx



S-PLUS

.

splus

  **


S-PLUS (HP, IBM, Sun Unix)

.

splus-hl



SPSS Data Files

sav

spss



SPSS Data Files (HP,IBM,SunUnix)

sav

spss-hl



SPSS Portable Files

por

spssp



SPSS "Syntax" and Data File

sps

spsss



SPSS Program and ASCII data

sps

spss-dat



Stata

dta

stata

 


Stata Program and ASCII Data

do

stata-dat



Statistica Version 5 and 6

sta

statistica

  **


Statistica Version 7+

sta

statistica7



SYSTAT

sys

systat



Triple-S

xml

sss