Output in one page

[deleted_user]

Hi All,

I use the code-

/*Create Table with mean of each column*/
PROC TABULATE DATA=Test_Model=8.3;
CLASS A B;
VAR C D;
Table A*(C D)*(Mean STD MAX MIN)
,
B ALL='Mean';
RUN;

The code runs well but I get the output in two pages and I am trying to find out how to output be in one page.

Kindly suggest.

Regards,
Mark

[Cynthia_sas]

Hi:
What is your ODS destination of choice? Have you tried system option like ORIENTATION=LANDSCAPE??? ODS HTML output can be as wide as it needs to be, while ODS PDF and ODS RTF output must fit within the margins set by system options and thus, could span multiple pages. If you are interested in the LISTING destination, then, in addition to the ORIENTATION option, you might try setting LINESIZE and PAGESIZE options -- ORIENTATION, LINESIZE and PAGESIZE are SAS system options which are well documented.

Of these 3 options, only ORIENTATION works for LISTING, PDF and RTF. ORIENTATION is irrelevant to ODS HTML and LINESIZE and PAGESIZE are ignored by any destination except for LISTING.

I suspect you will have an issue with your PROC TABULATE code. Although you say the code runs well, the construction,DATA=Test_Model=8.3, is incorrect syntax and you should be seeing an ERROR message in the SAS log:
[pre]
528 PROC TABULATE DATA=Test_Model=8.3;
-
22
76
ERROR 22-322: Syntax error, expecting one of the following: ALPHA,
DEPTH, FORMAT.
ERROR 76-322: Syntax error, statement will be ignored.

[/pre]

cynthia