topic Re: Run Proc Report only if there are observations in a data set in ODS and Base Reporting

Run Proc Report only if there are observations in a data set

elwayfan446 — Tue, 24 May 2016 15:18:18 GMT

Hello.

I have some code I have found that will generate in a report if there are no observations in a data set. The problem is that this still generates above the report even if there are observations. I would like this to only run if there are no observations

PROC SQL NOPRINT;
SELECT NOBS INTO :Nbr_Obs 
FROM DICTIONARY.TABLES
WHERE LIBNAME= 'work' AND MEMNAME= 'testdataset '
;
QUIT;

DATA NoObs; 
testcolumnname = "No Data Today";
RUN;

PROC REPORT DATA=NoObs;
COLUMN status;
DEFINE status / center;
RUN;

If there are observations, I don't want DATA NoObs or PROC REPORT to RUN.

I have tried playing around with IF statments with no luck. To provide a little color, this is custom code I am adding to an Enterprise Guide Script instide a List Data task that generates the report. I don't think that is necessarily relevant as long as the code I am inserting is right.

Re: Run Proc Report only if there are observations in a data set

PGStats — Tue, 24 May 2016 19:02:43 GMT

I guess you want something like this:

%macro doTestDataSet;
PROC SQL NOPRINT;
SELECT NOBS INTO :Nbr_Obs 
FROM DICTIONARY.TABLES
WHERE LIBNAME= 'work' AND MEMNAME= 'testdataset '
;
QUIT;

%if &Nbr_Obs > 0 %then %do;
    DATA NoObs; 
    testcolumnname = "No Data Today";
    RUN;

    PROC REPORT DATA=NoObs;
    COLUMN status;
    DEFINE status / center;
    RUN;
%end;
%else %do;
    proc report data=testdataset;
    ... whatever ...
    run;
%end;
%mend;

%doTestDataSet;

Re: Run Proc Report only if there are observations in a data set

elwayfan446 — Tue, 24 May 2016 20:29:29 GMT

@PGStats This worked perfectly. Thanks so much!