tests/language/data-io/list.at

   1 AT_BANNER([LIST])
   2
   3 AT_SETUP([LIST plain cases])
   4 AT_DATA([data.txt], [dnl
   5    18    1
   6    19    7
   7    20   26
   8    21   76
   9    22   57
  10    23   58
  11    24   38
  12    25   38
  13    26   30
  14    27   21
  15    28   23
  16 ])
  17 AT_DATA([list.sps], [dnl
  18 DATA LIST FILE='data.txt'/avar 1-5 bvar 6-10.
  19 WEIGHT BY bvar.
  20 LIST.
  21 ])
  22 AT_CHECK([pspp -o pspp.csv list.sps])
  23 AT_CHECK([cat pspp.csv], [0], [dnl
  24 Table: Reading 1 record from `data.txt'.
  25 Variable,Record,Columns,Format
  26 avar,1,1-  5,F5.0
  27 bvar,1,6- 10,F5.0
  28
  29 Table: Data List
  30 avar,bvar
  31 18,1
  32 19,7
  33 20,26
  34 21,76
  35 22,57
  36 23,58
  37 24,38
  38 25,38
  39 26,30
  40 27,21
  41 28,23
  42 ])
  43 AT_CLEANUP
  44
  45 AT_SETUP([LIST numbered cases])
  46 AT_DATA([data.txt], [dnl
  47    18    1
  48    19    7
  49    20   26
  50    21   76
  51    22   57
  52    23   58
  53    24   38
  54    25   38
  55    26   30
  56    27   21
  57    28   23
  58 ])
  59 AT_DATA([list.sps], [dnl
  60 DATA LIST FILE='data.txt'/avar 1-5 bvar 6-10.
  61 WEIGHT BY bvar.
  62 LIST/FORMAT NUMBERED.
  63 ])
  64 AT_CHECK([pspp -o pspp.csv list.sps])
  65 AT_CHECK([cat pspp.csv], [0], [dnl
  66 Table: Reading 1 record from `data.txt'.
  67 Variable,Record,Columns,Format
  68 avar,1,1-  5,F5.0
  69 bvar,1,6- 10,F5.0
  70
  71 Table: Data List
  72 Case Number,avar,bvar
  73 1,18,1
  74 2,19,7
  75 3,20,26
  76 4,21,76
  77 5,22,57
  78 6,23,58
  79 7,24,38
  80 8,25,38
  81 9,26,30
  82 10,27,21
  83 11,28,23
  84 ])
  85 AT_CLEANUP
  86
  87 AT_SETUP([LIST lots of variables])
  88 AT_DATA([data.txt], [dnl
  89 767532466348513789073483106409
  90 888693089424177542378334186760
  91 492611507909187152726427852242
  92 819848892023195875879332001491
  93 452777898709563729845541516650
  94 239961967077732760663525115073
  95 ])
  96 AT_DATA([list.sps], [dnl
  97 DATA LIST FILE='data.txt' NOTABLE/x01 to x30 1-30.
  98 LIST.
  99 ])
 100 AT_CHECK([pspp -o pspp.csv list.sps])
 101 AT_CHECK([cat pspp.csv], [0], [dnl
 102 Table: Data List
 103 x01,x02,x03,x04,x05,x06,x07,x08,x09,x10,x11,x12,x13,x14,x15,x16,x17,x18,x19,x20,x21,x22,x23,x24,x25,x26,x27,x28,x29,x30
 104 7,6,7,5,3,2,4,6,6,3,4,8,5,1,3,7,8,9,0,7,3,4,8,3,1,0,6,4,0,9
 105 8,8,8,6,9,3,0,8,9,4,2,4,1,7,7,5,4,2,3,7,8,3,3,4,1,8,6,7,6,0
 106 4,9,2,6,1,1,5,0,7,9,0,9,1,8,7,1,5,2,7,2,6,4,2,7,8,5,2,2,4,2
 107 8,1,9,8,4,8,8,9,2,0,2,3,1,9,5,8,7,5,8,7,9,3,3,2,0,0,1,4,9,1
 108 4,5,2,7,7,7,8,9,8,7,0,9,5,6,3,7,2,9,8,4,5,5,4,1,5,1,6,6,5,0
 109 2,3,9,9,6,1,9,6,7,0,7,7,7,3,2,7,6,0,6,6,3,5,2,5,1,1,5,0,7,3
 110 ])
 111 AT_CLEANUP
 112
 113 AT_SETUP([LIST selected cases])
 114 AT_DATA([data.txt], [dnl
 115 7675324663
 116 8886930894
 117 4926115079
 118 8198488920
 119 4527778987
 120 2399619670
 121 1667799691
 122 1623914684
 123 3681393233
 124 6418731145
 125 2284534083
 126 6617637452
 127 9865713582
 128 1163234537
 129 9981663637
 130 6821567746
 131 0952774952
 132 1641790193
 133 3763182871
 134 2046820753
 135 7970620091
 136 4841176017
 137 6949973797
 138 1396285996
 139 0700489524
 140 ])
 141 AT_DATA([list.sps], [dnl
 142 DATA LIST FILE='data.txt' NOTABLE/x0 to x9 1-10.
 143 LIST /CASES=FROM 1 TO 25 BY 5.
 144 ])
 145 AT_CHECK([pspp -o pspp.csv list.sps])
 146 AT_CHECK([cat pspp.csv], [0], [dnl
 147 Table: Data List
 148 x0,x1,x2,x3,x4,x5,x6,x7,x8,x9
 149 7,6,7,5,3,2,4,6,6,3
 150 2,3,9,9,6,1,9,6,7,0
 151 2,2,8,4,5,3,4,0,8,3
 152 6,8,2,1,5,6,7,7,4,6
 153 7,9,7,0,6,2,0,0,9,1
 154 ])
 155 AT_CLEANUP
 156
 157 dnl This program tests for a bug which caused a buffer overflow
 158 dnl when the list command attempted to write very long strings.
 159 AT_SETUP([LIST very long string])
 160 AT_DATA([list.sps], [dnl
 161 INPUT PROGRAM.
 162 STRING foo (a2000).
 163 + COMPUTE foo=CONCAT(RPAD('A',1999, 'x'), 'Z').
 164 END CASE.
 165 END FILE.
 166 END INPUT PROGRAM.
 167
 168 EXECUTE.
 169
 170 DISPLAY VARIABLES.
 171
 172 LIST.
 173 ])
 174 AT_CHECK([pspp -o pspp.csv list.sps])
 175 AT_CHECK([cat pspp.csv], [0], [dnl
 176 Variable,Description,,Position
 177 foo,Format: A2000,,1
 178 ,Measure: Nominal,,
 179 ,Display Alignment: Left,,
 180 ,Display Width: 32,,
 181
 182 Table: Data List
 183 foo
 184 AxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxZ
 185 ])
 186 AT_CLEANUP