/*The data items could be input using macro variables to make this flexible.*/
data Want ; set Have (rename=( pt=SUBJID)); *the dataset with PT and gender ; STUYID= "GSK101A2"; DOMAIN= "DM" ; SiteNo = "G101" ; length USUBJID $ 17; drop siteno gender; USUBJID= catx("-",stuyid,siteno, subjid); SEX= substr(upcase(gender),1,1); run;
proc print data=reqdop ; var stuyid domain usubjid subjid sex; run;
... View more