HELP!Error # 4381 in column 1. Text: EXECUTE. >The expression ends unexpectedly. >Execution of this command stops.

[Bulldawgchick]

I keep getting this error when I run this function Please Help!
DATASET ACTIVATE DataSet1.
IF (Total_Power> 8= 1) Median_Split_TP=Total_Power > 8
EXECUTE. .
IF (Total_Power> 8= 1) Median_Split_TP=Total_Power < 8 = 0
EXECUTE.

[Jignesh Sutar]

I think you are trying to achieve something like this, perhaps?:


comute Median_Split_TP = (Total_Power > 8).

Which will give you a 0 (zero) on Median_Split_TP if Total_Power is greater than  8 or else otherwise a 1 (one) if less than  or equal to 8.

[David Marso]

You need periods at the end of the IF statements.
Also your second one is a victim of LCP (Lazy Copy-Paste) syndrome.
As Jignesh stated this can be more concisely expressed as

COMPUTE Median_Split_TP=(Total_Power GT 8).
I think you need to consider the case where Total_Power EQ 8.
What bucket does that go into?

You also DON'T NEED the EXECUTE statements at all.

Bulldawgchick wrote

I keep getting this error when I run this function Please Help!
DATASET ACTIVATE DataSet1.
IF (Total_Power> 8= 1) Median_Split_TP=Total_Power > 8
EXECUTE. .
IF (Total_Power> 8= 1) Median_Split_TP=Total_Power < 8 = 0
EXECUTE.

[Art Kendall]

If you first did a data pass to find the median you could instead use RANK with NTILES=2.

[Art Kendall]

Of course these days a data pass is a trivial matter unless you have a huge file.

As an exercise, use the transformation method and the RANK method to create new variables and    then CROSSTAB the 2 variables.

Of course be aware that an adjective is frequently used before "median split" as in
nefarious median split or
invidious median split.

[Maguin, Eugene]

Those statements don't make any sense. I'd bet you can't put into words what the computations are doing. Why don't you begin there. State in words what you want to do.
I would suggest that you look at the syntax reference (accessible from the Help drop-down) ... but why?

Alternatively go to the Transform dropdown in the data window and write the command there.

Gene Maguin


-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Bulldawgchick
Sent: Tuesday, October 27, 2015 12:50 AM
To: [hidden email]
Subject: HELP!Error # 4381 in column 1. Text: EXECUTE. >The expression ends unexpectedly. >Execution of this command stops.

I keep getting this error when I run this function Please Help!
DATASET ACTIVATE DataSet1.
IF (Total_Power> 8= 1) Median_Split_TP=Total_Power > 8
EXECUTE. .
IF (Total_Power> 8= 1) Median_Split_TP=Total_Power < 8 = 0
EXECUTE.



--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/HELP-Error-4381-in-column-1-Text-EXECUTE-The-expression-ends-unexpectedly-Execution-of-this-command--tp5730872.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

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

[David Marso]

Actually Gene,
It is perfectly valid syntax although terribly WRONG in so many ways WRT coding practices and the likelihood of functioning as intended/desired.
It is however an utterly ridiculous way of attempting to express something very simple.
Looks like an attempt to dichotomize a variable based on a cutpoint.
I ask the OP: what in the H is wrong with a RECODE or a simple Boolean as demonstrated by Jignesh and myself earlier today?

RECODE var (LO THRU 8=0)(8 THRU HI=1) INTO newvar .
COMPUTE newvar=(var GT 8).

KISS!!!
-------------------

DATA LIST FREE / Total_Power .
BEGIN DATA
7 8 9
END DATA.
*/ Changed to get rid of the LCPS but still debased*/.
IF (Total_Power> 8= 1) Median_Split_TP=Total_Power > 8 .
IF (Total_Power < 8= 1) Median_Split_TP=Total_Power < 8 = 0 .
LIST.

 
Total_Power Median_Split_TP
 
      7.00           .00
      8.00           .
      9.00          1.00

Maguin, Eugene wrote

Those statements don't make any sense. I'd bet you can't put into words what the computations are doing. Why don't you begin there. State in words what you want to do.
I would suggest that you look at the syntax reference (accessible from the Help drop-down) ... but why?

Alternatively go to the Transform dropdown in the data window and write the command there.

Gene Maguin


-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Bulldawgchick
Sent: Tuesday, October 27, 2015 12:50 AM
To: [hidden email]
Subject: HELP!Error # 4381 in column 1. Text: EXECUTE. >The expression ends unexpectedly. >Execution of this command stops.

I keep getting this error when I run this function Please Help!
DATASET ACTIVATE DataSet1.
IF (Total_Power> 8= 1) Median_Split_TP=Total_Power > 8
EXECUTE. .
IF (Total_Power> 8= 1) Median_Split_TP=Total_Power < 8 = 0
EXECUTE.



