DATA Step, Macro, Functions and more

How to avoid Date Accumulation in Proc report

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

How to avoid Date Accumulation in Proc report

I have a Date variable in a report summary.

When I use an rbreak or a break statement, the date column gets accumulated as well, which I want to avoid.

What syntax should I follow?

Accepted Solutions
Solution
‎12-26-2016 01:27 AM
Super User
Posts: 10,020

Re: How to avoid Date Accumulation in Proc report


define date/ DISPLAY ;


View solution in original post


All Replies
Trusted Advisor
Posts: 1,554

Re: How to avoid Date Accumulation in Proc report

Please post your proc report code.

Solution
‎12-26-2016 01:27 AM
Super User
Posts: 10,020

Re: How to avoid Date Accumulation in Proc report


define date/ DISPLAY ;


New Contributor
Posts: 2

Re: How to avoid Date Accumulation in Proc report

Thanks a lot !

Also, there is a variable called comments in my Data which I want to include in my report. The variable is a lengthy one, and when I export my data to a pdf ods, it shows the comments column in a new page and not with my other columns.

However, If I export the report to an html ods, the output looks fine.

How can I make the comments column fit in one page in the pdf, along with other variables ?
Super User
Posts: 10,020

Re: How to avoid Date Accumulation in Proc report

You can define a relative short length to that variable.

define comment/style={cellwidth=2cm};


Or you can make your PDF page bigger to hold that variable.

1) options leftmargin=0 rightmargin=0;

2) options papersize=(40cm 100cm);
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 214 views
  • 2 likes
  • 3 in conversation