topic How to avoid Date Accumulation in Proc report in SAS Programming

How to avoid Date Accumulation in Proc report

Samyak — Sun, 25 Dec 2016 20:13:39 GMT

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?

Re: How to avoid Date Accumulation in Proc report

Shmuel — Sun, 25 Dec 2016 21:27:17 GMT

Please post your proc report code.

Re: How to avoid Date Accumulation in Proc report

Ksharp — Mon, 26 Dec 2016 04:11:29 GMT


define date/ DISPLAY ;

Re: How to avoid Date Accumulation in Proc report

Samyak — Mon, 26 Dec 2016 06:32:06 GMT

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 ?

Re: How to avoid Date Accumulation in Proc report

Ksharp — Tue, 27 Dec 2016 03:04:45 GMT

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