STATISTICA: Data Import & Export
How can I access data from Excel and other non-STATISTICA data files?
There are a number of ways you can do this.
- Clipboard. The quickest way to access data files from other Windows applications (e.g., spreadsheets) is to copy the data to the Clipboard and then paste it into a STATISTICA Spreadsheet.
- File import. Data files from a wide variety of Windows and non-Windows applications can be accessed and translated into the STATISTICA format using file import (accessible by selecting Open from the File menu). You can even access formatted and free format text (ASCII) files.
- STATISTICA Query. In addition to file import described above, STATISTICA provides access to virtually all databases via STATISTICA‘s flexible STATISTICA Query, accessible from both the File – Get External Data and the Data – Get External Data submenus.
- OLE links. STATISTICA supports the Object Linking and Embedding (OLE) conventions, allowing you to link values or text in STATISTICA documents (e.g., spreadsheets, reports) to documents in other (Windows) applications. To set up an OLE link, select Paste Special from the Edit menu and choose the Paste Link option button.
- DDE links. STATISTICA supports the Dynamic Data Exchange (DDE) conventions; thus, you can dynamically link a range of data in a spreadsheet to a subset of data in other (Windows) applications. To set up a DDE link, select DDE Links from the Edit menu.
- Accessing data files larger than the local storage. Note that Enterprise versions of STATISTICA offer options to query and access large remote data files in-place (i.e., without having to import the data and create a local copy).
How do I import an Excel spreadsheet as a STATISTICA Spreadsheet?
Select Open from the File menu to access the Open dialog.
Select an Excel file and click the OK button. In the Opening file dialog, click the Import selected sheet to a Spreadsheet button.
In the Select Sheet to Import dialog, select the Excel sheet you want and click the OK button.
The Open Excel File dialog is displayed.
This dialog provides different options for importing an Excel file.
- Get variable names from first row. Select this check box to import the first row of the worksheet as the variable names rather than the first column. This check box is selected by default.
- Get case names from first column. Select this check box to import the first column of the worksheet as the case names rather than the first row.
- Import cell formatting. Select this check box to specify that the formatting will be imported to the new spreadsheet.
- Range. Under Range, select the specific rows and columns you want to import.
- Variables. Click the Variables button to display the Review/Edit Import Column Types dialog. You can specify columns as Text or Numeric; note that the default type is Numeric.
Click the OK button to open the Excel file as a STATISTICA Spreadsheet.
Can STATISTICA access data from enterprise application databases?
Yes. STATISTICA Query (including options to combine fields from multiple tables) is provided via both the File – Get External Data and the BI menus. As long as the database format supports a 32-bit ODBC driver or an OLE DB provider, accessing such data should present no problem.
Can STATISTICA process files that are larger than the local hard drive?
Yes, STATISTICA Enterprise offers options to query and access large remote data files in-place (i.e., without having to import the data and create a local copy).
Does STATISTICA support ODBC?
Yes, via STATISTICA Query, an external data querying facility available from the Data – Get External Data submenu and the File – Get External Data submenu. The STATISTICA Query interface includes options to combine fields from multiple tables and provides flexible access to a wide variety of database management files, including the major enterprise database formats such as Microsoft SQL Servers and Oracle. Specific records (rows of tables) can be selected by entering SQL statements. STATISTICA Query automatically builds the SQL statement for you as you select the components of the query via a simple graphical interface. Hence, no extensive knowledge of SQL is needed to create queries of data.
I need to combine data from a relational database and a data historian. Is there an easy way to do this?
STATISTICA Extract, Transform, and Load (ETL) provides the capability to process data from standard databases (Microsoft SQL® , Oracle® ) as well as specialized process databases (e.g., OSI Pi®), with data filtering, alignment, and aggregation.
Disparate sources can be aligned by batch number and time interval and/or by one or more ID fields. Merging many-to-one data sets is a common scenario.
Can I import data from SAS native (binary) data files?
Yes. SAS binary files from SAS versions 6.08 through the current version can be imported by STATISTICA.
How do I export data from STATISTICA to Excel and other non-STATISTICA data files?
STATISTICA can export data files to a wide variety of Windows and non-Windows applications via the Save As command accessible from the File menu. You can even save spreadsheets as formatted and free format text (ASCII) files. These facilities allow you to specify the exact way in which the translation is to be performed (e.g., decide whether to export variable names, text labels, and case names). Also, STATISTICA Spreadsheets are OLE servers and clients, so other applications can link to them.