1 The SAS System 00:01 Saturday, August 19, 2000 NOTE: Copyright (c) 1999-2000 by SAS Institute Inc., Cary, NC, USA. NOTE: SAS (r) Proprietary Software Release 8.1 (TS1M0) Licensed to UNC-CHAPEL HILL - CAMPUSWIDE INTERNAL, Site 0039466001. NOTE: This session is executing on the WIN_NT platform. NOTE: SAS initialization used: real time 0.26 seconds cpu time 0.24 seconds 1 TITLE1 "P0103.SAS-transpose data, to repeated measures as columns"; 2 3 LIBNAME INOUT01 "..\DATA\"; NOTE: Libref INOUT01 was successfully assigned as follows: Engine: V612 Physical Name: D:\KEM\TEACHING\BIOS262\2000\HOMEWORK\DATA 4 5 DATA INOUT01.P0103; 6 LENGTH DEFAULT=4; 7 RETAIN DLOG_B_1 DLOG_B_2 DLOG_B_3 DLOG_F_1 DLOG_F_2 DLOG_F_3 8 DLOG_M_1 DLOG_M_2 DLOG_M_3 DLOG_P_1 DLOG_P_2 DLOG_P_3; 9 SET INOUT01.P0102; 10 BY ID; 11 12 IF FIRST.ID THEN DO; 13 DLOG_B_1=.; DLOG_B_2=.; DLOG_B_3=.; 14 DLOG_F_1=.; DLOG_F_2=.; DLOG_F_3=.; 15 DLOG_M_1=.; DLOG_M_2=.; DLOG_M_3=.; 16 DLOG_P_1=.; DLOG_P_2=.; DLOG_P_3=.; 17 END; 18 19 IF (TISSUE="Benign") &(TIME=45) THEN DLOG_B_1=DIFFLOG; 20 IF (TISSUE="Benign") &(TIME=90) THEN DLOG_B_2=DIFFLOG; 21 IF (TISSUE="Benign") &(TIME=135) THEN DLOG_B_3=DIFFLOG; 22 IF (TISSUE="Fat") &(TIME=45) THEN DLOG_F_1=DIFFLOG; 23 IF (TISSUE="Fat") &(TIME=90) THEN DLOG_F_2=DIFFLOG; 24 IF (TISSUE="Fat") &(TIME=135) THEN DLOG_F_3=DIFFLOG; 25 IF (TISSUE="Malignant") &(TIME=45) THEN DLOG_M_1=DIFFLOG; 26 IF (TISSUE="Malignant") &(TIME=90) THEN DLOG_M_2=DIFFLOG; 27 IF (TISSUE="Malignant") &(TIME=135) THEN DLOG_M_3=DIFFLOG; 28 IF (TISSUE="Parenchyma")&(TIME=45) THEN DLOG_P_1=DIFFLOG; 29 IF (TISSUE="Parenchyma")&(TIME=90) THEN DLOG_P_2=DIFFLOG; 30 IF (TISSUE="Parenchyma")&(TIME=135) THEN DLOG_P_3=DIFFLOG; 31 32 IF LAST.ID THEN DO; 33 CONSTANT=1; 34 OUTPUT; 35 END; 36 LABEL DLOG_B_1="Difflog Benign 45sec" 2 The SAS System 00:01 Saturday, August 19, 2000 37 DLOG_B_2="Difflog Benign 90sec" 38 DLOG_B_3="Difflog Benign 135sec" 39 DLOG_M_1="Difflog Malignant 45sec" 40 DLOG_M_2="Difflog Malignant 90sec" 41 DLOG_M_3="Difflog Malignant 135sec" 42 DLOG_F_1="Difflog Fat 45sec" 43 DLOG_F_2="Difflog Fat 90sec" 44 DLOG_F_3="Difflog Fat 135sec" 45 DLOG_P_1="Difflog Parenchyma 45sec" 46 DLOG_P_2="Difflog Parenchyma 90sec" 47 DLOG_P_3="Difflog Parenchyma 135 sec"; 48 49 FORMAT DLOG_B_1--DLOG_P_3 5.3; 50 KEEP ID CONSTANT DLOG_B_1--DLOG_P_3; 51 NOTE: There were 99 observations read from the data set INOUT01.P0102. NOTE: The data set INOUT01.P0103 has 10 observations and 14 variables. NOTE: DATA statement used: real time 0.03 seconds cpu time 0.03 seconds 52 PROC PRINT DATA=INOUT01.P0103 UNIFORM ; 53 VAR DLOG_B_1-DLOG_B_3 DLOG_M_1-DLOG_M_3 54 DLOG_P_1-DLOG_P_3 DLOG_F_1-DLOG_F_3 55 CONSTANT ID; NOTE: There were 10 observations read from the data set INOUT01.P0103. NOTE: The PROCEDURE PRINT printed page 1. NOTE: PROCEDURE PRINT used: real time 0.03 seconds cpu time 0.03 seconds NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414 NOTE: The SAS System used: real time 0.35 seconds cpu time 0.32 seconds