topic Re: Output just the title from PROC REPORT in ODS and Base Reporting

Output just the title from PROC REPORT

VimalKurup — Tue, 21 Jul 2015 13:49:04 GMT

,Hi,

I am seeking your help in trying to resolve an issue which i am getting while generating the report. Report is generated as a PDF which has a mix of reports(generated using PROC REPORT statements) and text(ODS PDF TXT). When there is data in dataset then we use PROC REPORT to print else use ODS PDF TXT to provide a comment "No data found". There are about 4 datasets that are part of this report.

Sample Pseudocode

ODS PDF FILE= <destination>;

1. Check if data present in dataset - DataA.

If yes

PROC REPORT DATA=DataA;

RUN;

else

ODS PDF TEXT='No data found';

This repeats for the 4 datasets.

Issue that i am facing is-

1. When there is no data present in DataA, the overall title which i want for the report is not getting published. The report starts with the text "No data found".

2. If i were to output the main title as PDF TEXT , then the remainder of the report is coming just as PDF TEXT and not print PROC REPORT outputs.

It would be great if i can just publish the titles when the dataset is empty and move forward. Is there any such means? Or a better suggestion to generate the report in itself.

Thanks in advance,

Vimal

Re: Output just the title from PROC REPORT

Cynthia_sas — Tue, 21 Jul 2015 23:11:59 GMT

Hi:

ODS PDF TEXT= does not trigger a title statement. Only a procedure will trigger a title statement. So you could do something like this instead of your current else branch (shown in pseudocode):

*** new else branch ***

data msg;

length msg $100;

msg="no data found';

run;

title 'The title you want';

proc report data=msg nowd noheader;

column msg;

run;

*** end new else branch ***

cynthia

Re: Output just the title from PROC REPORT

VimalKurup — Thu, 23 Jul 2015 13:42:22 GMT

Hi Cynthia,

Appreciate the time you took in responding to my query. Issue is resolved. I used PROC REPORT more or less similar to the one in your response.

Once again, Thanks !

Vimal

Re: Output just the title from PROC REPORT

RW9 — Thu, 23 Jul 2015 13:49:48 GMT

As Cynthia has stated, just add a step to check this. Myself I generally do something like:

proc sql;

create table TEST (a char(20),b num);

quit;

data _null_;

set sashelp.vtable (where=(libname="WORK" and memname="TEST" and nobs=0));

call execute('data test; msg="No data found"; output; run;'); /* will only be called if the dataset has 0 observations */

run;

Re: Output just the title from PROC REPORT

VimalKurup — Fri, 31 Jul 2015 13:43:21 GMT

Thank you RW9

Re: Output just the title from PROC REPORT

NWV — Thu, 14 Jul 2016 15:48:25 GMT

I realize this is an old thread....would it be possible to see full example code for something like this? I have an ODS RTF report file I am creating for ~50 projects by macro. There are 10 tables in each RTF report. All created in proc print statements and controlling for labels, header alignment, etc., and it works fine. EXCEPT, when one of the proc prints with a "where" statement resolves to no observations. I still want the proc print titles to appear but there wouldn't be any table below it. How can I trigger the titles if no data is retrieved by proc print? Thank you.

Re: Output just the title from PROC REPORT

Cynthia_sas — Thu, 14 Jul 2016 19:56:46 GMT

It doesn't matter whether you are talking about PROC REPORT or PROC PRINT, the code example shown in 2015 is the type of code you need to use. You cannot trigger just a title without SOMETHING else on the page. So making a dataset with an "error" message in the event of a WHERE that returns 0 obs is something you will have to code for.

cynthia

Re: Output just the title from PROC REPORT

NWV — Fri, 15 Jul 2016 11:50:41 GMT

Thank you.