Hi
I didn't like offering the absent worksheet as indication there are no exceptions. Better, seemed the idea of a worksheet with one "missing" line. That satisfied the "difficult" client-user. The code involved this brief, but unusual data step. It is executed just before the proc print[pre] option _last_ = dataset.toBePrinted ;
data &syslast ;
if nobs then stop ;
output ;
modify &syslast nobs=nobs ;
output ;
run ; [/pre]
As you see, the step involves almost no data-set specific details, but creates a missing observation. However, it assumes your data set will provide the NOBS information and can be MODIFY-ed.
Perhaps you should try it on yours.
I packaged mine as a SAS macro like:[pre] %macro IFz1(data=&syslast) /des= 'if Zero make 1 obs' ;
data &data ;
if nobs then stop ;
output ;
modify &data nobs=nobs ;
stop ;
run ;
%mend IFz1 ;[/pre]Which is used like[pre] %IFz1( data=mylib.mydataset) ;[/pre]and when it is the latest data set that I need to update, the syntax becomes even simpler[pre] %ifz1 [/pre]
PeterC