Data formatting Question

[David Thompson]

Colleagues:

I have a data set of the form:

ID DATE V1 V2 V3
ID DATE V1 V2 V3
ID DATE V1 V2 V3
ID DATE V1 V2 V3
 
I would like to transform it to the form:

ID DATE1 V11 V21 V31 DATE2 V12 V22 V32 DATE3 V13 V23 V33
Etc.

Is there an easy way to accomplish this?

Might I find the guidance I need in an manual rather than bothering this list with such things? If so, where?

TIA,

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]

(Not to be snarky) Indeed, one might find enlightenment in the manual.

 

Casestovars!

 

Gene Maguin

 

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of David Thompson
Sent: Thursday, December 27, 2012 3:34 PM
To: [hidden email]
Subject: Data formatting Question

 

Colleagues:

I have a data set of the form:

ID DATE V1 V2 V3
ID DATE V1 V2 V3
ID DATE V1 V2 V3
ID DATE V1 V2 V3
 
I would like to transform it to the form:

ID DATE1 V11 V21 V31 DATE2 V12 V22 V32 DATE3 V13 V23 V33
Etc.

Is there an easy way to accomplish this?

Might I find the guidance I need in an manual rather than bothering this list with such things? If so, where?

TIA,

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.