Example: Text Import

This example steps through simple Importing of files from outside sources into Statistica , as well as some of the more advanced options to import text files into Statistica.

Import the CreditScoring text file

  1. Select the Home tab.
  2. In the File group, click the Open arrow from the menu. A drop-down menu is displayed.
  3. Select Open Examples. The Open a Statistica Data File dialog box is displayed.
  4. Select CreditScoring.txt, which is located in the Datasets folder.
  5. The Importing file dialog box is displayed.

  6. Accept the default settings to Import as Spreadsheet and Delimited; and click the OK button.
  7. The Import Delimited Text Files dialog box, which contains options for customizing the text file import, is displayed.

Customizing Variables

Since the CreditScoring text file contains text and numeric data, you might want to specify how each variable should be stored in the Statistica Spreadsheet.

Options you can apply to the variables:
  • The variables for import can be assigned names
  • The order of the variables in the resulting spreadsheet can be altered
  • Missing data values can be specified
  • The data type can be set.
  1. To customize the options for a variable, first select the variable of interest by clicking  on the column in the preview pane. For this example, click on the column for the first variable, Credit Rating.
  2. The selected variable is highlighted and the options in the Variable 1 Options group box become active. In our example, Credit Rating, is brought in as a text variable, and has values Good and Bad by default.
  
  3. Select the column for Duration of Credit by clicking on the column in the preview pane.
  4. The Variable 3 Options become active. This numeric column contains values from 3 to 60.
  5. Change the Data type to Byte, as that is the most efficient storage option for this variable.
  6. Scroll through the rest of the columns/variables, which can also be reviewed and modified.
  7. Click the OK button to begin the import. A Statistica Spreadsheet is generated containing the data from the text file.