1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
|
AT_BANNER([IMPORT and EXPORT])
AT_SETUP([IMPORT and EXPORT])
AT_DATA([import-export.sps], [dnl
DATA LIST LIST NOTABLE /X Y.
BEGIN DATA.
1 2
3 .
5 6
END DATA.
EXPORT /OUTFILE='wiz.por'.
IMPORT /FILE='wiz.por'.
LIST.
])
AT_CHECK([pspp -o pspp.csv import-export.sps])
AT_CHECK([cat pspp.csv], [0], [dnl
Table: Data List
X,Y
1.00,2.00
3.00,. @&t@
5.00,6.00
])
AT_CLEANUP
AT_BANNER([SAVE])
# UNSELECTED=DELETE used to cause a crash if there was actually a
# filter variable.
AT_SETUP([SAVE -- delete unselected])
AT_DATA([data.txt], [dnl
0 '1 9:30:05' 1/2/2003 "25/8/1995 15:30:00" "'a,b,c'",0
, '-0 5:17' 10/31/2010 "9/4/2008 9:29:00" " xxx ",1
1.625,'0 12:00',,,xyzzy,1
])
AT_DATA([save.pspp], [dnl
SET DECIMAL=DOT.
DATA LIST LIST NOTABLE FILE="data.txt"
/number(F8.3) time(DTIME10) date(ADATE10) datetime(DATETIME20) string(A8)
filter(F1.0).
MISSING VALUES number(0) time('0 12:00') string('xyzzy').
FILTER BY filter.
SAVE /OUTFILE="data.sav" /UNSELECTED=DELETE.
])
AT_DATA([get.pspp], [dnl
GET FILE='data.sav'.
LIST.
])
AT_CHECK([pspp -O format=csv save.pspp])
AT_CHECK([pspp -O format=csv get.pspp], [0], [dnl
Table: Data List
number,time,date,datetime,string,filter
. ,-0 05:17,10/31/2010,09-APR-2008 09:29:00,xxx ,1
1.625,0 12:00:00,.,.,xyzzy ,1
])
AT_CLEANUP
|
