topic Re: ods pdf file fit on one page in ODS and Base Reporting

ods pdf file fit on one page

JHE — Thu, 04 May 2017 12:58:20 GMT

I need have pdf file fit all the columns on one padge.

The code would not working, do no tknow why, need help. which option I should use to make it fit on one page.

options orientation=landscape pdfpageview=FITPAGE nocenter ;

ods pdf file="/mnt/nfs/prod/Sched/OpsDeptData/Operations/Reports/TPL_Membership_Summary_05042017.pdf";

PROC REPORT DATA=TPLMEM.TPL_SUMMARY_0100;

COLUMN MONTH Category OVERALL_MEMBERSHIP TPL MEDICARE MEDICARE_SUPPLEMENTAL MEDICARE_A MEDICARE_B MEDICARE_AB MEDICARE_ADVANTAGE COMMERCIAL VISION DENTAL LIMITED_BENEFITS Casualty PHARMACY;

DEFINE MONTH/GROUP;

DEFINE MONTH/ORDER descending;

title " LOB 0100 TPL Membership" ;

footnote" Run at &sDay &stime" ;

RUN;

ods pdf close;

Re: ods pdf file fit on one page

RW9 — Thu, 04 May 2017 13:07:33 GMT

You need to provide the information to SAS to get information to fit on a page, e.g.

ods pdf file="...";
proc report data=yourdata;
  column month category ...;
  define month / group style(column)={cellwidth=3cm};
  ...;
run;

Note the use of style()=, you can set all kinds of things here, cellwidth shows how wide the column would be (in this case in cm). Make sure all your columns widths add up to the width of the page and your columns will all fit on one page. Page breaking however is a totally different question (then you need an algorithm to work out how many rows per page to be displayed).

Re: ods pdf file fit on one page

JHE — Thu, 04 May 2017 13:18:02 GMT

Thank you. I am goign to try

Re: ods pdf file fit on one page

Cynthia_sas — Thu, 04 May 2017 13:19:04 GMT

Hi:
Scott Huntley and I discussed wide output in our paper: https://support.sas.com/resources/papers/proceedings14/SAS038-2014.pdf and showed other STYLE= techniques.

cynthia

Re: ods pdf file fit on one page

JHE — Thu, 04 May 2017 13:32:56 GMT

Thank you. Trying

Re: ods pdf file fit on one page

Ksharp — Thu, 04 May 2017 14:11:41 GMT

Add one option to make pdf as big as to hold all variables.

option papersize=(100in 100in) ;

Re: ods pdf file fit on one page

JHE — Thu, 04 May 2017 15:08:00 GMT

thank you

Re: ods pdf file fit on one page

JHE — Thu, 04 May 2017 15:13:07 GMT

This works!

Thank you !

ods listing close;

options orientation=landscape papersize=(100in 100in)

nonumber topmargin=.25in bottommargin=.25in

leftmargin=.25in rightmargin=.25in;

ods escapechar='^';

ods pdf file="/mnt/nfs/prod/Sched/OpsDeptData/Operations/Reports/TPL_Membership/Summary/TPL_Membership_Summary.pdf";

PROC REPORT DATA=TPLMEM.TPL_SUMMARY_0100;

COLUMN MONTH Category OVERALL_MEMBERSHIP TPL MEDICARE MEDICARE_SUPPLEMENTAL MEDICARE_A MEDICARE_B MEDICARE_AB MEDICARE_ADVANTAGE COMMERCIAL VISION DENTAL LIMITED_BENEFITS Casualty PHARMACY;

DEFINE MONTH/GROUP;

DEFINE MONTH/ORDER descending;

title " LOB 0100 TPL Membership" ;

footnote" Run at &sDay &stime" ;

RUN;

ods pdf close;

Re: ods pdf file fit on one page

JHE — Thu, 04 May 2017 15:21:37 GMT

if Need put mutiple report for same PDF file, but would be mutiple page, this would not working.

ods listing close;

options orientation=landscape papersize=(100in 100in)

nonumber topmargin=.25in bottommargin=.25in

leftmargin=.25in rightmargin=.25in;

ods escapechar='^';

ods pdf file="/mnt/nfs/prod/Sched/OpsDeptData/Operations/Reports/TPL_Membership/Summary/TPL_Membership_Summary.pdf";

PROC REPORT DATA=TPLMEM.TPL_SUMMARY_0100;

COLUMN MONTH Category OVERALL_MEMBERSHIP TPL MEDICARE MEDICARE_SUPPLEMENTAL MEDICARE_A MEDICARE_B MEDICARE_AB MEDICARE_ADVANTAGE COMMERCIAL VISION DENTAL LIMITED_BENEFITS Casualty PHARMACY;

DEFINE MONTH/GROUP;

DEFINE MONTH/ORDER descending;

