Stand-alone mode


Main advantages of using UNISTAT in stand-alone mode are:

  • it does not have the data size restrictions of Excel,
  • it provides efficient data handling procedures like aggregate, recode, stack, unstack,
  • it has an easy-to-use formula editor,
  • and it has its own macro record/playback and logging facilities.

Spreadsheet: UNISTAT for Windows comes complete with a fully-featured Excel-like spreadsheet (Data Processor) custom-designed for statistical data handling.

UNISTAT Spreadsheet

Formula Editor: Columns can be defined as functions of other columns using multi-function / multi-nested formulae, conditional functions and Boolean operators. The Formula Editor dialog helps constructing complex transformations with ease.

UNISTAT Formula Editor

Data Types: Numeric, short and long strings, date and time data can be entered, edited and transformed with full support for missing values.

Data Import / Export: In addition to copy / paste between UNISTAT and other Windows applications, files can be loaded, merged or saved in Excel (V3/4, 95, 98, 2000, XP), CSV, Lotus, DIF, Sylk, fixed and free format (by column and by row) ASCII formats. It is possible to select any characters as field and text delimiters including tab, comma, semicolon and spaces.

UNISTAT Import/Export

ODBC and SQL: It is possible to open any database for which drivers are installed in the Windows system. It is also possible to execute SQL statements to extract subsets from large databases.

UNISTAT ODBC and SQL

Security: It is possible to password-protect selected UNISTAT internal files.

UNISTAT Security

Intermediary Output: In any UNISTAT procedure where a table is part of the output, there is the option to send it to the spreadsheet for further analysis.