Hi all!
Long time programmer here, however, I am stumped!
Why the heck isn't the format retaining the zeros when I have indicated the format type as 'C'? Here is the code :
data subject(keep=siteid start label fmtname usubjid new_id);
length new_id $12;
set db.en end=end;
new_id = substr(usubjid,8,3) || substr(usubjid,4,3) ;
start = new_id;
label = usubjid;
retain fmtname "SubjectFmt" type "C";
output;
if end then do;
hlo = 'O' ;
label = 'ERROR ;
end;
run;
proc format cntlin = subject cntlout = cntlout; run;
proc format library=work; select SubjectFmt; run;
attached are exampled of the dataset and the resulting format.
Thank you!
NJGirl
... View more