topic Re: Report with no dataset in SAS Enterprise Guide

Report with no dataset

D_Z_ — Fri, 29 Mar 2013 18:53:02 GMT

Mabye someone can lend some advice here. I am using SAS to run an interval report hourly that auto emails to a dist list.

I run 4 different summary statistics reports, join them into one report report, export them to pdf and email them to a distribution list hourly throughout the day. It's an automated process that i have running on my system.

What is happening is that one of the reports sometimes has an empty dataset, and therefore when the automated process runs, it doesn't generate anything for that statistics summary table and the report ends up with the prior hours information, which is confusing my audience.

Is it possible to force the summary statistics to run even though the dataset is empty, instead of having information from a prior interval? Any suggestions would be helpful.

Thanks,

Dean

Re: Report with no dataset

Tom — Fri, 29 Mar 2013 20:41:20 GMT

Let me see if I understand the problem.

You are generating the report to a file? And since the input is empty the step doesn't run so the file isn't overwritten?

Depends on how you are generating the reports, but in general you should add a step to write a dummy report before the one that makes the real report.

Then if the step doesn't overwrite it they get the dummy report instead of the report from the previous successful run.

Re: Report with no dataset

D_Z_ — Fri, 29 Mar 2013 20:55:03 GMT

Okay... that's makes sense. I am not familiar with how to create that kind of step. Is there a resource that you could recommend that would walk me through that process?

Re: Report with no dataset

Tom — Fri, 29 Mar 2013 22:47:09 GMT

Without seeing how you are currently doing it is hard to make an informed suggestion.

In the old days we would just use a DATA _NULL_ step. For example if you were using PROC REPORT to make the report you could preceed with a data _null_ step.

ods pds file='step1.pdf';

data _null_;

if nobs=0 then do;

file print;

put 'No data for this report';

end;

stop;

set report1 nobs=nobs ;

run;

proc report data=report1 .......

............

ods pdf close ;