--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/HELP-Error-4381-in-column-1-Text-EXECUTE-The-expression-ends-unexpectedly-Execution-of-this-command--tp5730872.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

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

[Maguin, Eugene]

David, thank you for the correction. I've noticed that you are very good at constructing compact expressions.

The funny thing (and probably absolutely not intended) is that those two original statement evaluate to the the same values. The intention seems to be to construct a median split but both statements evaluate to 1 if total_power is 9 or more; otherwise to sysmis.

Gene Maguin

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

[David Marso]

Hence my TLA LCP syndrome ;-)

On Tue, Oct 27, 2015 at 11:35 AM, Maguin, Eugene [via SPSSX Discussion] <[hidden email]> wrote:

David, thank you for the correction. I've noticed that you are very good at constructing compact expressions.

The funny thing (and probably absolutely not intended) is that those two original statement evaluate to the the same values. The intention seems to be to construct a median split but both statements evaluate to 1 if total_power is 9 or more; otherwise to sysmis.

Gene Maguin

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

---

If you reply to this email, your message will be added to the discussion below:

http://spssx-discussion.1045642.n5.nabble.com/HELP-Error-4381-in-column-1-Text-EXECUTE-The-expression-ends-unexpectedly-Execution-of-this-command--tp5730872p5730879.html

To unsubscribe from HELP!Error # 4381 in column 1. Text: EXECUTE. >The expression ends unexpectedly. >Execution of this command stops., click here.
NAML

[Bruce Weaver]

Huh?  TLA = "three letter acronym", perhaps?  No idea about LCP though. (Probably not Lymphocyte Cytosolic Protein.)   Put us out of our misery, David.  

http://www.acronymattic.com/TLA.html
http://www.acronymattic.com/LCP.html

David Marso wrote

Hence my TLA LCP syndrome ;-)

On Tue, Oct 27, 2015 at 11:35 AM, Maguin, Eugene [via SPSSX Discussion] <
[hidden email]> wrote:

> David, thank you for the correction. I've noticed that you are very good
> at constructing compact expressions.
>
> The funny thing (and probably absolutely not intended) is that those two
> original statement evaluate to the the same values. The intention seems to
> be to construct a median split but both statements evaluate to 1 if
> total_power is 9 or more; otherwise to sysmis.
>
> Gene Maguin
>
> =====================
> To manage your subscription to SPSSX-L, send a message to
> [hidden email] <http:///user/SendEmail.jtp?type=node&node=5730879&i=0>
> (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
>
>
> ------------------------------
> If you reply to this email, your message will be added to the discussion
> below:
>
> http://spssx-discussion.1045642.n5.nabble.com/HELP-Error-4381-in-column-1-Text-EXECUTE-The-expression-ends-unexpectedly-Execution-of-this-command--tp5730872p5730879.html
> To unsubscribe from HELP!Error # 4381 in column 1. Text: EXECUTE. >The
> expression ends unexpectedly. >Execution of this command stops., click
> here
> <http://spssx-discussion.1045642.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=5730872&code=ZGF2aWQubWFyc29AZ21haWwuY29tfDU3MzA4NzJ8LTkzOTgzMDYxMw==>
> .
> NAML
> <http://spssx-discussion.1045642.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>

[peter link]

I think "lazy copy paste" (lcp)

peter

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Bruce Weaver
Sent: Tuesday, October 27, 2015 10:38 AM
To: [hidden email]
Subject: Re: [SPSSX-L] HELP!Error # 4381 in column 1. Text: EXECUTE. >The
expression ends unexpectedly. >Execution of this command stops.

Huh?  TLA = "three letter acronym", perhaps?  No idea about LCP though.
(Probably not /Lymphocyte Cytosolic Protein/.)   Put us out of our misery,
David.  

http://www.acronymattic.com/TLA.html
http://www.acronymattic.com/LCP.html



David Marso wrote
> Hence my TLA LCP syndrome ;-)
>
> On Tue, Oct 27, 2015 at 11:35 AM, Maguin, Eugene [via SPSSX
> Discussion] <

> ml-node+s1045642n5730879h54@.nabble

>> wrote:
>
>> David, thank you for the correction. I've noticed that you are very
>> good at constructing compact expressions.
>>
>> The funny thing (and probably absolutely not intended) is that those
>> two original statement evaluate to the the same values. The intention
>> seems to be to construct a median split but both statements evaluate
>> to 1 if total_power is 9 or more; otherwise to sysmis.
>>
>> Gene Maguin
>>
>> =====================
>> To manage your subscription to SPSSX-L, send a message to [hidden
>> email]
>> &lt;http:///user/SendEmail.jtp?type=node&amp;node=5730879&amp;i=0&gt;
>> (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
>>
>>
>> ------------------------------
>> If you reply to this email, your message will be added to the
>> discussion
>> below:
>>
>> http://spssx-discussion.1045642.n5.nabble.com/HELP-Error-4381-in-colu
>> mn-1-Text-EXECUTE-The-expression-ends-unexpectedly-Execution-of-this-
>> command--tp5730872p5730879.html To unsubscribe from HELP!Error # 4381
>> in column 1. Text: EXECUTE. >The expression ends unexpectedly.
>> >Execution of this command stops., click here
>> &lt;http://spssx-discussion.1045642.n5.nabble.com/template/NamlServle
>> t.jtp?macro=unsubscribe_by_code&amp;node=5730872&amp;code=ZGF2aWQubWF
>> yc29AZ21haWwuY29tfDU3MzA4NzJ8LTkzOTgzMDYxMw==&gt;
>> .
>> NAML
>> &lt;http://spssx-discussion.1045642.n5.nabble.com/template/NamlServle
>> t.jtp?macro=macro_viewer&amp;id=instant_html%21nabble%3Aemail.naml&am
>> p;base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template
>> .NabbleNamespace-nabble.view.web.template.NodeNamespace&amp;breadcrum
>> bs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3
>> Aemail.naml-send_instant_email%21nabble%3Aemail.naml&gt;
>>

-----
--
Bruce Weaver
[hidden email]
http://sites.google.com/a/lakeheadu.ca/bweaver/

"When all else fails, RTFM."

NOTE: My Hotmail account is not monitored regularly.
To send me an e-mail, please use the address shown above.

--
View this message in context:
http://spssx-discussion.1045642.n5.nabble.com/HELP-Error-4381-in-column-1-Te
xt-EXECUTE-The-expression-ends-unexpectedly-Execution-of-this-command--tp573
0872p5730881.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

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

[David Marso]

Indeed! LCP=Lazy Copy Paste
Bruce is correct with TLA=Three Letter Acronym.

peter link wrote

I think "lazy copy paste" (lcp)

peter

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Bruce Weaver
Sent: Tuesday, October 27, 2015 10:38 AM
To: [hidden email]
Subject: Re: [SPSSX-L] HELP!Error # 4381 in column 1. Text: EXECUTE. >The
expression ends unexpectedly. >Execution of this command stops.

Huh?  TLA = "three letter acronym", perhaps?  No idea about LCP though.
(Probably not /Lymphocyte Cytosolic Protein/.)   Put us out of our misery,
David.  

http://www.acronymattic.com/TLA.html
http://www.acronymattic.com/LCP.html



David Marso wrote
> Hence my TLA LCP syndrome ;-)
>
> On Tue, Oct 27, 2015 at 11:35 AM, Maguin, Eugene [via SPSSX
> Discussion] <

> ml-node+s1045642n5730879h54@.nabble

>> wrote:
>
>> David, thank you for the correction. I've noticed that you are very
>> good at constructing compact expressions.
>>
>> The funny thing (and probably absolutely not intended) is that those
>> two original statement evaluate to the the same values. The intention
>> seems to be to construct a median split but both statements evaluate
>> to 1 if total_power is 9 or more; otherwise to sysmis.
>>
>> Gene Maguin
>>
>> =====================
>> To manage your subscription to SPSSX-L, send a message to [hidden
>> email]
>> <http:///user/SendEmail.jtp?type=node&node=5730879&i=0>
>> (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
>>
>>
>> ------------------------------
>> If you reply to this email, your message will be added to the
>> discussion
>> below:
>>
>> http://spssx-discussion.1045642.n5.nabble.com/HELP-Error-4381-in-colu
>> mn-1-Text-EXECUTE-The-expression-ends-unexpectedly-Execution-of-this-
>> command--tp5730872p5730879.html To unsubscribe from HELP!Error # 4381
>> in column 1. Text: EXECUTE. >The expression ends unexpectedly.
>> >Execution of this command stops., click here
>> <http://spssx-discussion.1045642.n5.nabble.com/template/NamlServle
>> t.jtp?macro=unsubscribe_by_code&node=5730872&code=ZGF2aWQubWF
>> yc29AZ21haWwuY29tfDU3MzA4NzJ8LTkzOTgzMDYxMw==>
>> .
>> NAML
>> <http://spssx-discussion.1045642.n5.nabble.com/template/NamlServle
>> t.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&am
>> p;base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template
>> .NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrum
>> bs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3
>> Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>>





-----
--
Bruce Weaver
[hidden email]
http://sites.google.com/a/lakeheadu.ca/bweaver/

"When all else fails, RTFM."

NOTE: My Hotmail account is not monitored regularly.
To send me an e-mail, please use the address shown above.

--
View this message in context:
http://spssx-discussion.1045642.n5.nabble.com/HELP-Error-4381-in-column-1-Te
xt-EXECUTE-The-expression-ends-unexpectedly-Execution-of-this-command--tp573
0872p5730881.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

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