User Guide

3 Data Files 19
Opening a Da
taFile .......................................... 19
To Open Data
Files ........................................... 19
Data File Ty
pes.............................................. 20
Opening Fil
eOptions.......................................... 21
Reading Exc
elFiles........................................... 21
How the Data
Editor Re ads Older Excel Files and Other Spreadsh eets . . . . 22
How the Data
EditorReadsdBASEFiles........................... 22
Reading Data
baseFiles ....................................... 23
Selecting a D
ataSource....................................... 24
Database Log
in.............................................. 25
Selecting Da
taFields......................................... 26
Creating a Pa
rameterQuery.................................... 34
Aggregating
Data............................................ 35
Defining Var
iables ........................................... 36
Sorting Case
s............................................... 37
Results ................................................... 38
TextWizard ................................................ 4
0
File Informat
ion.............................................. 51
Saving Data Fi
les............................................ 51
To Save Modifi
edDataFiles.................................... 51
Saving Data Fi
lesinExcelFormat................................ 52
Saving Data Fi
lesinSASFormat................................. 53
Saving Data Fi
lesinOtherFormats............................... 55
Saving Data: D
ataFileTypes.................................... 55
Saving Subset
sofVariables.................................... 57
Saving File Op
tions........................................... 58
Protecting Or
iginalData....................................... 58
Virtual Active
File............................................ 59
viii