Data Manipulation and GUI

[David Thompson]

I have just joined this list and am seeking some assistance with a data manipulation problem. I have searched the archives and think I know what I want to do, but can't make it work. I am using V. 19 and the GUI (since I can't figure out how to make the syntax windows execute).

Here's my situation:

I have a data set like this, with each subject having one or more records:

ID    X1
1       1
1       1
1       1
2       1
2       1
2       1
3       1
4       1
4       1

I would like to flatten the data set so that each case reads like this:

ID  X1  X2  X3  X...

What's the best way to accomplish this using the GUI?  

Alternatively, if I create a syntax file, how do I make it execute?

Thanks in advance,

David

David W. Thompson, PhD, ABPP
Diplomate in Forensic Psychology
American Board of Professional Psychology

Deputy Director
Walworth Co. Dept. of Health and Human Services
262-741-3232 (voice) 262-741-3217 (fax)

NOTICE OF CONFIDENTIALITY: This e-mail and any files transmitted with it may contain information that is privileged, confidential, and exempt from disclosure under applicable laws. This communication is intended for the sole use of the individual or entity to which it is addressed. Dissemination, forwarding, printing, or copying of this e-mail and any files transmitted with it without the consent of the sender is strictly prohibited. If you have received this e-mail in error, please do not distribute it. Please notify the sender by e-mail at the address shown and delete the original message. Thank you.

[parisec]

Data-Restructure-Cases into variables.

 

 

---

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of David Thompson
Sent: Thursday, October 18, 2012 9:49 AM
To: [hidden email]
Subject: Data Manipulation and GUI

I have just joined this list and am seeking some assistance with a data manipulation problem. I have searched the archives and think I know what I want to do, but can't make it work. I am using V. 19 and the GUI (since I can't figure out how to make the syntax windows execute).

Here's my situation:

I have a data set like this, with each subject having one or more records:

ID    X1
1       1
1       1
1       1
2       1
2       1
2       1
3       1
4       1
4       1

I would like to flatten the data set so that each case reads like this:

ID  X1  X2  X3  X...

What's the best way to accomplish this using the GUI?  

Alternatively, if I create a syntax file, how do I make it execute?

Thanks in advance,

David

David W. Thompson, PhD, ABPP
Diplomate in Forensic Psychology
American Board of Professional Psychology

Deputy Director
Walworth Co. Dept. of Health and Human Services
262-741-3232 (voice) 262-741-3217 (fax)

NOTICE OF CONFIDENTIALITY: This e-mail and any files transmitted with it may contain information that is privileged, confidential, and exempt from disclosure under applicable laws. This communication is intended for the sole use of the individual or entity to which it is addressed. Dissemination, forwarding, printing, or copying of this e-mail and any files transmitted with it without the consent of the sender is strictly prohibited. If you have received this e-mail in error, please do not distribute it. Please notify the sender by e-mail at the address shown and delete the original message. Thank you.

[John F Hall]

David

 

Follow Carole’s advice to get a new version of the data editor, but click on PASTE first to save the syntax.  Inside the syntax file all you have to do is make sure the cursor is inside a command and click on the green triangle to execute it.  In the case of several commands, you can highlight the ones you want to run and then press the triangle.  If you want to run them all, click on Run >> All.

 

Once you get the hang of syntax, you won’t want to use anything else, especially for data manipulation.  It’s so much easier and quicker.  Since you’re new to both SPSS and syntax, have a look at the tutorials on my site (http://surveyresearch.weebly.com/summary-guide-to-spss-tutorials.html ).

 

 

John F Hall (Mr)

 

Email:     [hidden email]

Website: www.surveyresearch.weebly.com

 

 

 

 

 

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Parise, Carol A.
Sent: 18 October 2012 18:57
To: [hidden email]
Subject: Re: Data Manipulation and GUI

 

Data-Restructure-Cases into variables.

 

 

---

From: SPSSX(r) Discussion [[hidden email]] On Behalf Of David Thompson
Sent: Thursday, October 18, 2012 9:49 AM
To: [hidden email]
Subject: Data Manipulation and GUI

I have just joined this list and am seeking some assistance with a data manipulation problem. I have searched the archives and think I know what I want to do, but can't make it work. I am using V. 19 and the GUI (since I can't figure out how to make the syntax windows execute).

Here's my situation:

I have a data set like this, with each subject having one or more records:

ID    X1
1       1
1       1
1       1
2       1
2       1
2       1
3       1
4       1
4       1

I would like to flatten the data set so that each case reads like this:

ID  X1  X2  X3  X...

What's the best way to accomplish this using the GUI?  

Alternatively, if I create a syntax file, how do I make it execute?

Thanks in advance,

David

David W. Thompson, PhD, ABPP
Diplomate in Forensic Psychology
American Board of Professional Psychology

Deputy Director
Walworth Co. Dept. of Health and Human Services
262-741-3232 (voice) 262-741-3217 (fax)

NOTICE OF CONFIDENTIALITY: This e-mail and any files transmitted with it may contain information that is privileged, confidential, and exempt from disclosure under applicable laws. This communication is intended for the sole use of the individual or entity to which it is addressed. Dissemination, forwarding, printing, or copying of this e-mail and any files transmitted with it without the consent of the sender is strictly prohibited. If you have received this e-mail in error, please do not distribute it. Please notify the sender by e-mail at the address shown and delete the original message. Thank you.

[Maguin, Eugene]

READ about the Casestovars command. Then, in data window, use Restructure. After that you are on your own because I always write syntax.

 

Gene Maguin

 

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of David Thompson
Sent: Thursday, October 18, 2012 12:49 PM
To: [hidden email]
Subject: Data Manipulation and GUI

 

I have just joined this list and am seeking some assistance with a data manipulation problem. I have searched the archives and think I know what I want to do, but can't make it work. I am using V. 19 and the GUI (since I can't figure out how to make the syntax windows execute).

Here's my situation:

I have a data set like this, with each subject having one or more records:

ID    X1
1       1
1       1
1       1
2       1
2       1
2       1
3       1
4       1
4       1

I would like to flatten the data set so that each case reads like this:

ID  X1  X2  X3  X...

What's the best way to accomplish this using the GUI?  

Alternatively, if I create a syntax file, how do I make it execute?

Thanks in advance,

David

David W. Thompson, PhD, ABPP
Diplomate in Forensic Psychology
American Board of Professional Psychology

Deputy Director
Walworth Co. Dept. of Health and Human Services
262-741-3232 (voice) 262-741-3217 (fax)

NOTICE OF CONFIDENTIALITY: This e-mail and any files transmitted with it may contain information that is privileged, confidential, and exempt from disclosure under applicable laws. This communication is intended for the sole use of the individual or entity to which it is addressed. Dissemination, forwarding, printing, or copying of this e-mail and any files transmitted with it without the consent of the sender is strictly prohibited. If you have received this e-mail in error, please do not distribute it. Please notify the sender by e-mail at the address shown and delete the original message. Thank you.