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

I have code as following, but second report TPL_SUMMARY_0500, nt the landscaping any more, even I set up the Landscspe as the option, therefor the out put looks very in consisitance. 

 

 

options orientation=landscape center;
ods pdf file ="/export/TPL_Membership/Summary/test.pdf";
ods listing close;

%MACRO ABC (VAR);
PROC REPORT DATA=WORK.TPL_SUMMARY_&VAR;
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;
title " LOB &VAR TPL Membership" ;
footnote" Run at &sDay &stime" ;
RUN;
%MEND;
%ABC (VAR=0100);
%ABC (VAR=0500);

7 REPLIES 7
ballardw
Super User

You do not show an ODS PDF CLOSE statement. Was there one in the actual program? If not you may have a previous version of the pdf file.

 

 

JHE
Obsidian | Level 7 JHE
Obsidian | Level 7

Ok, I see.  Let me check if I remove CLOSE statement. 

 

See attach,

 

ballardw
Super User

Without data it is hard to test what may be causing the change.

Try running this:

ods pdf file ="/export/TPL_Membership/Summary/test.pdf";

%ABC (VAR=0100);
%ABC (VAR=0100);

ods pdf close;

And see if both pages look the same. If so then there is something subtle in the data that likely means one or more of the columns wants just a little more room at which point the PDF generator splits off several columns to make a "nicer" report.

 

 

I know that generally if I want tables based on separate data sets to appear the same that I usually have to go into setting style overrides for each column to the width stays the same for each report call.

 

You might look at the Proc Contents results for your data sets and see if the lengths of the character variables are the same.

JHE
Obsidian | Level 7 JHE
Obsidian | Level 7

Thank you !

 

I am going to try .

 

 

Ksharp
Super User
Maybe you need to reset it before applying it.


options orientation=landscape center;
ods pdf file ="/export/TPL_Membership/Summary/test.pdf";
%ABC (VAR=0100)

ods pdf;
options orientation=landscape center;
%ABC (VAR=0500)

ods pdf close;
JHE
Obsidian | Level 7 JHE
Obsidian | Level 7
thank you for reply to me. still dose not working ..

##- Please type your reply above this line. Simple formatting, no
attachments. -##
ballardw
Super User

@JHE wrote:
thank you for reply to me. still dose not working ..

##- Please type your reply above this line. Simple formatting, no
attachments. -##

Which are you responding to? There is a button above the text entry area that says "Quote" . If you click on that the text of the post you respond to is brought into the message area so it is clear which which post you are responding to.

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

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
  • 7 replies
  • 1094 views
  • 0 likes
  • 3 in conversation