Parsing a VALUE LABELS command - ???

[Richard Ristow]

SPSS 14 for Windows. Here's an error message from a VALUE LABELS statement.

It appears that the text '/TAG' is being parsed according to the rules for the statement, and producing the error. BUT, that text is within a quoted string; no matter what's in the quotes, it should be taken as literal text, not command, right? What am I missing?

VALUE LABELS N_BRKR_CD
   41541 = "TAYLOR RUSSELL C"
   41546 = "TAYLOR THEODORE W"
   41713 = "TESTA BROTHERS LTD/TAG"

>Warning # 208 in column 35.  Text:
>A text string is not correctly enclosed in quotation marks on the command
>line.  Literals may not be continued across command lines without the use
>of the continuation symbol '+'.

>Warning # 4474.  Command name: VALUE LABELS
>The (ADD) VALUE LABELS command specifies an unknown variable name.  The
>name will be ignored.

>The error is associated with 'TAG'


>Warning # 4487 in column 35.  Text:
>The (ADD) VALUE LABELS command specifies the labeling of a value which is
>inconsistent with the type and/or the format of the variables to be
>labeled.  The value and the applicable label will be ignored.  This error
>may occur because a numeric value was omitted and the system mistook a
>label for a character value, or the display formats of the variables are
>not the same.

   41905 = "THE EZELL GROUP"
   41985 = "THE HOFFMAN AGENCY"
         .

==========================
APPENDIX:  Complete syntax
==========================
GET
  FILE='C:\Documents and Settings\Richard\My Documents\Professional\MetLife'+
 '\Live data\One_Pct.sav'.

DATASET NAME Quotes_OnePct WINDOW=FRONT.

VALUE LABELS N_BRKR_CD                           
     165 = "6SJ3123"                             
     440 = "AAA EAST PENN INS AGCY INC"          
     494 = "AAA INSURANCE AGENCY"                
     505 = "AAA INSURANCE AGENCY"                
     526 = "AAA INSURANCE AGENCY"                
     541 = "AAA INSURANCE AGENCY"                
     598 = "AAA MONTANA"                         
     653 = "AAA-B BRYAN"                         
     659 = "AAA-B TUOTT"                         
     782 = "ABBOTT PAUL"   
   41541 = "TAYLOR RUSSELL C"                    
   41546 = "TAYLOR THEODORE W"                   
   41713 = "TESTA BROTHERS LTD/TAG"              
   41905 = "THE EZELL GROUP"                     
   41985 = "THE HOFFMAN AGENCY"
         .                                     

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

[Peck, Jon]

ditch those equals signs.

 

---

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Richard Ristow
Sent: Monday, June 01, 2009 1:13 PM
To: [hidden email]
Subject: [SPSSX-L] Parsing a VALUE LABELS command - ???

 

SPSS 14 for Windows. Here's an error message from a VALUE LABELS statement.

It appears that the text '/TAG' is being parsed according to the rules for the statement, and producing the error. BUT, that text is within a quoted string; no matter what's in the quotes, it should be taken as literal text, not command, right? What am I missing?

VALUE LABELS N_BRKR_CD
   41541 = "TAYLOR RUSSELL C"
   41546 = "TAYLOR THEODORE W"
   41713 = "TESTA BROTHERS LTD/TAG"

>Warning # 208 in column 35.  Text:
>A text string is not correctly enclosed in quotation marks on the command
>line.  Literals may not be continued across command lines without the use
>of the continuation symbol '+'.

>Warning # 4474.  Command name: VALUE LABELS
>The (ADD) VALUE LABELS command specifies an unknown variable name.  The
>name will be ignored.

>The error is associated with 'TAG'


>Warning # 4487 in column 35.  Text:
>The (ADD) VALUE LABELS command specifies the labeling of a value which is
>inconsistent with the type and/or the format of the variables to be
>labeled.  The value and the applicable label will be ignored.  This error
>may occur because a numeric value was omitted and the system mistook a
>label for a character value, or the display formats of the variables are
>not the same.

   41905 = "THE EZELL GROUP"
   41985 = "THE HOFFMAN AGENCY"
         .

==========================
APPENDIX:  Complete syntax
==========================
GET
  FILE='C:\Documents and Settings\Richard\My Documents\Professional\MetLife'+
 '\Live data\One_Pct.sav'.

DATASET NAME Quotes_OnePct WINDOW=FRONT.

VALUE LABELS N_BRKR_CD                           
     165 = "6SJ3123"                             
     440 = "AAA EAST PENN INS AGCY INC"          
     494 = "AAA INSURANCE AGENCY"                
     505 = "AAA INSURANCE AGENCY"                
     526 = "AAA INSURANCE AGENCY"                
     541 = "AAA INSURANCE AGENCY"                
     598 = "AAA MONTANA"                         
     653 = "AAA-B BRYAN"                         
     659 = "AAA-B TUOTT"                         
     782 = "ABBOTT PAUL"   
   41541 = "TAYLOR RUSSELL C"                    
   41546 = "TAYLOR THEODORE W"                   
   41713 = "TESTA BROTHERS LTD/TAG"              
   41905 = "THE EZELL GROUP"                     
   41985 = "THE HOFFMAN AGENCY"
         .                                     

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

[DataMaestro]

The error might be before that VALUE LABELS statement.

 

Look 4 a missing "." ending pevious statements.

 

George

--- On Mon, 6/1/09, Richard Ristow <[hidden email]> wrote:

From: Richard Ristow <[hidden email]>
Subject: Parsing a VALUE LABELS command - ???
To: [hidden email]
Date: Monday, June 1, 2009, 3:13 PM

