Good morning, I have to restructure this data using the repeated statement of PROC GLM or PROC MIXED.  I'm only to do this for LDL cholesterol and include in the model GENDER, LDL_A, LDL_B, LDL_C.  Here's what I have so far:   DATA STATIN; DO SUBJ = 1 TO 20; IF RANUNI (1557) LT .5 THEN GENDER = 'FEMALE'; ELSE GENDER = 'MALE'; IF RANUNI (0) LT .3 THEN DIET = 'HIGH FAT'; ELSE DIET = 'LOW FAT'; DO DRUG = 'A', 'B', 'C'; LDL = ROUND(RANNOR(1557)*20 +110 + 5* (DRUG EQ 'A') - 10*(DRUG EQ 'B') - 5* (GENDER EQ 'FEMALE') + 10*(DIET EQ 'HIGH FAT')); HDL = ROUND(RANNOR(1557)*10 + 20 + .2*LDL + 12*(DRUG EQ 'B')); TOTAL = ROUND(RANNOR (1557)*20 + LDL + HDL + 50 - 10*(GENDER EQ 'FEMALE') + 10*(DIET EQ 'HIGH FAT')); OUTPUT; END; END; RUN; PROC MIXED DATA= STATIN; CLASS SUBJ DRUG; MODEL LDL=DRUG; RANDOM SUBJ; SET STATIN; IF DRUG = 'A'THEN OUTPUT ONE; ELSE IF DRUG = 'B'THEN OUTPUT TWO; ELSE IF DRUG = 'C' THEN OUPUT THREE; PROC SORT DATA = ONE (RENAME=(LDL=LDL_A)); BY SUBJ; PROC SORT DATA = TWO (RENAME=(LDL=LDL_B)); BY SUBJ; PROC SORT DATA = THREE (RENAME=(LDL=LDL_C)); BY SUBJ; DATA MRG; MERGE ONE TWO THREE; BY SUBJ; PROC GLM DATA = MRG; MODEL LDL_A LDL_B LDL_C=/NOUNI; REPEATED DRUG 3 (1 2 3); RUN;  This is the error that I'm getting: NOTE: The SAS System stopped processing this step because of errors. 94 CLASS SUBJ DRUG; 95 MODEL LDL=DRUG; 96 RANDOM SUBJ; 97 SET STATIN; ___ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 98 IF DRUG = 'A'THEN OUTPUT ONE; 99 ELSE IF DRUG = 'B'THEN OUTPUT TWO; 100 ELSE IF DRUG = 'C' THEN OUPUT THREE;     101 PROC SORT DATA = ONE (RENAME=(LDL=LDL_A)); ERROR: File WORK.ONE.DATA does not exist. 102 BY SUBJ; 103 PROC SORT DATA = TWO (RENAME=(LDL=LDL_B)); ERROR: File WORK.TWO.DATA does not exist. 104 BY SUBJ;   NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 353.21k OS Memory 34724.00k Timestamp 10/22/2019 02:22:28 PM Step Count 222 Switch Count 0 Page Faults 0 Page Reclaims 15 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0       105 PROC SORT DATA = THREE (RENAME=(LDL=LDL_C)); ERROR: File WORK.THREE.DATA does not exist. 106 BY SUBJ;   NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 352.43k OS Memory 34724.00k Timestamp 10/22/2019 02:22:28 PM Step Count 223 Switch Count 0 Page Faults 0 Page Reclaims 15 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0       107 DATA MRG; 108 MERGE ONE TWO THREE; ERROR: File WORK.ONE.DATA does not exist. ERROR: File WORK.TWO.DATA does not exist. ERROR: File WORK.THREE.DATA does not exist. 109 BY SUBJ; 110 PROC GLM DATA = MRG; 111 MODEL LDL_A LDL_B LDL_C=/NOUNI; ERROR: Variable LDL_A not found. ERROR: Variable LDL_B not found. ERROR: Variable LDL_C not found. NOTE: The previous statement has been deleted. 112 REPEATED DRUG 3 (1 2 3); 113 RUN;   ERROR: A MODEL statement must be given. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE GLM used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 509.65k OS Memory 34724.00k Timestamp 10/22/2019 02:22:28 PM Step Count 225 Switch Count 0 Page Faults 0 Page Reclaims 15 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0     ... View more

Is there any information on how to create one observation per subject between the first and last visit in SAS data?   Thanks, ... View more

Is there any information on how to compute the difference from one visit to the next in a SAS data? ... View more

Here's my code! When I run the code, I'm not getting any errors or results.  I'm not sure what I did wrong.  The question says to create a new sas data set called AGES that contains all the variables in ABC_CORP plus three new variables.  One is AGE_ACTUAL, which is the exact age from DOB to January 15, 2005.  The second is AGE_TODAY, which is the age as of the date the program is run, rounded to the nearest tenth of the year.  The third is AGE, with the fractional part dropped, as of the date stored in the variable VISIT_DATE.   ***Program to create data set ABC_CORP; DATA ABC_CORP; DO SUBJ = 1 TO 10; DOB = INT(RANUNI(1234)*15000); VISIT_DATE = INT(RANUNI(0)*1000) + '01JAN2000'D; OUTPUT; END; FORMAT DOB VISIT_DATA DATE9.; RUN; ***program to create data set AGES; DATA AGES; AGE_ACTUAL=YRDIF(DOB,'15JAN2005'D,'ACTUAL'); AGE_TODAY= ROUND(YRDIF(DOB,TODAY(),'ACTUAL'),.1); AGE= INT(AGE); VISIT_DATE= INT(RANUNI(0)*1000)+ '01JAN2000'D; RUN;   ... View more