Guys Finally i got the output i am not removing it, If any one in Future happens to Stumble up on it. data dm1; input PT Gender$; datalines; 101 Male 102 M 103 Female 104 MALE 105 f ; run; Data DM; STUDYID="GSK101A2"; DOMAIN="DM"; SITEID="G101"; length USUBJID $20. ; set dm1(rename= (PT=SUBJID)); USUBJID= catx("-",STUDYID,SITEID,SUBJID); If Gender in('M','Male','MALE') then SEX='M'; else SEX='F'; drop Gender; run;
... View more