topic Re: Mutiple proc prints with title statement within macro-want to see titles only above first table in SAS Programming

Mutiple proc prints with title statement within macro-want to see titles only above first table

Ronein — Mon, 09 Apr 2018 04:30:45 GMT

i have a macro that i run .
The macro creates multiple tables with different names and print them.
Before proc print statement i have titles ststements
The problem is that for each tqble that printed out there are titles.
I want that the titles will appear only appove first printed table.
Any solution to this request?

Re: Mutiple proc prints with title statement within macro-want to see titles only above first table

Ronein — Mon, 09 Apr 2018 04:32:00 GMT

Hello

i have a macro that i run .
The macro creates multiple tables with different names and print them.
Before proc print statement i have titles ststement.
The problem is that for each table that printed out there are titles.
I want that the titles will appear only above first printed table.
Any solution to this request?

Re: Mutiple proc prints with title statement within macro-want to see titles only above first table

Shmuel — Mon, 09 Apr 2018 05:36:54 GMT

Check next skilton:

%let title_flag = 1; /* initiate title flag to be printed */

%macro ....;

%if &title_flag = 1 %then %do;

%let title_flag =0;

title ..... ;

%end; %else %str(title;); /* clear titles */

...... your macro program ......

%mend;

Re: Mutiple proc prints with title statement within macro-want to see titles only above first table

s_lassen — Mon, 09 Apr 2018 10:34:19 GMT

As @Shmuel suggested, use a blank title statement to lear the titles. But I would suggest making the code a bit simpler:

%macro whatever;
  Title '<your inititial title here>';
  %do <assuming you have your print statements in a loop>;
    <proc print statements here>;
    Title;
    %end;
%mend;

In other words, just clear the titles at the end of every iteration; an empty TITLE statement is not very expensive.