Proc Tabulate Query

scb — Tue, 03 Sep 2019 16:18:24 GMT

May I know how to make the proc report data appear in page1 instead of page2? I run the below codes; but the proc report data output appeared on page2, not on page1 after the ods text. Can anyone help? Thank you very much.

ods pdf file='c:\sastest\test.pdf' style=minimal;

proc tabulate data=sashelp.cars format=dollar14.2;
class type; var invoice msrp; table type, msrp invoice msrp*pctsum<invoice>='Ratio of MSRP to Invoice'*f=8.2;
run;

ODS TEXT = "TRANSACTION RECORDS";

PROC REPORT DATA=SASHELP.CARS(Where=(Make='Volvo')) style(header)=[background=tan] NOWINDOWS HEADLINE HEADSKIP;
COLUMNS MAKE MODEL INVOICE;
DEFINE MAKE /GROUP 'Car Brand';
DEFINE MODEL /GROUP 'Car Model';
DEFINE INVOICE / ANALYSIS 'INVOICE' FORMAT=DOLLAR16.2;

RBREAK AFTER/ SUMMARIZE;

RUN;

ODS PDF CLOSE;
ODS LISTING;

Re: Proc Tabulate Query

Reeza — Tue, 03 Sep 2019 16:53:27 GMT

Look at the STARTPAGE option on the ODS PDF statement - specifically note what the default option is compared to what you want.

@scb wrote:

May I know how to make the proc report data appear in page1 instead of page2? I run the below codes; but the proc report data output appeared on page2, not on page1 after the ods text. Can anyone help? Thank you very much.

ods pdf file='c:\sastest\test.pdf' style=minimal;

proc tabulate data=sashelp.cars format=dollar14.2;
class type; var invoice msrp; table type, msrp invoice msrp*pctsum<invoice>='Ratio of MSRP to Invoice'*f=8.2;
run;

ODS TEXT = "TRANSACTION RECORDS";

PROC REPORT DATA=SASHELP.CARS(Where=(Make='Volvo')) style(header)=[background=tan] NOWINDOWS HEADLINE HEADSKIP;
COLUMNS MAKE MODEL INVOICE;
DEFINE MAKE /GROUP 'Car Brand';
DEFINE MODEL /GROUP 'Car Model';
DEFINE INVOICE / ANALYSIS 'INVOICE' FORMAT=DOLLAR16.2;

RBREAK AFTER/ SUMMARIZE;

RUN;

ODS PDF CLOSE;
ODS LISTING;

topic Proc Tabulate Query in SAS Programming

Proc Tabulate Query

Re: Proc Tabulate Query