hi ... another suggestion ... at the start of the job, instead of this ...
Data WORK.CLINICAL_test;
Set WORK.CLINICAL;
Proc Sort Data=WORK.CLINICAL_test;
by ID RID VISCODE_NEW CMMED_NEW;
Run;
how about this ...
Proc Sort data=work.clinical out=WORK.CLINICAL_test;
by ID RID VISCODE_NEW CMMED_NEW;
Run;
it eliminates an unnecessary pass through the data in that data step
... View more