BookmarkSubscribeRSS Feed
JHE
Obsidian | Level 7 JHE
Obsidian | Level 7

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.

14 REPLIES 14
art297
Opal | Level 21

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

JHE
Obsidian | Level 7 JHE
Obsidian | Level 7

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,

 

 

Reeza
Super User

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;

Reeza
Super User

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

art297
Opal | Level 21

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

Reeza
Super User

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

 

 

 

JHE
Obsidian | Level 7 JHE
Obsidian | Level 7

Thank you.

 

:

JHE
Obsidian | Level 7 JHE
Obsidian | Level 7

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

Reeza
Super User

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

 

JHE
Obsidian | Level 7 JHE
Obsidian | Level 7

Still need solution.

 

 

JHE
Obsidian | Level 7 JHE
Obsidian | Level 7

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

 

 

Reeza
Super User

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. 

JHE
Obsidian | Level 7 JHE
Obsidian | Level 7

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

nonumber topmargin=.25in bottommargin=.25in

leftmargin=.25in rightmargin=.25in

nocenter;

ods escapechar='^';

 

This is works.

art297
Opal | Level 21

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

 

Art, CEO, AnalystFinder.com

 

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 14 replies
  • 1806 views
  • 0 likes
  • 3 in conversation