simple data list input creates error

classic Classic list List threaded Threaded
8 messages Options
Reply | Threaded
Open this post in threaded view
|

simple data list input creates error

msherman
Dear List: I am using a syntax file to input data (See below). I get an
error message that an invalid numeric field has been found.  The problem
starts with the letter b and then e. I have used this syntax before and
never had a problem.  (Using SPSS14). What am I missing. Thanks,  martin
sherman

comment problem #1 using data list in syntax to create Data file.
data list  / dosageofstjohnswort 1 alertness 2.
begin data
16
17
14
14
12
13
13
11
24
25
26
23
26
23
24
23
38
39
36
36
34
35
34
33
49
45
46
46
46
47
46
44
54
54
56
56
56
56
57
59
end data.
freq var=all.

Martin F. Sherman, Ph.D.
Professor of Psychology
Loyola College
Director of Masters Education: Thesis Track
Psychology Department
222 B Beatty Hall
4501 North Charles Street
Baltimore, MD 21210
Martin F. Sherman, Ph.D.
Professor of Psychology
Director of Masters Education: Thesis Track
Loyola College
Psychology Department
222 B Beatty Hall
4501 North Charles Street
Baltimore, MD 21210

410 617-2417 (office)
410 617-5341 (fax)

[hidden email]
Reply | Threaded
Open this post in threaded view
|

Re: simple data list input creates error

Melissa Ives
Try replacing the word 'comment' with an asterisk (*).

Melissa

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Martin Sherman
Sent: Tuesday, November 28, 2006 9:36 AM
To: [hidden email]
Subject: [SPSSX-L] simple data list input creates error

Dear List: I am using a syntax file to input data (See below). I get an
error message that an invalid numeric field has been found.  The problem
starts with the letter b and then e. I have used this syntax before and
never had a problem.  (Using SPSS14). What am I missing. Thanks,  martin
sherman

comment problem #1 using data list in syntax to create Data file.
data list  / dosageofstjohnswort 1 alertness 2.
begin data
16
17
14
14
12
13
13
11
24
25
26
23
26
23
24
23
38
39
36
36
34
35
34
33
49
45
46
46
46
47
46
44
54
54
56
56
56
56
57
59
end data.
freq var=all.

Martin F. Sherman, Ph.D.
Professor of Psychology
Loyola College
Director of Masters Education: Thesis Track Psychology Department
222 B Beatty Hall
4501 North Charles Street
Baltimore, MD 21210
Martin F. Sherman, Ph.D.
Professor of Psychology
Director of Masters Education: Thesis Track Loyola College Psychology
Department
222 B Beatty Hall
4501 North Charles Street
Baltimore, MD 21210

410 617-2417 (office)
410 617-5341 (fax)

[hidden email]



PRIVILEGED AND CONFIDENTIAL INFORMATION
This transmittal and any attachments may contain PRIVILEGED AND
CONFIDENTIAL information and is intended only for the use of the
addressee. If you are not the designated recipient, or an employee
or agent authorized to deliver such transmittals to the designated
recipient, you are hereby notified that any dissemination,
copying or publication of this transmittal is strictly prohibited. If
you have received this transmittal in error, please notify us
immediately by replying to the sender and delete this copy from your
system. You may also call us at (309) 827-6026 for assistance.
Reply | Threaded
Open this post in threaded view
|

Re: simple data list input creates error

Edward Boadi
In reply to this post by msherman
Hi Martin,
Modify the second line of your syntax to read :

data list  / dosageofstjohnswort (a1) alertness (a1).


Thanks.
Edward.


-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]]On Behalf Of
Martin Sherman
Sent: Tuesday, November 28, 2006 10:36 AM
To: [hidden email]
Subject: simple data list input creates error


Dear List: I am using a syntax file to input data (See below). I get an
error message that an invalid numeric field has been found.  The problem
starts with the letter b and then e. I have used this syntax before and
never had a problem.  (Using SPSS14). What am I missing. Thanks,  martin
sherman

comment problem #1 using data list in syntax to create Data file.
data list  / dosageofstjohnswort 1 alertness 2.
begin data
16
17
14
14
12
13
13
11
24
25
26
23
26
23
24
23
38
39
36
36
34
35
34
33
49
45
46
46
46
47
46
44
54
54
56
56
56
56
57
59
end data.
freq var=all.

