User Guide

699
Index
parameter queries, 31, 34
prompt for value, 34
random sampl
ing, 31
reading, 23, 23, 24, 24, 26
relationship properties, 29
saving queries, 38
selecting a data source, 24
selecting data fields, 26
specifying cr
iteria, 31
SQL syntax, 38
table joins, 28, 29
verifying results, 38
Where clause, 31
data dictionary
applying from a
nother file, 107
Data Editor, 75, 77, 86, 86, 88, 89, 89, 90, 90, 91,
91, 92, 93, 93, 94, 94, 94, 95, 95, 96, 599
alignment, 86
changing data type, 94
column width, 86
data value rest
rictions, 90
Data view, 75
defining variables, 77
display options, 95
editing data, 90, 91, 91
entering data, 88
entering non-nu
meric data, 89
entering numeric data, 89
filtered cases, 95
finding cases, 94, 94
inserting new cases, 92
inserting new variables, 93
moving variable
s, 93
multiple views/panes, 95
printing, 96
sending data to other applications, 599
data entry, 88
data files , 19, 20, 40, 51, 51, 51, 55, 55, 57, 61,
68, 69, 70, 197
adding comments, 574
dictionary information, 51, 51
file information, 51, 51
flipping, 176
improving performance for large files, 61
opening, 19, 20
protecting, 58
remote servers, 68, 69, 70
restructuring, 197
saving, 51, 55, 55
saving output as SPSS-format data files, 657
saving subsets of variables, 57
text, 40
transposing, 176
Data List, 59
versus Get Dat
a command, 59
data transformations, 594
computing variables, 129
conditional transformations, 131
delaying execution, 594
functions, 132
ranking cases,
143
recoding values, 137, 138, 140, 141, 147
string variables, 132
time series, 166, 169
data types , 81, 81, 82, 94, 595
changing, 94
custom currenc
y, 81, 595
defining, 81
display formats, 82
input formats, 82
Data view, 75
date formats, 81, 82, 594
two-digit years
, 594
date variables
add or subtract from date/time variables, 150
create date/time variable from set of variables,
150
create date/time variable from string, 150
defining for tim
e series data, 167
extract part of date/time variable, 150
dBASE files , 19, 22, 55, 55
opening, 19, 22
saving, 55, 55
debugging scripts, 650, 652
break points, 650
debugging pane, 652
stepping through scripts, 650
Define Multiple Response Sets, 512
categories, 512
dichotomies, 512
set labels, 512
set names, 512