/********************************************************************* FILENAME: PAIR2IND.SAS SUBJECT HEADING: DATA INITIALS: KBW DATE: 7/26/96 PROGRAM: SAS VERSION: 6.11 PLATFORM: WINDOWS 3.11 TS040 TITLE: CHANGING DATA STRUCTURE FROM PAIRED CASES TO INDIVIDUAL CASES DESCRIPTION: THIS PROGRAM CHANGES THE STRUCTURE OF THE ORIGINAL DATA SET FROM BEING PAIRED, I.E. ONE IN WHICH EACH CASE REPRESENTS DATA FOR A MATCHED OR CORRELATED PAIR, SUCH AS A HUSBAND AND WIFE, TESTS AT TIME1 AND TIME2, ETC. THE SECOND DATA SET IS ARRANGED SO THAT EACH CASE REPRESENTS ONE MEMBER OF THE PAIR, AND THE IDENTITY OF THE PAIR IS RETAINED. INFORMATION ON WHETHER THE VALUE WAS ORIGINALLY Y1 OR Y2 IS RETAINED IN THE VARIABLE GROUP. **********************************************************************/ data test; input y1 y2 pair; datalines; 13 15 1 12 14 2 17 17.2 3 14 18 4 11 12 5 5 4.1 6 7 9.3 7 ; proc print data=test; title 'printout of original data set'; data test2(keep=y pair group); set test; y=y1; group=1; output; y=y2; group=2; output; run; proc print data=test2; title 'rearranged data'; run; ____________________________________________________________________________ Kathy Welch Center for Statistical Consultation and Research (CSCAR) The University of Michigan phone: 313-764-7828 106 Rackham Building fax: 313-747-2440 Ann Arbor, MI 48109-1070 e-mail: kwelch@umich.edu _____________________________________________________________________________