	[x] Posted via EE Mobile
	Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

Question

	[x] Attachment Details

SPSS - Can only import the 1st line of data?

Asked by PTRUSCOTT in SPSS, Probability & Statistics

Dear Experts,
I am using SPSS to import a data file of about 190 thousand records.

In the Syntax editor I select Run --> All

I get no error message but in the data view only the first line of data is imported.

I specify a 189079 records are to be imported (see attachment).

I believe that I am seeing a very brief "transformation pending" message that goes away.

What am I doing wrong?

View the Solution FREE for 30 Days

         
           
             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:

           
           
             DATA LIST FILE = "\POM\DATA\SPSS.OUT" RECORDS=189079
  /    SEQNO    1 -  6
    CASENO    7 -  16
    PERSNO   17 -  26
    BENUNIT   27 -  36
    TOREC   37 -  46
    RNTVL   47 -  56
    RNTVX   57 -  66
    B3102   67 -  76
    B3132   77 -  86
    TOTEX   87 -  96
    LC05_REL   97 -  99
    FAMRE  100 - 102.
VARIABLE LABELS
    CASENO  'HOUSEHOLD_NO'
    PERSNO  'PERSON_NO'
    BENUNIT  'BENUNIT'
    TOREC  'TOTAL_FAMILY_RECEIPTS'
    RNTVL  'IMPUTED_HOUSE_RENTAL_VAL'
    RNTVX  'HOUSING_BENEFITS_IMPUTED_RENTAL_VALUE'
    B3102  'RECORDED_INCOME_TAX'
    B3132  'OTHER_DIRECT_TAXES'
    TOTEX  'TOTAL_FAMILY_EXPENDITURE'
    LC05_REL  'RELATION_TO_HEAD_OF_HOUSE'
    FAMRE  'POSITION_IN_FAMILY_UNIT'
.
VALUE LABELS
LC05_REL
   1   'Head'
   2   'Wife_Spouse'
   3   'Son_daughter'
   4   'Brothers_sisters'
   5   'Son_daughter_law'
   6   'Grandchildren'
   7   'Father_Mother'
   8   'Other_Relative'
   9   'Boarder'
   10   'Domestic_Helper'
   11   'Non_Relative' /
FAMRE
   1   'Head'
   2   'Spouse'
   3   'Dependent Child' /
.
EXECUTE
.

           
         