DATA Step, Macro, Functions and more

ods pdf file can not print

Reply
Frequent Contributor
Frequent Contributor
Posts: 83

ods pdf file can not print

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.

PROC Star
Posts: 7,366

Re: ods pdf file can not print

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_3foRcZ...: ), somehow I don't think that's what you want.

 

Art, CEO, AnalystFinder.com

Frequent Contributor
Frequent Contributor
Posts: 83

Re: ods pdf file can not print

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,

 

 

Super User
Posts: 17,960

Re: ods pdf file can not print

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;

Super User
Posts: 17,960

Re: ods pdf file can not print

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

PROC Star
Posts: 7,366

Re: ods pdf file can not print

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

Super User
Posts: 17,960

Re: ods pdf file can not print


art297 wrote:

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


@art297 You're correct Smiley Wink 

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.

 

 

 

Frequent Contributor
Frequent Contributor
Posts: 83

Re: ods pdf file can not print

Thank you.

 

:

Frequent Contributor
Frequent Contributor
Posts: 83

Re: ods pdf file can not print

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);

Super User
Posts: 17,960

Re: ods pdf file can not print

@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. 

 

Frequent Contributor
Frequent Contributor
Posts: 83

Re: ods pdf file can not print

Still need solution.

 

 

Frequent Contributor
Frequent Contributor
Posts: 83

Re: ods pdf file can not print

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

 

 

Super User
Posts: 17,960

Re: ods pdf file can not print

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. 

Frequent Contributor
Frequent Contributor
Posts: 83

Re: ods pdf file can not print

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

nonumber topmargin=.25in bottommargin=.25in

leftmargin=.25in rightmargin=.25in

nocenter;

ods escapechar='^';

 

This is works.

PROC Star
Posts: 7,366

Re: ods pdf file can not print

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

 

Art, CEO, AnalystFinder.com

 

Ask a Question
Discussion stats
  • 14 replies
  • 152 views
  • 0 likes
  • 3 in conversation