I suggest to use the pattern suggested by @ChrisHemedinger in his blog entry Implement BY processing for your entire SAS program. Using this technique, you can run one Proc Report step for each combination followed by a Proc REPORT step for the overall table.   Take a look at the code sample here that illustrates this technique. To avoid to rerun the overall report, it is only run once at the beginning in to a document store and then it is just replayed each time. Have look and try it out.   Please note, I developed this code in Enterprise Guide, so there are no ODS statements for handling the ods destinations, except for the document destination   /* create some sorted sample */ proc sort data=sashelp.cars out=cars_s; by origin type; run; /* create overall report and store it in document store so that this only needs to run once */ ods document name=work.docs(write); title "OverAll"; proc report data=cars_s; column DriveTrain n EngineSize invoice; define driveTrain / group; define engineSize / analysis mean format=comma12.2; define invoice / analysis mean format=comma12.2; rbreak after / summarize; run; title; ods document close; /*proc document name=work.docs;*/ /* list / levels=all;*/ /*run;*/ /*quit;*/ /* take the technique als discussed in this blog entry http://blogs.sas.com/content/sasdummy/2012/03/20/sas-program-by-processing/ and http://blogs.sas.com/content/sasdummy/2012/03/23/improving-on-a-sas-programming-pattern/ */ %macro split; %local nValues i origin type; proc sql noprint; select distinct catx("!", origin, type) as origin_type into :origin_type1 - from cars_s ; %let nValues = &sqlobs; quit; options nobyline; %do i = 1 %to &nValues; %let origin = %scan(&&origin_type&i, 1, !); %let type = %scan(&&origin_type&i, 2, !); %put NOTE: &sysmacroname Processing &i of &nValues &=origin &=type; title "Report for #BYLINE"; proc report data=cars_s; where origin = "&origin" and type = "&type" ; by origin type; column DriveTrain n EngineSize invoice; define driveTrain / group; define engineSize / analysis mean format=comma12.2; define invoice / analysis mean format=comma12.2; rbreak after / summarize; run; title; /* replay the report stored earlier */ proc document name=work.docs; replay \; run; quit; %end; options byline; %mend; %split Bruno   ... View more

You should close the ODS destination that you do not need.   One way is to add ods _all_ close; before your code. This will close any open destination.   To get "normal" out put again, you can open the Listing destination after your code. ods listing;       ... View more

Hi Eva   Have a look at the ODS LAYOUT functionality.   The sample below shows an example, how to use it.   ods html file="c:\temp\sample.html"; ods layout gridded columns=2; ods region; title "title 1"; proc print data=sashelp.class(obs=5); where sex = "F"; run; ods region; title "title 2"; proc print data=sashelp.class(obs=5); where sex = "F"; run; ods region column_span=2; title "title 2"; proc print data=sashelp.cars(obs=10); run; ods layout end; ods html close; ... View more

In order to test for a date like you want to do it, you need to wrap the DATE() function with %SYSFUNC() macro function, have a look at the sample code below:   %macro sample; %let dateVar = 09sep2015; %IF %sysevalf( %sysfunc(DATE()) = "&dateVar"d ) = 1 %THEN %goto exit; %return; %EXIT: %put NOTE: &sysmacroname jumped to EXIT; %mend; %sample The %RETURN statement will end the macro ... View more