title " LOB 0100 TPL Membership" ;

footnote" Run at &sDay &stime" ;

RUN;

options orientation=landscape papersize=(100in 100in)

nonumber topmargin=.25in bottommargin=.25in

leftmargin=.25in rightmargin=.25in;

ods escapechar='^';

PROC REPORT DATA=TPLMEM.TPL_SUMMARY_0500;

COLUMN MONTH Category OVERALL_MEMBERSHIP TPL MEDICARE MEDICARE_SUPPLEMENTAL MEDICARE_A MEDICARE_B MEDICARE_AB MEDICARE_ADVANTAGE COMMERCIAL VISION DENTAL LIMITED_BENEFITS Casualty PHARMACY;

DEFINE MONTH/GROUP;

DEFINE MONTH/ORDER descending;

title "LOB 0500 TPL Membership";

footnote" Run at &sDay &stime" ;

RUN;

ods pdf close;

Re: ods pdf file fit on one page

Cynthia_sas — Thu, 04 May 2017 16:29:06 GMT

Hi:
If you know that both reports will fit on one physical page, one after the other, then you can use the STARTPAGE=NO option, like this (using PROC FREQ and PROC MEANS because I know that both tables will fit on 1 landscape page):

options orientation=landscape;

ods pdf file='c:\temp\use_startpage.pdf' startpage=no;
proc freq data=sashelp.class;
  tables age;
run;

proc means data=sashelp.class n min mean median;
  var height;
  class sex;
run;
ods pdf close;

Results:

cynthia

Re: ods pdf file fit on one page

JHE — Thu, 04 May 2017 17:23:24 GMT

Thank you ! it works! Wonderful.

Re: ods pdf file fit on one page

JHE — Fri, 05 May 2017 14:08:54 GMT

ods pdf file fit on one page. when user oopen the pdf file, by defualt the viewable size very small, they need to resize make it readable. If they want to print , pdf file always stay on small size, how to solve this issue, how to set uo pdf default size as the normall readable size?

thank yo

Re: ods pdf file fit on one page

Ksharp — Fri, 05 May 2017 14:33:18 GMT

You can change papersize as small as you can just hold all the variables.

options orientation=landscape papersize=(100in 100in)

nonumber topmargin=.25in bottommargin=.25in

leftmargin=.25in rightmargin=.25in;

options orientation=landscape papersize=(20in 10in)

nonumber topmargin=.25in bottommargin=.25in

leftmargin=.25in rightmargin=.25in;

options orientation=landscape papersize=A4

nonumber topmargin=.25in bottommargin=.25in

leftmargin=.25in rightmargin=.25in;

Re: ods pdf file fit on one page

JHE — Fri, 05 May 2017 14:37:47 GMT

Ok, I see, will try.

Thank you.

I have another question: .

Might be easy for you.

data _null_;

dEnd =intnx('dtmonth', dhms(today(),0,0,0), -1,'e');

dStart =intnx('dtMonth', dhms(today(),0,0,0), -1,'b');

Call symputx('dmstart',CATS("'",PUT(dStart,DATEtime18.),"'"));

Call symputx('dmEnd',CATS("'",PUT(dEnd,DATEtime18.),"'"));

run;

%PUT &dmstart &dmEnd;

'01APR17:00:00:00' '30APR17:23:59:59'

What I shold do if I need this format: '01APR2017:00:00:00' '30APR2017:23:59:59'

Re: ods pdf file fit on one page

ballardw — Fri, 05 May 2017 14:40:39 GMT

@JHE wrote:

Ok, I see, will try.

Thank you.

I have another question: .

Might be easy for you.

data _null_;

dEnd =intnx('dtmonth', dhms(today(),0,0,0), -1,'e');

dStart =intnx('dtMonth', dhms(today(),0,0,0), -1,'b');

Call symputx('dmstart',CATS("'",PUT(dStart,DATEtime18.),"'"));

Call symputx('dmEnd',CATS("'",PUT(dEnd,DATEtime18.),"'"));

run;

%PUT &dmstart &dmEnd;

'01APR17:00:00:00' '30APR17:23:59:59'

What I shold do if I need this format: '01APR2017:00:00:00' '30APR2017:23:59:59'

Why are you asking this date format question AGAIN?

You received many answers in https://communities.sas.com/t5/Base-SAS-Programming/Month-beging-with-00-00-00-month-end-with-23-59-59/m-p/356090 including one that you say "agrere, that is the solution!" 2 hours before posting this question?

Re: ods pdf file fit on one page

Cynthia_sas — Fri, 05 May 2017 17:28:16 GMT

Hi:
The answer is posted in the other forum post. You need to INCREASE the width for the DATETIME format. Instead of DATETIME18., use a bigger width, like 20 or 22 instead of the 18.

(but this information WAS in the other answer)
cynthia