One (messy) way if you really need to do this:
data PRINT;
if _N_<=NOBS1 then set SASHELP.CLASS nobs=NOBS1;
BL1=' '; BL2=' '; label BL1='00'x BL2='00'x;
if _N_<=NOBS2 then set SASHELP.AIR nobs=NOBS2;
output;
call missing (of _ALL_);
run;
ods excel file='%temp%\file.xls';
proc print noobs label; run;
ods _all_ close;
... View more