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.
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
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,
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;
Also, that report probably has confidential information, you should remove it from the forum.
Last time I checked legal size paper is 8.5" by 14"
Thank you.
:
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);
@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.
Still need solution.
If not (100in 100in) , it would not fit on one pdf page.
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.
options orientation=landscape papersize=(14in 8.5in)
nonumber topmargin=.25in bottommargin=.25in
leftmargin=.25in rightmargin=.25in
nocenter;
ods escapechar='^';
This is works.
Alternatively, can't you just set the various column widths and use the flow option?
Art, CEO, AnalystFinder.com
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.