Formatting proc tabulate

Hi I have the following code in sas . I would like to create multiple tables like this one but one main title and then each table with its own subtitle. Is there a way i can do this?

Also, i need to remove the date and run information that is presented adjacent to title by default.


data mydata;
input id txn;
datalines;
01 10 
02 11 
03 111 
;;
run;

proc tabulate data=mydata missing;
class id;
var txn ;
table id ALL, (SUM=''*txn='Sum of txn' MEAN=''*txn='Mean of txn' N=''*txn='Count of txn') / ROW=FLOAT;
TITLE1 'SECTION ONE';
TITLE2 'FIRST TRANSACTIONS'
run

Open in new window

LuckyLucksAsked:
Who is Participating?
 
tobey1Commented:
Here is what I would do to address the Constant Title1 and Changing Title 2

data mydata;
input id txn;
datalines;
01 10
02 11
03 111
;;
run;

TITLE1 'SECTION ONE';

proc tabulate data=mydata missing;
class id;
var txn ;
table id ALL, (SUM=''*txn='Sum of txn' MEAN=''*txn='Mean of txn' N=''*txn='Count of txn') / ROW=FLOAT;
TITLE2 'FIRST TRANSACTIONS';
run;

proc tabulate data=mydata missing;
class id;
var txn ;
table id ALL, (SUM=''*txn='Sum of txn' MEAN=''*txn='Mean of txn' N=''*txn='Count of txn') / ROW=FLOAT;
TITLE2 'SECOND TRANSACTIONS';
run;

etc.
By leaving TITLE1 Static and only declared once, it will remain constant.  You can do this for multiple titles (top down).  Then you can make TITLE2 whatever you need to define your report.

As for removing the date put this at the start of your SAS code:  OPTION NODATE;

Let me know if that is what you where looking for.
0
 
tobey1Commented:
to get ride of the date and page number use the following:
option nodate nonumber;
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.