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 |
I am currently away from the office and will have limited access to email. I will respond to your email when possible.
|
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 ConsultantsOn 1/3/2013 4:44 AM, ns257 wrote: I cannot run "select" - filter command in variables that are of the following type ===================== 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 |
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.
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?" |
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 |
Administrator
|
You obviously have never spent any time doing technical support!
--
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?" |
Free forum by Nabble | Edit this page |