SPSS 14 for Windows. Here's an error message from a VALUE LABELS statement.

It appears that the text '/TAG' is being parsed according to the rules for the statement, and producing the error. BUT, that text is within a quoted string; no matter what's in the quotes, it should be taken as literal text, not command, right? What am I missing?

VALUE LABELS N_BRKR_CD
   41541 = "TAYLOR RUSSELL C"
   41546 = "TAYLOR THEODORE W"
   41713 = "TESTA BROTHERS LTD/TAG"

>Warning # 208 in column 35.  Text:
>A text string is not correctly enclosed in quotation marks on the command
>line.  Literals may not be continued across command lines without the use
>of the continuation symbol '+'.

>Warning # 4474.  Command name: VALUE LABELS
>The (ADD) VALUE LABELS command specifies an unknown variable name.  The
>name will be ignored.

>The error is associated with 'TAG'


>Warning # 4487 in column 35.  Text:
>The (ADD) VALUE LABELS command specifies the labeling of a value which is
>inconsistent with the type and/or the format of the variables to be
>labeled.  The value and the applicable label will be ignored.  This error
>may occur because a numeric value was omitted and the system mistook a
>label for a character value, or the display formats of the variables are
>not the same.

   41905 = "THE EZELL GROUP"
   41985 = "THE HOFFMAN AGENCY"
         .

==========================
APPENDIX:  Complete syntax
==========================
GET
  FILE='C:\Documents and Settings\Richard\My Documents\Professional\MetLife'+
 '\Live data\One_Pct.sav'.

DATASET NAME Quotes_OnePct WINDOW=FRONT.

VALUE LABELS N_BRKR_CD                           
     165 = "6SJ3123"                             
     440 = "AAA EAST PENN INS AGCY INC"          
     494 = "AAA INSURANCE AGENCY"                
     505 = "AAA INSURANCE AGENCY"                
     526 = "AAA INSURANCE AGENCY"                
     541 = "AAA INSURANCE AGENCY"                
     598 = "AAA MONTANA"                         
     653 = "AAA-B BRYAN"                         
     659 = "AAA-B TUOTT"                         
     782 = "ABBOTT PAUL"   
   41541 = "TAYLOR RUSSELL C"                    
   41546 = "TAYLOR THEODORE W"                   
   41713 = "TESTA BROTHERS LTD/TAG"              
   41905 = "THE EZELL GROUP"                     
   41985 = "THE HOFFMAN AGENCY"
         .                                     

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

[ViAnn Beadle]

Drop the equals sign. I have never seen anybody use one in a value labels command before and is surprised that it didn’t fail from the get-go. Apparently the equals sign is ignored most of the time but not when the string seems to have an slash in it.

 

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Richard Ristow
Sent: Monday, June 01, 2009 1:13 PM
To: [hidden email]
Subject: Parsing a VALUE LABELS command - ???

 

SPSS 14 for Windows. Here's an error message from a VALUE LABELS statement.

It appears that the text '/TAG' is being parsed according to the rules for the statement, and producing the error. BUT, that text is within a quoted string; no matter what's in the quotes, it should be taken as literal text, not command, right? What am I missing?

VALUE LABELS N_BRKR_CD
   41541 = "TAYLOR RUSSELL C"
   41546 = "TAYLOR THEODORE W"
   41713 = "TESTA BROTHERS LTD/TAG"

>Warning # 208 in column 35.  Text:
>A text string is not correctly enclosed in quotation marks on the command
>line.  Literals may not be continued across command lines without the use
>of the continuation symbol '+'.

>Warning # 4474.  Command name: VALUE LABELS
>The (ADD) VALUE LABELS command specifies an unknown variable name.  The
>name will be ignored.

>The error is associated with 'TAG'


>Warning # 4487 in column 35.  Text:
>The (ADD) VALUE LABELS command specifies the labeling of a value which is
>inconsistent with the type and/or the format of the variables to be
>labeled.  The value and the applicable label will be ignored.  This error
>may occur because a numeric value was omitted and the system mistook a
>label for a character value, or the display formats of the variables are
>not the same.

   41905 = "THE EZELL GROUP"
   41985 = "THE HOFFMAN AGENCY"
         .

==========================
APPENDIX:  Complete syntax
==========================
GET
  FILE='C:\Documents and Settings\Richard\My Documents\Professional\MetLife'+
 '\Live data\One_Pct.sav'.

DATASET NAME Quotes_OnePct WINDOW=FRONT.

VALUE LABELS N_BRKR_CD                           
     165 = "6SJ3123"                             
     440 = "AAA EAST PENN INS AGCY INC"          
     494 = "AAA INSURANCE AGENCY"                
     505 = "AAA INSURANCE AGENCY"                
     526 = "AAA INSURANCE AGENCY"                
     541 = "AAA INSURANCE AGENCY"                
     598 = "AAA MONTANA"                         
     653 = "AAA-B BRYAN"                         
     659 = "AAA-B TUOTT"                         
     782 = "ABBOTT PAUL"   
   41541 = "TAYLOR RUSSELL C"                    
   41546 = "TAYLOR THEODORE W"                   
   41713 = "TESTA BROTHERS LTD/TAG"              
   41905 = "THE EZELL GROUP"                     
   41985 = "THE HOFFMAN AGENCY"
         .                                     

 

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

[Richard Ristow]

Thanks to Jon Peck and ViAnn Beadle for pointing out that you don't
put '=' signs between value and label, in VALUE LABELS statements.
I'm not sure how I got the idea of the '=' signs into my head.

-Many thanks, with embarrassment,
  Richard

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD