understand transformations

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

understand transformations

Moon Kid
I thinkt "transformations" are a concept that I don't understand right.
Maybe you can help me to understand the conecpt and change my way of
thinking how to handle data with SPSS. ;)

I have 6 oberservations. And I want to do this by "Syntax" (means a
Script with SPSS-own-language):

COMPUTE v04von = TIME.HMS(v04vh,v04vm,0).

Nothing happens. Just a "outstanding transformations" message appear
and I have to click (oh my good!) "run transformations" in a menu.

The nice thing is that I don't have to code a construct to iterate over
all observations. How can I execute the transformation by script? I
don't want to click.

And just for the future: How could I do such an operation over a
selection of the observations. Maybe just the observertions ver vX=7.

Thank you very much for your help.
btw: You will be appear in the thank-you-area of my work. ;)

=====================
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: understand transformations

Bruce Weaver
Administrator
Add an EXECUTE command, or a procedure that causes a data pass.  E.g.,

COMPUTE v04von = TIME.HMS(v04vh,v04vm,0).
EXECUTE.

or...

COMPUTE v04von = TIME.HMS(v04vh,v04vm,0).
DESCRIPTIVES v04von.



Moon Kid wrote
I thinkt "transformations" are a concept that I don't understand right.
Maybe you can help me to understand the conecpt and change my way of
thinking how to handle data with SPSS. ;)

I have 6 oberservations. And I want to do this by "Syntax" (means a
Script with SPSS-own-language):

COMPUTE v04von = TIME.HMS(v04vh,v04vm,0).

Nothing happens. Just a "outstanding transformations" message appear
and I have to click (oh my good!) "run transformations" in a menu.

The nice thing is that I don't have to code a construct to iterate over
all observations. How can I execute the transformation by script? I
don't want to click.

And just for the future: How could I do such an operation over a
selection of the observations. Maybe just the observertions ver vX=7.

Thank you very much for your help.
btw: You will be appear in the thank-you-area of my work. ;)

=====================
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
--
Bruce Weaver
bweaver@lakeheadu.ca
http://sites.google.com/a/lakeheadu.ca/bweaver/

"When all else fails, RTFM."

PLEASE NOTE THE FOLLOWING: 
1. My Hotmail account is not monitored regularly. To send me an e-mail, please use the address shown above.
2. The SPSSX Discussion forum on Nabble is no longer linked to the SPSSX-L listserv administered by UGA (https://listserv.uga.edu/).
Reply | Threaded
Open this post in threaded view
|

Re: understand transformations

Jon K Peck
In reply to this post by Moon Kid
Statistics does lazy evaluation of transformations.  That means that they are executed the next time the data has to be passed such as with SAVE or a statistical procedure.  This saves a usually unnecessary data pass just for the transformations.  However, if you want to see the results in the Data Editor right away, you can include an EXECUTE command at the end of your transformation block.

As for conditionally executing transformations, see DO IF.


Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
phone: 720-342-5621




From:        Moon Kid <[hidden email]>
To:        [hidden email],
Date:        03/29/2014 03:21 AM
Subject:        [SPSSX-L] understand transformations
Sent by:        "SPSSX(r) Discussion" <[hidden email]>




I thinkt "transformations" are a concept that I don't understand right.
Maybe you can help me to understand the conecpt and change my way of
thinking how to handle data with SPSS. ;)

I have 6 oberservations. And I want to do this by "Syntax" (means a
Script with SPSS-own-language):

COMPUTE v04von = TIME.HMS(v04vh,v04vm,0).

Nothing happens. Just a "outstanding transformations" message appear
and I have to click (oh my good!) "run transformations" in a menu.

The nice thing is that I don't have to code a construct to iterate over
all observations. How can I execute the transformation by script? I
don't want to click.

And just for the future: How could I do such an operation over a
selection of the observations. Maybe just the observertions ver vX=7.

Thank you very much for your help.
btw: You will be appear in the thank-you-area of my work. ;)

=====================
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: understand transformations

David Marso
Administrator
In reply to this post by Bruce Weaver
BUT!
Please delete any EXECUTE statements from all production code (Except in very special circumstances)!
eg. Ts involving SELECT after LAG or references to $CASENUM.
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: understand transformations

Moon Kid
On 2014-03-29 05:52 David Marso <[hidden email]> wrote:
> BUT!
> Please delete any EXECUTE statements from all production code (Except
> in very special circumstances)!
> eg. Ts involving SELECT after LAG or references to $CASENUM.

Can you explain why?

=====================
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: understand transformations

David Marso
Administrator
Can you indicate a reason why you wouldn't?
RTFM on the EXECUTE command, $CASENUM and LAG.
Briefly: EXECUTE passes the data.  You really don't want that if you have a large file.
$CASENUM is dynamic. SELECT IF based on $CASENUM can/will yield incorrect results if not done carefully.
LAG similar in that regard.
I will leave it to you to experiment and perhaps achieve a glimmer of enlightenment in these regards.
Have you bothered yet to read the Universals section of the FM as several have previously suggested?

Moon Kid wrote
On 2014-03-29 05:52 David Marso <[hidden email]> wrote:
> BUT!
> Please delete any EXECUTE statements from all production code (Except
> in very special circumstances)!
> eg. Ts involving SELECT after LAG or references to $CASENUM.

Can you explain why?

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