DBMS/Analyst enhances the power of DBMS/COPY with a powerful multiple database manipulation and programming system. DBMS/Analyst helps clean and scrub data.
You can manipulate more than one input database, split that data into multiple output databases, write reports, read complex text files, do array processing, sort, transpose data, tabulate data, generate summary statistics and calculate regressions. There's a powerful macro scripting language. A built-in macro easily converts multiple files from one format to another.
SAS users will feel right at home. The DBMS/Analyst modules are equivalent to the data step, sort, freq, means, summary, univariate, tabulate, transpose and print procedures.
A free copy of DBMS/Analyst is included with each license of DBMS/COPY Version 7.
Download an evaluation copy of DBMS/Copy
DBMS/COPY is a powerful package for transferring data between different software programs. Its batch processing enables you to automate the transferring process. Your free license to DBMS/Analyst enhances the batch processing capabilities of DBMS/COPY.
The DBMS/Analyst manual is on-line. Printed copies can be purchased from Conceptual Software. The following few pages are meant to give you brief taste of DBMS/Analyst's power. Here are just a few of the things you can do in DBMS/Analyst:
-
Create Multiple Output Databases
-
Read Multiple Databases
-
Merge Multiple Databases
-
Maintain Multiple Databases
-
Read and write complex ASCII character files
-
Read and write supported database formats
-
Produce Simple or Fancy Reports
-
Randomly Access Individual Records In PRODAS Databases
-
Perform Mathematical Calculations
-
Perform Date Arithmetic
-
Manipulate Character Strings
-
Control Program Flow
-
Manipulate Arrays
-
Any operation the user defines using the language
-
Execution time debugger
-
Macro Language
-
HTML output
-
Equivalents to the SAS data step, sort, freq, means, summary, univariate, tabulate, transpose, rsq, reg, stepreg, format and print procedures. There is also an equivalent macro language.
|
DBMS/Analyst contains the following modules: |
|
|
Crosstab |
cross tables with one or more variables. It also can process questionnaires. |
|
Program |
the data manipulation module -- equivalent to the SAS data step. |
|
Regress |
calculates all possible regressions, stepwise regression, linear regression, correlation, and collinearity. |
|
Report |
printout generator. |
|
Sort |
sorts databases in a specified variable order. |
|
Tabulate |
sophisticated cross table generator. |
|
Transpose |
transposes the records and the variables. The records (rows) become variables and the variables (columns) become rows. |
|
Unistat |
generates 30 different univariate statistics. These statistics range from basic (mean, minimum), to sophisticated (kurtosis, t statistics). |
|
Value |
builds and maintains user defined formats |
Unlike SAS, DBMS/Analyst does not limit the programmability to just one module like the DBMS/Analyst program module or the SAS data step. DBMS/Analyst enables you to use the sophisticated multiple database programming, control statements, array processing and all other commands in all modules. For example, DBMS/Analyst’s crosstab module can build cross tables by merging databases and computing new variables on the fly. Using the by statement within the report module enables you to generate a list of first records for each by group. Why generate temporary databases when the modules can do the complex programming directly?
