Open selected variables/cases in new dataset

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

Open selected variables/cases in new dataset

Darko_Giac
Hi all,

I am attempting to determine a select if function (or other syntax) that would select certain variables and cases, remove them from my existing data set, and transfer/open them into a new dataset.

Any help would be appreciated.

Thanks!
Reply | Threaded
Open this post in threaded view
|

Re: Open selected variables/cases in new dataset

Bruce Weaver
Administrator
One approach would be to make two copies of the original dataset, activate each copy in turn and get rid of any variables and cases you don't want in that copy.  Commands to look up:

DATASET NAME
DATASET COPY
DATASET ACTIVATE
DELETE VARIABLES
SELECT

Here's a very basic example from the DATASET COPY entry in the Command Syntax Reference manual (aka., the FM):

DATASET NAME original.
DATASET COPY males.
DATASET ACTIVATE males.
SELECT IF gender=0.
DATASET ACTIVATE original.
DATASET COPY females.
DATASET ACTIVATE females.
SELECT IF gender=1.

HTH.
--
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: Open selected variables/cases in new dataset

Art Kendall
From you posts it appears that you may be new to SPSS so a reminder.

An analysis is a series of drafts like any other writing.  As you learn more about analysis, about SPSS, and about your data you will redraft your syntax. Be sure that you make sure that you can go back and do things according to your revised thinking. Be sure that you save your original data and all of the latest versions of syntax files.

For example, you may have to rewrite the syntax for creating the 2 new files the way you come to want them.


Art Kendall
Social Research Consultants
Reply | Threaded
Open this post in threaded view
|

Re: Open selected variables/cases in new dataset

Maguin, Eugene
In reply to this post by Darko_Giac
I'm just curious because this question of yours has been replied to and reposted several times over the past few days. You've gotten replies; how have those replies been inadequate? Gene Maguin

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Darko_Giac
Sent: Tuesday, October 18, 2016 7:11 PM
To: [hidden email]
Subject: Open selected variables/cases in new dataset

Hi all,

I am attempting to determine a select if function (or other syntax) that would select certain variables and cases, remove them from my existing data set, and transfer/open them into a new dataset.

Any help would be appreciated.

Thanks!




--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Open-selected-variables-cases-in-new-dataset-tp5733304.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
Reply | Threaded
Open this post in threaded view
|

Re: Open selected variables/cases in new dataset

Jon Peck
Darko_Giac,

You have been posting the same question to multiple groups, and many of your questions have been similar to others that you have posted.  I suggest that in order to save everybody time, you post only to one site at a time and that you spend some time trying to figure out the answer before posting.  Post if  you really get stuck.

On Wed, Oct 19, 2016 at 8:07 AM, Maguin, Eugene <[hidden email]> wrote:
I'm just curious because this question of yours has been replied to and reposted several times over the past few days. You've gotten replies; how have those replies been inadequate? Gene Maguin

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Darko_Giac
Sent: Tuesday, October 18, 2016 7:11 PM
To: [hidden email]
Subject: Open selected variables/cases in new dataset

Hi all,

I am attempting to determine a select if function (or other syntax) that would select certain variables and cases, remove them from my existing data set, and transfer/open them into a new dataset.

Any help would be appreciated.

Thanks!




--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Open-selected-variables-cases-in-new-dataset-tp5733304.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



--
Jon K Peck
[hidden email]

===================== 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: Open selected variables/cases in new dataset

David Marso
Administrator
Like take a few hours to RTFM?
I guess I'm not the only person becoming annoyed?
----
Jon Peck wrote
Darko_Giac,

You have been posting the same question to multiple groups, and many of
your questions have been similar to others that you have posted.  I suggest
that in order to save everybody time, you post only to one site at a time
and that you spend some time trying to figure out the answer before
posting.  Post if  you really get stuck.

On Wed, Oct 19, 2016 at 8:07 AM, Maguin, Eugene <[hidden email]> wrote:

> I'm just curious because this question of yours has been replied to and
> reposted several times over the past few days. You've gotten replies; how
> have those replies been inadequate? Gene Maguin
>
> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
> Darko_Giac
> Sent: Tuesday, October 18, 2016 7:11 PM
> To: [hidden email]
> Subject: Open selected variables/cases in new dataset
>
> Hi all,
>
> I am attempting to determine a select if function (or other syntax) that
> would select certain variables and cases, remove them from my existing data
> set, and transfer/open them into a new dataset.
>
> Any help would be appreciated.
>
> Thanks!
>
>
>
>
> --
> View this message in context: http://spssx-discussion.
> 1045642.n5.nabble.com/Open-selected-variables-cases-in-
> new-dataset-tp5733304.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
>