Martin F. Sherman, Ph.D.
Professor of Psychology
Loyola College
Director of Masters Education: Thesis Track
Psychology Department
222 B Beatty Hall
4501 North Charles Street
Baltimore, MD 21210
Martin F. Sherman, Ph.D.
Professor of Psychology
Director of Masters Education: Thesis Track
Loyola College
Psychology Department
222 B Beatty Hall
4501 North Charles Street
Baltimore, MD 21210

410 617-2417 (office)
410 617-5341 (fax)

[hidden email]
Reply | Threaded
Open this post in threaded view
|

Re: simple data list input creates error

Beadle, ViAnn
In reply to this post by msherman
I copied this syntax out of your mail message and ran it with no errors.
Check for something lurking to the right or unprintable characters.

How did you create this file in the 1st place?

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Martin Sherman
Sent: Tuesday, November 28, 2006 9:36 AM
To: [hidden email]
Subject: simple data list input creates error

Dear List: I am using a syntax file to input data (See below). I get an
error message that an invalid numeric field has been found.  The problem
starts with the letter b and then e. I have used this syntax before and
never had a problem.  (Using SPSS14). What am I missing. Thanks,  martin
sherman

comment problem #1 using data list in syntax to create Data file.
data list  / dosageofstjohnswort 1 alertness 2.
begin data
16
17
14
14
12
13
13
11
24
25
26
23
26
23
24
23
38
39
36
36
34
35
34
33
49
45
46
46
46
47
46
44
54
54
56
56
56
56
57
59
end data.
freq var=all.

Martin F. Sherman, Ph.D.
Professor of Psychology
Loyola College
Director of Masters Education: Thesis Track
Psychology Department
222 B Beatty Hall
4501 North Charles Street
Baltimore, MD 21210
Martin F. Sherman, Ph.D.
Professor of Psychology
Director of Masters Education: Thesis Track
Loyola College
Psychology Department
222 B Beatty Hall
4501 North Charles Street
Baltimore, MD 21210

410 617-2417 (office)
410 617-5341 (fax)

[hidden email]
Reply | Threaded
Open this post in threaded view
|

Re: simple data list input creates error

Edward Boadi
In reply to this post by msherman
Hi Martin,
Your syntax works fine at my end.
It however generates the said error message when I added non numeric characters to
the data set.My proposed solution works (At my end) with a mixture of numeric and non numeric data sets.

Below is the syntax and output.

data list  / dosageofstjohnswort(a1)  alertness (a1) .
begin data
16
17
14
14
12
13
13
11
24
25
26
23
26
23
24
23
38
39
36
36
34
35
34
33
49
45
46
46
46
47
46
44
54
54
56
56
56
56
57
59
be
end data.
freq var=all

        *******Output ************

Data List will read 1 records from the command file

Variable                Rec   Start     End  Format

dosageofstjohnswort     1       1       1  A1

alertness               1       2       2  A1


      dosageofstjohnswort
     Frequency  Percent Valid Percent   Cumulative Percent
1       8       19.5    19.5            19.5
2       8       19.5    19.5            39.0
3       8       19.5    19.5            58.5
4       8       19.5    19.5            78.0
5       8       19.5    19.5            97.6
b       1       2.4     2.4             100.0
Total   41      100.0   100.0


               alertness
   Frequency    Percent Valid Percent   Cumulative Percent
1       1       2.4     2.4             2.4
2       1       2.4     2.4             4.9
3       6       14.6    14.6            19.5
4       9       22.0    22.0            41.5
5       3       7.3     7.3             48.8
6       13      31.7    31.7            80.5
7       3       7.3     7.3             87.8
8       1       2.4     2.4             90.2
9       3       7.3     7.3             97.6
e       1       2.4     2.4             100.0
Total   41      100.0   100.0

Thanks.
Edward.

-----Original Message-----
From: Martin Sherman [mailto:[hidden email]]
Sent: Tuesday, November 28, 2006 11:05 AM
To: Edward Boadi
Subject: RE: simple data list input creates error


Edward: Thanks, but I tried that and it does not change anything. This
syntax has always worked in the past.  martin

>>> "Edward Boadi" <[hidden email]> 11/28/2006 10:53 AM >>>
Hi Martin,
Modify the second line of your syntax to read :

data list  / dosageofstjohnswort (a1) alertness (a1).


Thanks.
Edward.


