Folks –. i am having trouble importing data (which is
in scientific notation, and shown below), spread across 5 lines (that is, 5
records per case). Everything is read in correctly until case 81. After this,
it reads incorrectly. Case 81 is skipped, and the next 80 cases are not placed
in the correct column.
If I read the data in only from case 81, again the next 80 cases
are read in correctly (that is cases 81-160), but after that it deviates again.
Any suggestions about why this might be happening?
I am using PASW v18.
Thanks for any clues.
Stephen
Here are the first 2 cases of data, each with 5 lines, and
24 variables per case.
1
0.57549692E+00 -0.63691716E-01
0.61659911E+00 0.50300064E+00 0.94924414E+00 0.11496722E+01
0.79568454E-01 0.87755146E-01
0.65949785E-01 0.79707358E-01 0.10960966E+00 0.13274226E+00
0.13779936E+02 0.10000000E+01
0.20551939E-03 -0.65915416E+03 -0.65226419E+03 0.60000000E+01
0.13303083E+04 0.13483721E+04 0.13293833E+04 0.29188966E+00
0.69779798E-01
2
0.43259220E+00 -0.38682052E-01
0.70202481E+00 0.52009385E+00 0.65910895E+00 0.10877913E+01
0.66288302E-01 0.85338042E-01
0.56900925E-01 0.85348273E-01 0.76107346E-01 0.12560015E+00
0.21692955E+01 0.10000000E+01
0.14079073E+00 -0.61323863E+03 -0.61215399E+03 0.60000000E+01
0.12384773E+04 0.12565411E+04 0.12375522E+04 0.88291014E-01
0.25195249E-01
Here is my syntax:
GET DATA
/TYPE=TXT
/FILE="C:\WINDOWS\n150.dat"
/FIXCASE=5
/ARRANGEMENT=FIXED
/FIRSTCASE=1
/IMPORTCASE=ALL
/VARIABLES=
/1 V1 0-2 F3.0
/2 V2 0-14 F15.12
V3 15-30 F16.12
V4 31-46 F16.12
V5 47-62 F16.12
V6 63-78 F16.12
V7 79-94 F16.12
/3 V8 0-14 F15.12
V9 15-30 F16.12
V10 31-46 F16.12
V11 47-62 F16.12
V12 63-78 F16.12
V13 79-94 F16.12
/4 V14 0-14 F15.12
V15 15-30 F16.12
V16 31-46 F16.12
V17 47-62 F16.12
V18 63-78 F16.12
V19 79-94 F16.12
V20 95-110 F16.12
V21 111-126 F16.12
V22 127-142 F16.12
V23 143-158 F16.12
/5 V24 0-14 F15.12.
Locked
