Error NUMERIC STRING

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

Error NUMERIC STRING

ns257
I cannot run "select" - filter command in variables that are of the following type

NAME                    TYPE         WIDTH      DECIMALS    LABEL                                       VALUES        MISSING    COLUMNS    ALIGN    MEASURE    ROLE
minimental.30    Numeric    8                0                    Mini Mental Examination    None            None            11                Right        Scale            Input

I get the following error message

USE ALL.
COMPUTE filter_$=(minimental.30 < 25).

>Error # 4309 in column 1024.  Text: (End of Command)
>Invalid combination of data types in an assignment.  Character strings may
>only be assigned to string variables.  Numeric and logical quantities may only
>be assigned to numeric variables.  Use the STRING command to declare new
>string variables before assigning values to them or consider using the STRING
>or NUMBER function.
>Execution of this command stops.
VARIABLE LABELS filter_$ 'minimental.30 < 25 (FILTER)'.
VALUE LABELS filter_$ 0 'Not Selected' 1 'Selected'.
FORMATS filter_$ (f1.0).
 
>Error # 4836 in column 9.  Text: filter_$
>Only the formats A and AHEX can be applied to string variables.
>Execution of this command stops.
FILTER BY filter_$.
 
>Error # 4877 in column 11.  Text: filter_$
>The filter variable must be a numeric variable.
>Execution of this command stops.

EXECUTE.


Any ideas how to resolve this?
Thanks in advance

NIKOS
Reply | Threaded
Open this post in threaded view
|

Automatic reply: Error NUMERIC STRING

Susan Maree Cotton

I am currently away from the office and will have limited access to email.  I will respond to your email when possible.

Reply | Threaded
Open this post in threaded view
|

Re: Error NUMERIC STRING

Art Kendall
In reply to this post by ns257
in the syntax stream after you try this command type
display dictionary.
open a new syntax window. paste the syntax below into it.  Run it.
data list list /id (f2) minimental.30 (f8).
begin data
01 30
02 29
03 26
04 25
05 24
06 10
end data.
display dictionary.
USE ALL.
COMPUTE filter_$=(minimental.30 lt 25).
display dictionary.
list.


Art Kendall
Social Research Consultants
On 1/3/2013 4:44 AM, ns257 wrote:
I cannot run "select" - filter command in variables that are of the following type

NAME                    TYPE         WIDTH      DECIMALS    LABEL                                       VALUES        MISSING    COLUMNS    ALIGN    MEASURE    ROLE
minimental.30    Numeric    8                0                    Mini Mental Examination    None            None            11                Right        Scale            Input

I get the following error message

USE ALL.
COMPUTE filter_$=(minimental.30 < 25).

>Error # 4309 in column 1024.  Text: (End of Command)
>Invalid combination of data types in an assignment.  Character strings may
>only be assigned to string variables.  Numeric and logical quantities may only
>be assigned to numeric variables.  Use the STRING command to declare new
>string variables before assigning values to them or consider using the STRING
>or NUMBER function.
>Execution of this command stops.
VARIABLE LABELS filter_$ 'minimental.30 < 25 (FILTER)'.
VALUE LABELS filter_$ 0 'Not Selected' 1 'Selected'.
FORMATS filter_$ (f1.0).
 
>Error # 4836 in column 9.  Text: filter_$
>Only the formats A and AHEX can be applied to string variables.
>Execution of this command stops.
FILTER BY filter_$.
 
>Error # 4877 in column 11.  Text: filter_$
>The filter variable must be a numeric variable.
>Execution of this command stops.

EXECUTE.


Any ideas how to resolve this?
Thanks in advance

NIKOS


View this message in context: Error NUMERIC STRING
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

===================== 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
Art Kendall
Social Research Consultants
Reply | Threaded
Open this post in threaded view
|

Re: Error NUMERIC STRING

David Marso
Administrator
In reply to this post by ns257
It appears you are drawing premature conclusions re the cause.
My ESPss tells me you already have a variable in your file named filter_$ and it is a string variable.
ns257 wrote
I cannot run "select" - filter command in variables that are of the
following type

*NAME                    TYPE         WIDTH      DECIMALS LABEL        
                                VALUES MISSING    COLUMNS    ALIGN    
MEASURE    ROLE**
**minimental.30    Numeric    8                0     Mini Mental
Examination    None            None 11                Right        Scale
            Input*

I get the following error message

_/USE ALL. /__/
/__/COMPUTE filter_$=(minimental.30 < 25). /__
__
__/>Error # 4309 in column 1024.  Text: (End of Command)
 >Invalid combination of data types in an assignment. Character strings may
 >only be assigned to string variables.  Numeric and logical quantities
may only
 >be assigned to numeric variables.  Use the STRING command to declare new
 >string variables before assigning values to them or consider using the
STRING
 >or NUMBER function.
 >Execution of this command stops.
VARIABLE LABELS filter_$ 'minimental.30 < 25 (FILTER)'.
VALUE LABELS filter_$ 0 'Not Selected' 1 'Selected'.
FORMATS filter_$ (f1.0).

 >Error # 4836 in column 9.  Text: filter_$
 >Only the formats A and AHEX can be applied to string variables.
 >Execution of this command stops.
FILTER BY filter_$.

 >Error # 4877 in column 11.  Text: filter_$
 >The filter variable must be a numeric variable.
 >Execution of this command stops.

