Hi All, please can this programme below be converted to Proc SQL   Data A; Set B;   retain EXPC1FL EXPC2FL EXPC3FL TRTPFSDT TRTPLSDT EXPDOSE EXPCYCN; format EXPC1FL EXPC2FL EXPC3FL $1. TRTPFSDT TRTPLSDT DATE9. EXPDUR EXPCYCN EXPDOSE 8. EXPCOMP 4.1; by usubjid visitnum; if first.usubjid then do; EXPC1FL=' '; EXPC2FL=' '; EXPC3FL=' '; TRTPFSDT=.; TRTPLSDT=.; EXPDOSE=0; EXPCYCN=0; end; EXPDOSE=EXPDOSE+ECDOSE; EXPCYCN=EXPCYCN+1; if visitnum=10 then EXPC1FL='Y'; if visitnum=20 then EXPC2FL='Y'; if visitnum=30 then EXPC3FL='Y'; if visitnum=10 then TRTPFSDT=TRTPSDT; if last.usubjid then TRTPLSDT=TRTPEDT; if last.usubjid; EXPCOMP=(EXPDOSE/250)*40; EXPDUR=(TRTPLSDT - TRTPFSDT)+1;   regards Queen ... View more