Please Note: DBMS/Copy and Compare is no longer being sold and not supported by any vendor. Use Stat Transfer first for any file conversions. DBMS/Copy and Compare is still useful for older (pre-2000) file type conversions.
Lab Version: v8.0.0A & v7.0.0 (both on all Windows based lab workstations)
DBMS/Copy is a general purpose conversion software. It translates and transfers data between over 70 different data management systems, spreadsheets, statistical software, ODBC, and other application packages. DBMS/Copy is a very useful program for converting data from one format, such as an Excel spreadsheet, to another format such as a Stata ".dta" file. It has an easy-to-use graphical interface and can convert among dozens of different file types.
DBMS/Compare is that it is a multiple file comparison, data audit and analysis program. The program can scan any directory tree (including an entire disk), grab a list of all the variables in all the data files from multiple file formats, build views showing all variables across all databases and all databases across all variables. From there you can get value lists across multiple databases and do record by record comparisons across any number of databases. All information can be saved to Excel, HTML and ASCII files.
Useful Guides for DBMS/Copy and Compare:
- Converting Excel and other spreadsheet files
- Converting Stata, SAS and similar files
- Converting Ascii delimited files
- Converting Ascii fixed format files
- Translating datasets with DBMS/Copy 7
Common file types:
|File type (extension):||DBMS/Copy pseudo-extension:|
|ASCII (dat) (*)||ascii2|
|Excel 5 (xls)||xls5|
|Excel 97/2000 (xls)||xls7|
|Gauss (dat, dht)||gauss|
|Limdep binary (sav)||limsav|
|Limdep ASCII (dat)||limdat|
|Stata v6 8 byte doubles (dta)||stata6|
|Stata v6 4 byte doubles (dta)||stata64|
|Stata v7 8 byte doubles (dta)||stata7|
|Stata v7 4 byte doubles (dta)||stata74|
|Stata SE 8 byte doubles (dta)||statase|
|Stata SE 4 byte doubles (dta)||statase4|
|SAS for Windows v6 (sd2)||sd2|
|SAS for Windows v7 (sd7)||sd7|
|SAS for Windows v8 (sas7bdat)||sas7bdat|
|SAS for Unix v7/v8 (sas7bdat)||sas7sun|
(*) To read an ASCII file you will need the interactive session (in order to specify the file's structure). If you write a file as ASCII, DBMS will write it as a comma-delimited file with a first row of headers (variable names).