EXECUTE./_

Any ideas how to resolve this?
Thanks in advance

NIKOS
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me.
---
"Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis."
Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?"
Reply | Threaded
Open this post in threaded view
|

Re: Error NUMERIC STRING

Rick Oliver-3
A distinct possibility, although it would be weird for a user to create a string variable named filter_$. AFAIK, whenever the dialog interface creates this variable, it is numeric.

Rick Oliver
Senior Information Developer
IBM Business Analytics (SPSS)
E-mail: [hidden email]




From:        David Marso <[hidden email]>
To:        [hidden email],
Date:        01/03/2013 10:18 AM
Subject:        Re: Error NUMERIC STRING
Sent by:        "SPSSX(r) Discussion" <[hidden email]>




It appears you are drawing premature conclusions re the cause.
My ESPss tells me you *already *have a variable in your file named filter_$
and it is a *string *variable.

ns257 wrote
> I cannot run "select" - filter command in variables that are of the
> following type
>
> *NAME                    TYPE         WIDTH      DECIMALS LABEL
>                                 VALUES MISSING    COLUMNS    ALIGN
> MEASURE    ROLE**
> **minimental.30    Numeric    8                0     Mini Mental
> Examination    None            None 11                Right        Scale
>             Input*
>
> I get the following error message
>
> _/USE ALL. /__/
> /__/COMPUTE filter_$=(minimental.30 < 25). /__
> __
> __/>Error # 4309 in column 1024.  Text: (End of Command)
>  >Invalid combination of data types in an assignment. Character strings
> may
>  >only be assigned to string variables.  Numeric and logical quantities
> may only
>  >be assigned to numeric variables.  Use the STRING command to declare new
>  >string variables before assigning values to them or consider using the
> STRING
>  >or NUMBER function.
>  >Execution of this command stops.
> VARIABLE LABELS filter_$ 'minimental.30 < 25 (FILTER)'.
> VALUE LABELS filter_$ 0 'Not Selected' 1 'Selected'.
> FORMATS filter_$ (f1.0).
>
>  >Error # 4836 in column 9.  Text: filter_$
>  >Only the formats A and AHEX can be applied to string variables.
>  >Execution of this command stops.
> FILTER BY filter_$.
>
>  >Error # 4877 in column 11.  Text: filter_$
>  >The filter variable must be a numeric variable.
>  >Execution of this command stops.
>
> EXECUTE./_
>
> Any ideas how to resolve this?
> Thanks in advance
>
> NIKOS





-----
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me.
--
View this message in context:
http://spssx-discussion.1045642.n5.nabble.com/Error-NUMERIC-STRING-tp5717205p5717210.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
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


Reply | Threaded
Open this post in threaded view
|

Re: Error NUMERIC STRING

David Marso
Administrator
You obviously have never spent any time doing technical support!
--
Rick Oliver wrote
A distinct possibility, although it would be weird for a user to create a
string variable named filter_$. AFAIK, whenever the dialog interface
creates this variable, it is numeric.

Rick Oliver
Senior Information Developer
IBM Business Analytics (SPSS)
E-mail: [hidden email]



From:   David Marso <[hidden email]>
To:     [hidden email],
Date:   01/03/2013 10:18 AM
Subject:        Re: Error NUMERIC STRING
Sent by:        "SPSSX(r) Discussion" <[hidden email]>



It appears you are drawing premature conclusions re the cause.
My ESPss tells me you *already *have a variable in your file named
filter_$
and it is a *string *variable.

ns257 wrote
> I cannot run "select" - filter command in variables that are of the
> following type
>
> *NAME                    TYPE         WIDTH      DECIMALS LABEL
>                                 VALUES MISSING    COLUMNS    ALIGN
> MEASURE    ROLE**
> **minimental.30    Numeric    8                0     Mini Mental
> Examination    None            None 11                Right        Scale
>             Input*
>
> I get the following error message
>
> _/USE ALL. /__/
> /__/COMPUTE filter_$=(minimental.30 < 25). /__
> __
> __/>Error # 4309 in column 1024.  Text: (End of Command)
>  >Invalid combination of data types in an assignment. Character strings
> may
>  >only be assigned to string variables.  Numeric and logical quantities
> may only
>  >be assigned to numeric variables.  Use the STRING command to declare
new
>  >string variables before assigning values to them or consider using the
> STRING
>  >or NUMBER function.
>  >Execution of this command stops.
> VARIABLE LABELS filter_$ 'minimental.30 < 25 (FILTER)'.
> VALUE LABELS filter_$ 0 'Not Selected' 1 'Selected'.
> FORMATS filter_$ (f1.0).
>
>  >Error # 4836 in column 9.  Text: filter_$
>  >Only the formats A and AHEX can be applied to string variables.
>  >Execution of this command stops.
> FILTER BY filter_$.
>
>  >Error # 4877 in column 11.  Text: filter_$
>  >The filter variable must be a numeric variable.
>  >Execution of this command stops.
>
> EXECUTE./_
>
> Any ideas how to resolve this?
> Thanks in advance
>
> NIKOS





-----
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to
email me.
--
View this message in context:
http://spssx-discussion.1045642.n5.nabble.com/Error-NUMERIC-STRING-tp5717205p5717210.html

Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
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
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me.
---
"Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis."
Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?"