While Import excel file using Proc Import for few subject# ID I am getting some specific character value. Example below. " 3-158-021" Expecting Subject id should be: 3-158-021 (9 characters) The below SAS code I have used however, it is not working. any help would be appreciated. data Keosys_vdr2;
length SubjectNumber $150;
set Keosys_vdr1 (firstobs=2);
subjectnumber=strip(compress(Subject,'"'));
*subjectnumber1=prxchange('s/\"//',-1,subjectnumber);
keep SiteNumber subjectnumber subjectnumber1 Current_Status;
run;
... View more
