DBMSCopy and Compare

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:

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