1 AT_BANNER([MISSING VALUES])
3 AT_SETUP([MISSING VALUES valid cases])
4 AT_DATA([missing-values.sps], [dnl
5 DATA LIST NOTABLE/str1 1-5 (A) str2 6-8 (A) date1 9-19 (DATE) num1 20-25
8 * Numeric missing values.
9 MISSING VALUES date1 num1 (1).
10 DISPLAY DICTIONARY date1 num1.
11 MISSING VALUES date1 num1 (1, 2).
12 DISPLAY DICTIONARY date1 num1.
13 MISSING VALUES date1 num1 (1, 2, 3).
14 DISPLAY DICTIONARY date1 num1.
15 MISSING VALUES date1 num1 (9999998, 9999984, 3).
16 DISPLAY DICTIONARY date1 num1.
18 * Numeric missing values using the first variable's format.
19 MISSING VALUES num1 date1 ('1').
20 DISPLAY DICTIONARY date1 num1.
21 MISSING VALUES num1 date1 ('1', '2').
22 DISPLAY DICTIONARY date1 num1.
23 MISSING VALUES num1 date1 ('1', '2', '3').
24 DISPLAY DICTIONARY date1 num1.
25 MISSING VALUES date1 num1 ('06-AUG-05').
26 DISPLAY DICTIONARY date1 num1.
27 MISSING VALUES date1 num1 ('06-AUG-05', '01-OCT-78').
28 DISPLAY DICTIONARY date1 num1.
29 MISSING VALUES date1 num1 ('06-AUG-05', '01-OCT-78', '14-FEB-81').
30 DISPLAY DICTIONARY date1 num1.
32 * Ranges of numeric missing values.
33 MISSING VALUES num1 (1 THRU 2).
34 DISPLAY DICTIONARY num1.
35 MISSING VALUES num1 (LO THRU 2).
36 DISPLAY DICTIONARY num1.
37 MISSING VALUES num1 (LOWEST THRU 2).
38 DISPLAY DICTIONARY num1.
39 MISSING VALUES num1 (1 THRU HI).
40 DISPLAY DICTIONARY num1.
41 MISSING VALUES num1 (1 THRU HIGHEST).
42 DISPLAY DICTIONARY num1.
44 * A range of numeric missing values, plus an individual value.
45 MISSING VALUES num1 (1 THRU 2, 3).
46 DISPLAY DICTIONARY num1.
47 MISSING VALUES num1 (LO THRU 2, 3).
48 DISPLAY DICTIONARY num1.
49 MISSING VALUES num1 (LOWEST THRU 2, 3).
50 DISPLAY DICTIONARY num1.
51 MISSING VALUES num1 (1 THRU HI, -1).
52 DISPLAY DICTIONARY num1.
53 MISSING VALUES num1 (1 THRU HIGHEST, -1).
54 DISPLAY DICTIONARY num1.
56 * String missing values.
57 MISSING VALUES str1 str2 longstr ('abc ','def').
58 DISPLAY DICTIONARY str1 str2 longstr.
60 * May mix variable types when clearing missing values.
61 MISSING VALUES ALL ().
64 AT_CHECK([pspp -o pspp.csv missing-values.sps])
65 AT_CHECK([sed -n '/^$/p; /^@<:@^"@:>@*"@<:@^"@:>@*$/N; s/^\(@<:@a-z0-9@:>@*\),".*Missing Values: \(.*\)",@<:@0-9@:>@*$/\1: \2/p; s/^\(@<:@a-z0-9@:>@*\),Format: @<:@A-Z0-9.@:>@*,@<:@0-9@:>@*$/\1: none/p' pspp.csv
76 date1: 9999998; 9999984; 3
77 num1: 9999998; 9999984; 3
91 date1: 13342665600; 12495427200
92 num1: 13342665600; 12495427200
94 date1: 13342665600; 12495427200; 12570336000
95 num1: 13342665600; 12495427200; 12570336000
109 num1: LOWEST THRU 2; 3
111 num1: LOWEST THRU 2; 3
113 num1: 1 THRU HIGHEST; -1
115 num1: 1 THRU HIGHEST; -1
117 str1: ""abc ""; ""def ""
118 str2: ""abc""; ""def""
119 longstr: ""abc ""; ""def ""
129 AT_SETUP([MISSING VALUES invalid cases])
130 AT_DATA([missing-values.sps], [dnl
131 DATA LIST NOTABLE/str1 1-5 (A) str2 6-8 (A) date1 9-19 (DATE) num1 20-25
135 MISSING VALUES str1 str2 longstr ('abcde').
137 * Long string missing value longer than 8 bytes.
138 MISSING VALUES longstr ('abcdefghijk').
141 MISSING VALUES str1 ('a' THRU 'z').
143 * Mixing string and numeric variables.
144 MISSING VALUES str1 num1 ('123').
147 MISSING VALUES num1 (1, 2, 3, 4).
148 MISSING VALUES num1 (1 THRU 2, 3 THRU 4).
149 MISSING VALUES num1 (1, 2 THRU 3, 4).
150 MISSING VALUES str1 ('abc', 'def', 'ghi', 'jkl').
153 MISSING VALUES num1 (2 THRU 1).
155 AT_CHECK([pspp -O format=csv missing-values.sps], [1], [dnl
156 missing-values.sps:5: error: MISSING VALUES: Missing values provided are too long to assign to variable of width 3.
158 missing-values.sps:8: error: MISSING VALUES: Truncating missing value to maximum acceptable length (8 bytes).
160 missing-values.sps:11.26-11.29: error: MISSING VALUES: Syntax error at `THRU': expecting string.
162 missing-values.sps:11: error: MISSING VALUES: THRU is not a variable name.
164 missing-values.sps:14: error: MISSING VALUES: Cannot mix numeric variables (e.g. num1) and string variables (e.g. str1) within a single list.
166 missing-values.sps:17: error: MISSING VALUES: Too many numeric missing values. At most three individual values or one value and one range are allowed.
168 missing-values.sps:18: error: MISSING VALUES: Too many numeric missing values. At most three individual values or one value and one range are allowed.
170 missing-values.sps:19: error: MISSING VALUES: Too many numeric missing values. At most three individual values or one value and one range are allowed.
172 missing-values.sps:20: error: MISSING VALUES: Too many string missing values. At most three individual values are allowed.
174 missing-values.sps:23: warning: MISSING VALUES: The high end of the range (1) is below the low end (2). The range will be treated as if reversed.