topic Re: Proc report-how to display "No Data" in SAS Programming

Proc report-how to display "No Data"

HitmonTran — Mon, 04 Jan 2021 21:34:27 GMT

I have an rtf output with no current data based on the subset. How do I print text "No Data" in the output along with the table shell in proc report?

current output:

want:

Re: Proc report-how to display "No Data"

novinosrin — Mon, 04 Jan 2021 21:55:40 GMT

Hi @HitmonTran You could try adding a text in a LINE statement within a compute block. Have you tried it?


data w;
 if 0 then set sashelp.class;
 call missing(of _all_);
 output;
 stop;
run;

proc report data=w;
 compute before;
  line 'no data';
 endcomp;
run;

Name	Sex	Age	Height	Weight
no data
		.	.

Re: Proc report-how to display "No Data"

HitmonTran — Wed, 06 Jan 2021 21:36:24 GMT

doesn't work bc i am using a macro and some proc report have data