topic Re: ods pdf file can not print in SAS Programming

ods pdf file can not print

JHE — Sun, 07 May 2017 15:58:49 GMT

My code:

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

nonumber topmargin=.25in bottommargin=.25in

leftmargin=.25in rightmargin=.25in

nocenter;

ods escapechar='^';

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

%MACRO TPLPDF(lobname);

PROC REPORT DATA=TPLMEM.TPL_SUMMARY_&lobname;

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 &lobname TPL Membership" ;

footnote" Run at &sDay &stime" ;

RUN;

%mend TPLPDF;

%TPLPDF(0100);

Output attached, bu tcan not print the normal size. how to fixed.

Re: ods pdf file can not print

art297 — Sun, 07 May 2017 16:38:08 GMT

You do realize that you're creating a page that is 8 1/3 feet long and 8 1/3 feet wide.

While you can buy a printer that can handle that (https://www.google.ca/search?q=printer+100%22+wide&tbm=isch&imgil=t-IDlDoe5ZBq-M%253A%253BuYK_3foRcZqM1M%253Bhttp%25253A%25252F%25252Fwww.liveauctionworld.com%25252FMUTOH-VALUE-JET-100-WIDE-FORMAT-PRINTER_i24172483&source=iu&pf=m&fir=t-IDlDoe5ZBq-M%253A%252CuYK_3foRcZqM1M%252C_&usg=__R6cia-Kwa2r12M6l1DQWPLf6SUs%3D&biw=1292&bih=652&ved=0ahUKEwikuu2Lm97TAhVl9IMKHVLtAdoQyjcIhgE&ei=h0wPWeTaEeXojwTS2ofQDQ#imgrc=t-IDlDoe5ZBq-M: ), somehow I don't think that's what you want.

Art, CEO, AnalystFinder.com

Re: ods pdf file can not print

JHE — Sun, 07 May 2017 17:14:33 GMT

I see, I need modify proc report with the size suitable.

I have 16 columns on the report, need to fit in one padge. legal size.

Thank you,

Re: ods pdf file can not print

Reeza — Sun, 07 May 2017 19:06:22 GMT

Legal size is 8.5"x11" not 100"x100" as you've specified.

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

nonumber topmargin=.25in bottommargin=.25in

leftmargin=.25in rightmargin=.25in

nocenter;

Re: ods pdf file can not print

Reeza — Sun, 07 May 2017 19:07:04 GMT

Also, that report probably has confidential information, you should remove it from the forum.

Re: ods pdf file can not print

art297 — Sun, 07 May 2017 19:52:32 GMT

Last time I checked legal size paper is 8.5" by 14"

Re: ods pdf file can not print

Reeza — Sun, 07 May 2017 20:13:29 GMT

@art297 wrote:

Last time I checked legal size paper is 8.5" by 14"

@art297 You're correct 😉

8.5" x 11" -> Letter

8.5" x 14" -> Legal

17" x 11" -> Letter x 2, can be folded over and appear as a letter page when compiling documents which is sometimes nice.

Re: ods pdf file can not print

JHE — Wed, 10 May 2017 17:12:25 GMT

Thank you.

Re: ods pdf file can not print

JHE — Wed, 10 May 2017 17:36:37 GMT

My code: coudl not fit on one page, I think I need every column on proc report need resize.

options orientation=landscape papersize=(8.5in 14in)

nonumber topmargin=.25in bottommargin=.25in

leftmargin=.25in rightmargin=.25in

nocenter;

ods escapechar='^';

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

%MACRO TPLPDF(lobname);

PROC REPORT DATA=TPLMEM.TPL_SUMMARY_&lobname;

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 &lobname TPL Membership" ;

footnote" Run at &sDay &stime" ;

RUN;

%mend TPLPDF;

%TPLPDF(0100);

Re: ods pdf file can not print

Reeza — Wed, 10 May 2017 17:40:18 GMT

@JHE Your last post is unclear. Is this working for you now or do you still have issues? Remember we don't have your data and can't run your code or see the output or log, unless you provide them. If you're still having issues take the time to detail what's the problem.

If you had, for example, I could be typing out an answer instead of taking the time to ask for more details.

Re: ods pdf file can not print

JHE — Wed, 10 May 2017 17:50:15 GMT

Still need solution.

Re: ods pdf file can not print

JHE — Wed, 10 May 2017 17:51:38 GMT

If not (100in 100in) , it would not fit on one pdf page.

Re: ods pdf file can not print

Reeza — Wed, 10 May 2017 18:19:17 GMT

There's a logical limit to how many variables you can have on a page.

I find it hard to believe that the page has to be 100in to fit all your columns - that's almost 10 pages wide.

Either way you need to split the report to run on multiple pages. There's no workaround for too many variables unless you're ok with it being too small to read.

Re: ods pdf file can not print

art297 — Wed, 10 May 2017 18:24:18 GMT

Alternatively, can't you just set the various column widths and use the flow option?

Art, CEO, AnalystFinder.com

Re: ods pdf file can not print

JHE — Wed, 10 May 2017 18:39:52 GMT

options orientation=landscape papersize=(14in 8.5in)

nonumber topmargin=.25in bottommargin=.25in

leftmargin=.25in rightmargin=.25in

nocenter;

ods escapechar='^';

This is works.