data ds2d(keep=subjid patnum usubjid); set ivdata; set dmdata; run; proc sql; create table dsdt(keep= usubjid) as select dms.patnum dms.usubjid dms.subjid from ds2d as dms where dms.patnum=input(dms.subjid,8.); run; where condition doesn't satisfied. In short, I want to set dsdt.usubjid as ds2d.usubjid where ds2d.patnum(Numeric data type) and ds2d.subjid(character datatype) must be same.
... View more
