DBMS Engines for converting data into SAS

DBMS/Engines Executive Summary...

Enables your SAS programs to directly read and write any of the supported packages.

Overview...

DBMS/Engines integrates seamlessly into the SAS Software System. With DBMS/Engines, your SAS programs become data independent. Just like DBMS/COPY, DBMS/Engines handles variable names inconsistencies, dates, times and missing values. SAS software combined with DBMS/Engines lets you do your job more efficiently— analyze data — not moving it around.

Order a copy of DBMS/Engines

Download an evaluation copy of DBMS/Engines

So What's An Engine?

SAS communicates with data files through engines. When a SAS procedure wants to read data from a file it asks the engine to get the records. When the data-step wants to write data to a file, it tells the engine to write the records. DBMS/Engines supplies the engines you need to access the data you use.

All DBMS/COPY Formats Supported!

DBMS/Engines for Windows supports all data formats supported by DBMS/COPY for Windows including all of the spreadsheets, databases, statistical analysis packages, ASCII files and more. (See the DBMS/COPY for Windows page for the complete list.) With DBMS/Engines’ built-in ODBC support, you can read and write Microsoft Access, Oracle, Sybase and other SQL based packages.

SAS Transport Eliminator!

Do you have to run SAS on one computer to build a transport file and then run SAS again on the other computer to read that transport file? With DBMS/Engines for Windows, your SAS program will seamlessly and directly read and write SAS for Unix including Sun, HP, IBM and DEC datasets!

Read Unix Data!

DBMS/Engines reads and writes the following Unix based packages: S-PLUS, SPSS, Stata, Systat, Gauss, BMDP and Minitab. We are committed to making UNIX package support as comprehensive as possible.

"A Sample Program Is Worth A Thousand Words!"

Just remember while you read this example, that no SAS dataset is created.

SAS Program Lines	Comments
libname mydbf dbdbf 'c:\dbms\files'; libname mypara dbpdox 'c:\dbms\files';	The libname statements access the DBMS/Engines dBase and Paradox engines. Engines exist for all packages supported by DBMS/COPY.
proc print data=mydbf.saledbf;run; proc print data=mypara.mail;run;	All SAS Procs and the Datastep DIRECTLY read and write the data supported by our engines. Here we proc print but it could be any proc.
data mypara.dec_only; set mydbf.saledbf; if month(date) = 12; format date date.; run;	Can you really read a dBase file, select records and write an output Paradox database? You bet! Just look at this datastep.
proc print data=mypara.dec_only;run;	Of course you can use that new Paradox database in any proc or datastep.

Click here to move back to DBMS/Copy