Select Variables (for ETL ID-based Analyses)

Click the Variables button on the STATISTICA Extract, Transform, and Load (ETL): ID-based dialog box - Quick or Advanced tab, to display the Select variables dialog box. This dialog box comprises three frames that contain a list of all variables in the active spreadsheet.

    1. Select one to five ClassID variable(s) in the first frame. ClassID defines the batch, part, or other discrete unit by which the data sources will be joined. The variables can be text or number.

    2. Select output Variables to be aggregated in the second frame. Continuous variables are aggregated by Mean, Median, Std. Dev., Minimum, Maximum, or Sum. Categorical variables are aggregated by Mode.

    3. Optionally select Time variables in the third frame. If one variable is selected, it must be of one of three data types: Date, Time, or Date Time. If two variables are selected, they must be Date and Time, respectively.

Select variables. Alternatively, you can use the Select variables box to enter variable numbers. A connected list of variables should be separated by a hyphen (e.g. 1-10), while a list of disconnected variables should be separated by spaces (e.g. 5 7 12 20).

Note. If you type the variable numbers in the edit box of the variable selection dialog box, it preserves the order. If you select from the list, it does not preserve the order.

Select All. Click the Select All button to select all variables in the active spreadsheet.

Spread. Click the Spread button to display more information (for example, the long description) of each variable.

Shrink. Click the Shrink button (which is the alternate function of the Spread button) to display concise information (the variable number and short name) for each variable.

Zoom. Click the Zoom button to display a dialog containing detailed information about the selected variable.

Bundles. Click this button to display the Variable Bundles Manager. Using the options in this dialog box, you can create, edit, delete, and rename variable bundles as well as to generate a spreadsheet containing bundle information. Bundles can be used to organize large sets of variables and to facilitate the repeated selection of the same set of variables. By creating bundles, you make it possible to quickly and easily locate a subset of data in a large data file.