topic Re: How do I keep all the columns in one line? in ODS and Base Reporting

How do I keep all the columns in one line?

ASASProgrammer — Thu, 25 Jul 2013 18:59:45 GMT

Using ODS pdf plus proc report to generate pdf file.

Since I have many columns, and I need keep all of them in one line, but it always breaks in somewhere, and move some columns to next line.

How do I prevent this?

e.g.

I need this:

col1 col2 col3 col4 ... col15

but it is always like this:

col1 col2 col3 col4 ... col10

col11 col12.. col15

Re: How do I keep all the columns in one line?

Cynthia_sas — Thu, 25 Jul 2013 23:57:43 GMT

Hi:

One of my first posts in the forum was about how to deal with "very wide" reports and how to use ODS STYLE= overrides to make them fit on a "page". I believe the code will still work that I posted. I'd suggest you search for that old post. I think if you use the search terms "very wide" you will find it.

cynthia

Re: How do I keep all the columns in one line?

ASASProgrammer — Fri, 26 Jul 2013 13:40:58 GMT

Thanks Cynthia.

It helps.

What I am thinking is that if there is an option to shrink or enlarge in proportion to fit in the page, that would be nice.

Thanks!

Re: How do I keep all the columns in one line?

Cynthia_sas — Sat, 27 Jul 2013 03:50:55 GMT

Hi:

There is no such option to shrink or enlarge what is going to be on the page. You can impact the PDF viewer after the file is created using SAS system options, but you can't shrink or fit while the output is being created. That is why you have to write the report to fit within the margins using ODS STYLE= overrides.

cynthia