I'm sorry, I'm not sure what you mean by flags. Here's a sample data set. As you can see, some outcomes are missing until the third observation on the same person. I would need to find the means each outcome the first time it is recorded in each individual. DATA WORK.SOURCE; INFILE DATALINES DELIMITER= ',' DSD MISSOVER; INPUT SubjID TxGrp :$5. SexCd :$1. EthCd Outcome1 Outcome2 Outcome3; DATALINES; 101,Arm A,F,1,45,, 101,Arm A,F,1,,3,2 101,Arm A,F,1,43,4, 102,Arm C,M,1,,5,, 102,Arm C,M,1,,4,3 102,Arm B,M,2,32,2,5 ;
... View more