-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]]On Behalf
Of
Martin Sherman
Sent: Tuesday, November 28, 2006 10:36 AM
To: [hidden email]
Subject: simple data list input creates error


Dear List: I am using a syntax file to input data (See below). I get
an
error message that an invalid numeric field has been found.  The
problem
starts with the letter b and then e. I have used this syntax before
and
never had a problem.  (Using SPSS14). What am I missing. Thanks,
martin
sherman

comment problem #1 using data list in syntax to create Data file.
data list  / dosageofstjohnswort 1 alertness 2.
begin data
16
17
14
14
12
13
13
11
24
25
26
23
26
23
24
23
38
39
36
36
34
35
34
33
49
45
46
46
46
47
46
44
54
54
56
56
56
56
57
59
end data.
freq var=all.

Martin F. Sherman, Ph.D.
Professor of Psychology
Loyola College
Director of Masters Education: Thesis Track
Psychology Department
222 B Beatty Hall
4501 North Charles Street
Baltimore, MD 21210
Martin F. Sherman, Ph.D.
Professor of Psychology
Director of Masters Education: Thesis Track
Loyola College
Psychology Department
222 B Beatty Hall
4501 North Charles Street
Baltimore, MD 21210

410 617-2417 (office)
410 617-5341 (fax)

[hidden email]
Reply | Threaded
Open this post in threaded view
|

Re: simple data list input creates error

Art Kendall
In reply to this post by msherman
try putting FIXED after "list"

Art Kendall
Social Research Consultants

Martin Sherman wrote:

>Dear List: I am using a syntax file to input data (See below). I get an
>error message that an invalid numeric field has been found.  The problem
>starts with the letter b and then e. I have used this syntax before and
>never had a problem.  (Using SPSS14). What am I missing. Thanks,  martin
>sherman
>
>comment problem #1 using data list in syntax to create Data file.
>data list  / dosageofstjohnswort 1 alertness 2.
>begin data
>16
>17
>14
>14
>12
>13
>13
>11
>24
>25
>26
>23
>26
>23
>24
>23
>38
>39
>36
>36
>34
>35
>34
>33
>49
>45
>46
>46
>46
>47
>46
>44
>54
>54
>56
>56
>56
>56
>57
>59
>end data.
>freq var=all.
>
>Martin F. Sherman, Ph.D.
>Professor of Psychology
>Loyola College
>Director of Masters Education: Thesis Track
>Psychology Department
>222 B Beatty Hall
>4501 North Charles Street
>Baltimore, MD 21210
>Martin F. Sherman, Ph.D.
>Professor of Psychology
>Director of Masters Education: Thesis Track
>Loyola College
>Psychology Department
>222 B Beatty Hall
>4501 North Charles Street
>Baltimore, MD 21210
>
>410 617-2417 (office)
>410 617-5341 (fax)
>
>[hidden email]
>
>
>
>
Art Kendall
Social Research Consultants
Reply | Threaded
Open this post in threaded view
|

Re: simple data list input creates error

Art Kendall-2
In reply to this post by Edward Boadi
The syntax works fine on my system.
I did not know that data list would work without FIXED FREE OR LIST!

Art Kendall
Social Research Consultants

Edward Boadi wrote:

>Hi Martin,
>Your syntax works fine at my end.
>It however generates the said error message when I added non numeric characters to
>the data set.My proposed solution works (At my end) with a mixture of numeric and non numeric data sets.
>
>Below is the syntax and output.
>
>data list  / dosageofstjohnswort(a1)  alertness (a1) .
>begin data
>16
>17
>14
>14
>12
>13
>13
>11
>24
>25
>26
>23
>26
>23
>24
>23
>38
>39
>36
>36
>34
>35
>34
>33
>49
>45
>46
>46
>46
>47
>46
>44
>54
>54
>56
>56
>56
>56
>57
>59
>be
>end data.
>freq var=all
>
>        *******Output ************
>
>Data List will read 1 records from the command file
>
>Variable                Rec   Start     End  Format
>
>dosageofstjohnswort     1       1       1  A1
>
>alertness               1       2       2  A1
>
>
>      dosageofstjohnswort
>     Frequency  Percent Valid Percent   Cumulative Percent
>1       8       19.5    19.5            19.5
>2       8       19.5    19.5            39.0
>3       8       19.5    19.5            58.5
>4       8       19.5    19.5            78.0
>5       8       19.5    19.5            97.6
>b       1       2.4     2.4             100.0
>Total   41      100.0   100.0
>
>
>               alertness
>   Frequency    Percent Valid Percent   Cumulative Percent
>1       1       2.4     2.4             2.4
>2       1       2.4     2.4             4.9
>3       6       14.6    14.6            19.5
>4       9       22.0    22.0            41.5
>5       3       7.3     7.3             48.8
>6       13      31.7    31.7            80.5
>7       3       7.3     7.3             87.8
>8       1       2.4     2.4             90.2
>9       3       7.3     7.3             97.6
>e       1       2.4     2.4             100.0
>Total   41      100.0   100.0
>
>Thanks.
>Edward.
>
>-----Original Message-----
>From: Martin Sherman [mailto:[hidden email]]
>Sent: Tuesday, November 28, 2006 11:05 AM
>To: Edward Boadi
>Subject: RE: simple data list input creates error
>
>
>Edward: Thanks, but I tried that and it does not change anything. This
>syntax has always worked in the past.  martin
>
>
>
>>>>"Edward Boadi" <[hidden email]> 11/28/2006 10:53 AM >>>
>>>>
>>>>
>Hi Martin,
>Modify the second line of your syntax to read :
>
>data list  / dosageofstjohnswort (a1) alertness (a1).
>
>
>Thanks.
>Edward.
>
>
>-----Original Message-----
>From: SPSSX(r) Discussion [mailto:[hidden email]]On Behalf
>Of
>Martin Sherman
>Sent: Tuesday, November 28, 2006 10:36 AM
>To: [hidden email]
>Subject: simple data list input creates error
>
>
>Dear List: I am using a syntax file to input data (See below). I get
>an
>error message that an invalid numeric field has been found.  The
>problem
>starts with the letter b and then e. I have used this syntax before
>and
>never had a problem.  (Using SPSS14). What am I missing. Thanks,
>martin
>sherman
>
>comment problem #1 using data list in syntax to create Data file.
>data list  / dosageofstjohnswort 1 alertness 2.
>begin data
>16
>17
>14
>14
>12
>13
>13
>11
>24
>25
>26
>23
>26
>23
>24
>23
>38
>39
>36
>36
>34
>35
>34
>33
>49
>45
>46
>46
>46
>47
>46
>44
>54
>54
>56
>56
>56
>56
>57
>59
>end data.
>freq var=all.
>
>Martin F. Sherman, Ph.D.
>Professor of Psychology
>Loyola College
>Director of Masters Education: Thesis Track
>Psychology Department
>222 B Beatty Hall
>4501 North Charles Street
>Baltimore, MD 21210
>Martin F. Sherman, Ph.D.
>Professor of Psychology
>Director of Masters Education: Thesis Track
>Loyola College
>Psychology Department
>222 B Beatty Hall
>4501 North Charles Street
>Baltimore, MD 21210
>
>410 617-2417 (office)
>410 617-5341 (fax)
>
>[hidden email]
>
>
>
>
Reply | Threaded
Open this post in threaded view
|

Re: simple data list input creates error

Jerabek Jindrich
Hello Martin,

the warning ' an invalid numeric field has been found' with data list means that something else than numbers was found when reading numeric variable from text - e.g. letter, spec char, comma instead of dec point etc.Maybe there are empty lines that also could cause trouble.

Anyway, in such case the data list should run with a warning(not error), all correct records read and the wrong set to sysmis. The warning message should specify which record is wrong and why -
> >problem
> >starts with the letter b and then e. (do you have letters b and e in in your text?)

IMO this is a warning saying your text dataset is not clean and it should be solved by cleaning the original data.

HTH
Jindra