--
Jon K Peck
[hidden email]

=====================
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?"
Reply | Threaded
Open this post in threaded view
|

Re: Open selected variables/cases in new dataset

John F Hall
Darko_Giac

We're not here to do homework exercises, if that's what you have.  
It helps if you give examples of what you have now and what you want
afterwards.  
As well as the FM it may help you to read my tutorial:
http://surveyresearch.weebly.com/uploads/2/9/9/8/2998485/2.3.1.1b_data
_transformations.pdf

John F Hall (Mr)
[Retired academic survey researcher]

Email:   [hidden email]  
Website: www.surveyresearch.weebly.com
SPSS start page:
www.surveyresearch.weebly.com/1-survey-analysis-workshop
-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf
Of David Marso
Sent: 19 October 2016 16:44
To: [hidden email]
Subject: Re: Open selected variables/cases in new dataset

Like take a few hours to RTFM?
I guess I'm not the only person becoming annoyed?
----

Jon Peck wrote
> Darko_Giac,
>
> You have been posting the same question to multiple groups, and many

> of your questions have been similar to others that you have posted.
I
> suggest that in order to save everybody time, you post only to one
> site at a time and that you spend some time trying to figure out the

> answer before posting.  Post if  you really get stuck.
>
> On Wed, Oct 19, 2016 at 8:07 AM, Maguin, Eugene &lt;

> emaguin@

> &gt; wrote:
>
>> I'm just curious because this question of yours has been replied to

>> and reposted several times over the past few days. You've gotten
>> replies; how have those replies been inadequate? Gene Maguin
>>
>> -----Original Message-----
>> From: SPSSX(r) Discussion [mailto:

> SPSSX-L@.UGA

> ] On Behalf Of
>> Darko_Giac
>> Sent: Tuesday, October 18, 2016 7:11 PM
>> To:

> SPSSX-L@.UGA

>> Subject: Open selected variables/cases in new dataset
>>
>> Hi all,
>>
>> I am attempting to determine a select if function (or other syntax)

>> that would select certain variables and cases, remove them from my
>> existing data set, and transfer/open them into a new dataset.
>>
>> Any help would be appreciated.
>>
>> Thanks!
>>
>>
>>
>>
>> --
>> View this message in context: http://spssx-discussion.
>> 1045642.n5.nabble.com/Open-selected-variables-cases-in-
>> new-dataset-tp5733304.html
>> Sent from the SPSSX Discussion mailing list archive at Nabble.com.
>>
>> =====================
>> To manage your subscription to SPSSX-L, send a message to
>>

> LISTSERV@.UGA

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

> LISTSERV@.UGA

>  (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
>>
>
>
>
> --
> Jon K Peck

> jkpeck@

>
> =====================
> To manage your subscription to SPSSX-L, send a message to

> LISTSERV@.UGA

>  (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?"
--
View this message in context:
http://spssx-discussion.1045642.n5.nabble.com/Open-selected-variables-
cases-in-new-dataset-tp5733304p5733317.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
Reply | Threaded
Open this post in threaded view
|

Re: Open selected variables/cases in new dataset

Bruce Weaver
Administrator
In reply to this post by David Marso
Things could always be worse, David.  At least you're not becoming a Noid.  

    https://www.youtube.com/watch?v=bri0SA7FTf4


David Marso wrote
Like take a few hours to RTFM?
I guess I'm not the only person becoming annoyed?
----

--
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: Open selected variables/cases in new dataset

DKUKEC

Did you notice the instantly dated declaration after the ad?  Just saying… too funny.

 

Cheers

d

 

From: Bruce Weaver [via SPSSX Discussion] [mailto:ml-node+[hidden email]]
Sent: Wednesday, October 19, 2016 2:28 PM
To: Damir Kukec <[hidden email]>
Subject: Re: Open selected variables/cases in new dataset

 

Things could always be worse, David.  At least you're not becoming a Noid.  

    https://www.youtube.com/watch?v=bri0SA7FTf4

David Marso wrote

Like take a few hours to RTFM?
I guess I'm not the only person becoming annoyed?
----

 

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

 


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

http://spssx-discussion.1045642.n5.nabble.com/Open-selected-variables-cases-in-new-dataset-tp5733304p5733321.html

To start a new topic under SPSSX Discussion, email [hidden email]
To unsubscribe from SPSSX Discussion, click here.
NAML




Under Florida law, e-mail addresses are public records. If you do not want your e-mail address released in response to a public records request, do not send electronic mail to this entity. Instead, contact this office by phone or in writing.