1 AT_BANNER([FREQUENCIES procedure])
3 AT_SETUP([FREQUENCIES string variable])
4 AT_DATA([frequencies.sps],
6 name (A8) value * quantity .
21 FREQUENCIES /VAR = name/ORDER=ANALYSIS.
23 AT_CHECK([pspp -O format=csv frequencies.sps], [0], [dnl
25 Value Label,Value,Frequency,Percent,Valid Percent,Cum Percent
26 ,bar ,2,20.00,20.00,20.00
27 ,baz ,4,40.00,40.00,60.00
28 ,foo ,2,20.00,20.00,80.00
29 ,quux ,2,20.00,20.00,100.00
30 Total,,10,100.0,100.0,
34 # Tests for a bug where pspp would crash if two FREQUENCIES commands
35 # existed in a input file.
36 AT_SETUP([FREQUENCIES two runs crash])
37 AT_DATA([frequencies.sps],
38 [data list free /v1 v2.
46 frequencies v1 v2/statistics=none/ORDER=VARIABLE.
47 frequencies v1 v2/statistics=none.
49 AT_CHECK([pspp -O format=csv frequencies.sps], [0],
51 Value Label,Value,Frequency,Percent,Valid Percent,Cum Percent
52 ,.00,1,25.00,25.00,25.00
53 ,2.00,1,25.00,25.00,50.00
54 ,3.00,1,25.00,25.00,75.00
55 ,4.00,1,25.00,25.00,100.00
59 Value Label,Value,Frequency,Percent,Valid Percent,Cum Percent
60 ,1.00,1,25.00,25.00,25.00
61 ,3.00,1,25.00,25.00,50.00
62 ,4.00,1,25.00,25.00,75.00
63 ,5.00,1,25.00,25.00,100.00
67 Value Label,Value,Frequency,Percent,Valid Percent,Cum Percent
68 ,.00,1,25.00,25.00,25.00
69 ,2.00,1,25.00,25.00,50.00
70 ,3.00,1,25.00,25.00,75.00
71 ,4.00,1,25.00,25.00,100.00
75 Value Label,Value,Frequency,Percent,Valid Percent,Cum Percent
76 ,1.00,1,25.00,25.00,25.00
77 ,3.00,1,25.00,25.00,50.00
78 ,4.00,1,25.00,25.00,75.00
79 ,5.00,1,25.00,25.00,100.00
84 # Test that the LIMIT specification works.
85 AT_SETUP([FREQUENCIES with LIMIT])
86 AT_DATA([frequencies.sps],
87 [data list free /v1 v2.
95 frequencies v1 v2/statistics=none/FORMAT=LIMIT(3).
97 AT_CHECK([pspp -O format=csv frequencies.sps], [0], [dnl
99 Value Label,Value,Frequency,Percent,Valid Percent,Cum Percent
100 ,1.00,1,25.00,25.00,25.00
101 ,3.00,1,25.00,25.00,50.00
102 ,5.00,2,50.00,50.00,100.00
103 Total,,4,100.0,100.0,
107 # Tests for a bug where PSPP would crash when a FREQUENCIES command
108 # was used with the HTML output driver.
109 AT_SETUP([FREQUENCIES HTML output crash])
110 AT_DATA([frequencies.sps],
111 [data list free /v1 v2.
121 frequencies v1/statistics=none.
123 AT_CHECK([pspp -o - -O format=csv -o pspp.html frequencies.sps], [0],
132 Value Label,Value,Frequency,Percent,Valid Percent,Cum Percent
133 ,.00,1,25.00,25.00,25.00
134 ,2.00,1,25.00,25.00,50.00
135 ,3.00,1,25.00,25.00,75.00
136 ,4.00,1,25.00,25.00,100.00
137 Total,,4,100.0,100.0,
139 AT_CHECK([test -s pspp.html])
142 # Tests for a bug which crashed PSPP when a piechart with too many
143 # segments was requested.
144 AT_SETUP([FREQUENCIES pie chart crash])
145 AT_DATA([frequencies.sps],
146 [data list list /x * w *.
163 frequencies /x /format=notable /statistics=none
166 # Cannot use the CSV driver for this because it does not output charts
168 AT_CHECK([pspp frequencies.sps], [0], [dnl
169 Reading free-form data from INLINE.
179 dnl Check that histogram subcommand runs wihout crashing
180 AT_SETUP([FREQUENCIES histogram crash])
181 AT_DATA([frequencies.sps],
182 [data list notable list /x * w *.
202 /histogram=minimum(0) maximum(50) percent(5) normal.
204 # Cannot use the CSV driver for this because it does not output charts
206 AT_CHECK([pspp -O format=pdf frequencies.sps], [0], [ignore])
209 # Tests for a bug which crashed PSPP when the median and a histogram
210 # were both requested.
211 AT_SETUP([FREQUENCIES median with histogram crash])
212 AT_DATA([frequencies.sps], [dnl
213 data list list notable /x.
218 frequencies /x /histogram /STATISTICS=median.
220 AT_CHECK([pspp -O format=csv frequencies.sps], [0], [ignore])
221 dnl Ignore output - No crash test.
224 # Tests for a bug which caused FREQUENCIES following TEMPORARY to
225 # crash (bug #11492).
226 AT_SETUP([FREQUENCIES crash after TEMPORARY])
227 AT_DATA([frequencies.sps],
228 [DATA LIST LIST /SEX (A1) X *.
247 AT_CHECK([pspp -O format=csv frequencies.sps], [0],
248 [Table: Reading free-form data from INLINE.
254 Value Label,Value,Frequency,Percent,Valid Percent,Cum Percent
255 ,12.00,1,25.00,25.00,25.00
256 ,13.00,1,25.00,25.00,50.00
257 ,21.00,1,25.00,25.00,75.00
258 ,31.00,1,25.00,25.00,100.00
259 Total,,4,100.0,100.0,
271 m4_define([FREQUENCIES_NTILES_OUTPUT],
287 AT_SETUP([FREQUENCIES basic percentiles])
288 AT_DATA([frequencies.sps],
289 [DATA LIST LIST notable /x * .
301 /PERCENTILES = 0 25 33.333 50 66.666 75 100.
303 AT_CHECK([pspp -O format=csv frequencies.sps], [0],
304 [FREQUENCIES_NTILES_OUTPUT])
307 AT_SETUP([FREQUENCIES basic n-tiles])
308 AT_DATA([frequencies.sps],
309 [DATA LIST LIST notable /x * .
324 AT_CHECK([pspp -O format=csv frequencies.sps], [0],
325 [FREQUENCIES_NTILES_OUTPUT])
328 AT_SETUP([FREQUENCIES compatibility percentiles])
329 AT_DATA([frequencies.sps],
330 [DATA LIST LIST notable /X * .
341 /ALGORITHM=COMPATIBLE
342 /PERCENTILES = 0 25 50 75 100.
344 AT_CHECK([pspp -O format=csv frequencies.sps], [0],
346 Value Label,Value,Frequency,Percent,Valid Percent,Cum Percent
347 ,1.00,1,20.00,20.00,20.00
348 ,2.00,1,20.00,20.00,40.00
349 ,3.00,1,20.00,20.00,60.00
350 ,4.00,1,20.00,20.00,80.00
351 ,5.00,1,20.00,20.00,100.00
352 Total,,5,100.0,100.0,
369 AT_SETUP([FREQUENCIES enhanced percentiles])
370 AT_DATA([frequencies.sps],
371 [DATA LIST LIST notable /X * .
382 /PERCENTILES = 0 25 50 75 100.
384 AT_CHECK([pspp -O format=csv frequencies.sps], [0],
386 Value Label,Value,Frequency,Percent,Valid Percent,Cum Percent
387 ,1.00,1,20.00,20.00,20.00
388 ,2.00,1,20.00,20.00,40.00
389 ,3.00,1,20.00,20.00,60.00
390 ,4.00,1,20.00,20.00,80.00
391 ,5.00,1,20.00,20.00,100.00
392 Total,,5,100.0,100.0,
409 AT_SETUP([FREQUENCIES enhanced percentiles, weighted])
410 AT_DATA([frequencies.sps],
411 [DATA LIST LIST notable /X * F *.
426 /PERCENTILES = 0 25 50 75 100.
428 AT_CHECK([pspp -O format=csv frequencies.sps], [0],
430 Value Label,Value,Frequency,Percent,Valid Percent,Cum Percent
431 ,1.00,2.00,20.00,20.00,20.00
432 ,2.00,2.00,20.00,20.00,40.00
433 ,3.00,2.00,20.00,20.00,60.00
434 ,4.00,2.00,20.00,20.00,80.00
435 ,5.00,2.00,20.00,20.00,100.00
436 Total,,10.00,100.0,100.0,
453 AT_SETUP([FREQUENCIES enhanced percentiles, weighted (2)])
454 AT_DATA([frequencies.sps],
455 [DATA LIST LIST notable /X * F *.
468 /PERCENTILES = 0 25 50 75 100.
470 AT_CHECK([pspp -O format=csv frequencies.sps], [0],
472 Value Label,Value,Frequency,Percent,Valid Percent,Cum Percent
473 ,1.00,1.00,16.67,16.67,16.67
474 ,3.00,2.00,33.33,33.33,50.00
475 ,4.00,1.00,16.67,16.67,66.67
476 ,5.00,2.00,33.33,33.33,100.00
477 Total,,6.00,100.0,100.0,
494 dnl Data for this test case from Fabio Bordignon <bordignon@demos.it>.
495 AT_SETUP([FREQUENCIES enhanced percentiles, weighted (3)])
496 AT_DATA([frequencies.sps],
497 [DATA LIST LIST notable /X * F *.
509 /PERCENTILES = 0 25 50 75 100.
511 AT_CHECK([pspp -O format=csv frequencies.sps], [0], [dnl
513 Value Label,Value,Frequency,Percent,Valid Percent,Cum Percent
514 ,1.00,7.00,17.50,17.50,17.50
515 ,2.00,16.00,40.00,40.00,57.50
516 ,3.00,12.00,30.00,30.00,87.50
517 ,4.00,5.00,12.50,12.50,100.00
518 Total,,40.00,100.0,100.0,
535 AT_SETUP([FREQUENCIES enhanced percentiles, weighted, missing values])
536 AT_DATA([frequencies.sps],
537 [DATA LIST LIST notable /X * F *.
547 MISSING VALUE x (99.0) .
552 /PERCENTILES = 0 25 50 75 100.
555 AT_CHECK([pspp -O format=csv frequencies.sps], [0],
557 Value Label,Value,Frequency,Percent,Valid Percent,Cum Percent
558 ,1.00,1.00,10.00,16.67,16.67
559 ,3.00,2.00,20.00,33.33,50.00
560 ,4.00,1.00,10.00,16.67,66.67
561 ,5.00,2.00,20.00,33.33,100.00
562 ,99.00,4.00,40.00,Missing,
563 Total,,10.00,100.0,100.0,
580 AT_SETUP([FREQUENCIES dichotomous histogram])
581 AT_DATA([frequencies.sps], [dnl
582 data list notable list /d4 *.
610 AT_CHECK([pspp frequencies.sps], [0], [ignore])
614 AT_SETUP([FREQUENCIES median])
615 AT_DATA([median.sps], [dnl
616 data list notable list /x *.
629 AT_CHECK([pspp median.sps -O format=csv], [0], [dnl
631 Value Label,Value,Frequency,Percent,Valid Percent,Cum Percent
632 ,1.00,1,33.33,33.33,33.33
633 ,2.00,1,33.33,33.33,66.67
634 ,3000000.00,1,33.33,33.33,100.00
635 Total,,3,100.0,100.0,
640 Percentiles,50 (Median),2.00
646 AT_SETUP([FREQUENCIES default statistics])
647 AT_DATA([median.sps], [dnl
648 data list notable list /x *.
662 /STATISTICS = DEFAULT
666 AT_CHECK([pspp median.sps -O format=csv], [0], [dnl
668 Value Label,Value,Frequency,Percent,Valid Percent,Cum Percent
669 ,10.00,1,33.33,33.33,33.33
670 ,20.00,1,33.33,33.33,66.67
671 ,3000000.00,1,33.33,33.33,100.00
672 Total,,3,100.0,100.0,
683 Value Label,Value,Frequency,Percent,Valid Percent,Cum Percent
684 ,10.00,1,33.33,33.33,33.33
685 ,20.00,1,33.33,33.33,66.67
686 ,3000000.00,1,33.33,33.33,100.00
687 Total,,3,100.0,100.0,
701 AT_SETUP([FREQUENCIES no valid data])
702 AT_DATA([empty.sps], [dnl
703 data list notable list /x *.
716 AT_CHECK([pspp empty.sps -O format=csv], [0], [dnl
718 Value Label,Value,Frequency,Percent,Valid Percent,Cum Percent
719 ,. ,3,100.00,Missing,
720 Total,,3,100.0,100.0,