> ------------ Původní zpráva ------------
> Od: Art Kendall <[hidden email]>
> Předmět: Re: simple data list input creates error
> Datum: 29.11.2006 15:02:45
> ----------------------------------------
> The syntax works fine on my system.
> I did not know that data list would work without FIXED FREE OR LIST!
>
> Art Kendall
> Social Research Consultants
>
> Edward Boadi wrote:
>
> >Hi Martin,
> >Your syntax works fine at my end.
> >It however generates the said error message when I added non numeric characters
> to
> >the data set.My proposed solution works (At my end) with a mixture of numeric
> and non numeric data sets.
> >
> >Below is the syntax and output.
> >
> >data list  / dosageofstjohnswort(a1)  alertness (a1) .
> >begin data
> >16
> >17
> >14
> >14
> >12
> >13
> >13
> >11
> >24
> >25
> >26
> >23
> >26
> >23
> >24
> >23
> >38
> >39
> >36
> >36
> >34
> >35
> >34
> >33
> >49
> >45
> >46
> >46
> >46
> >47
> >46
> >44
> >54
> >54
> >56
> >56
> >56
> >56
> >57
> >59
> >be
> >end data.
> >freq var=all
> >
> >        *******Output ************
> >
> >Data List will read 1 records from the command file
> >
> >Variable                Rec   Start     End  Format
> >
> >dosageofstjohnswort     1       1       1  A1
> >
> >alertness               1       2       2  A1
> >
> >
> >      dosageofstjohnswort
> >     Frequency  Percent Valid Percent   Cumulative Percent
> >1       8       19.5    19.5            19.5
> >2       8       19.5    19.5            39.0
> >3       8       19.5    19.5            58.5
> >4       8       19.5    19.5            78.0
> >5       8       19.5    19.5            97.6
> >b       1       2.4     2.4             100.0
> >Total   41      100.0   100.0
> >
> >
> >               alertness
> >   Frequency    Percent Valid Percent   Cumulative Percent
> >1       1       2.4     2.4             2.4
> >2       1       2.4     2.4             4.9
> >3       6       14.6    14.6            19.5
> >4       9       22.0    22.0            41.5
> >5       3       7.3     7.3             48.8
> >6       13      31.7    31.7            80.5
> >7       3       7.3     7.3             87.8
> >8       1       2.4     2.4             90.2
> >9       3       7.3     7.3             97.6
> >e       1       2.4     2.4             100.0
> >Total   41      100.0   100.0
> >
> >Thanks.
> >Edward.
> >
> >-----Original Message-----
> >From: Martin Sherman [mailto:[hidden email]]
> >Sent: Tuesday, November 28, 2006 11:05 AM
> >To: Edward Boadi
> >Subject: RE: simple data list input creates error
> >
> >
> >Edward: Thanks, but I tried that and it does not change anything. This
> >syntax has always worked in the past.  martin
> >
> >
> >
> >>>>"Edward Boadi" <[hidden email]> 11/28/2006 10:53 AM >>>
> >>>>
> >>>>
> >Hi Martin,
> >Modify the second line of your syntax to read :
> >
> >data list  / dosageofstjohnswort (a1) alertness (a1).
> >
> >
> >Thanks.
> >Edward.
> >
> >
> >-----Original Message-----
> >From: SPSSX(r) Discussion [mailto:[hidden email]]On Behalf
> >Of
> >Martin Sherman
> >Sent: Tuesday, November 28, 2006 10:36 AM
> >To: [hidden email]
> >Subject: simple data list input creates error
> >
> >
> >Dear List: I am using a syntax file to input data (See below). I get
> >an
> >error message that an invalid numeric field has been found.  The
> >problem
> >starts with the letter b and then e. I have used this syntax before
> >and
> >never had a problem.  (Using SPSS14). What am I missing. Thanks,
> >martin
> >sherman
> >
> >comment problem #1 using data list in syntax to create Data file.
> >data list  / dosageofstjohnswort 1 alertness 2.
> >begin data
> >16
> >17
> >14
> >14
> >12
> >13
> >13
> >11
> >24
> >25
> >26
> >23
> >26
> >23
> >24
> >23
> >38
> >39
> >36
> >36
> >34
> >35
> >34
> >33
> >49
> >45
> >46
> >46
> >46
> >47
> >46
> >44
> >54
> >54
> >56
> >56
> >56
> >56
> >57
> >59
> >end data.
> >freq var=all.
> >
> >Martin F. Sherman, Ph.D.
> >Professor of Psychology
> >Loyola College
> >Director of Masters Education: Thesis Track
> >Psychology Department
> >222 B Beatty Hall
> >4501 North Charles Street
> >Baltimore, MD 21210
> >Martin F. Sherman, Ph.D.
> >Professor of Psychology
> >Director of Masters Education: Thesis Track
> >Loyola College
> >Psychology Department
> >222 B Beatty Hall
> >4501 North Charles Street
> >Baltimore, MD 21210
> >
> >410 617-2417 (office)
> >410 617-5341 (fax)
> >
> >[hidden email]
> >
> >
> >
> >
>
>
>