topic Columns splitting to second line in proc report in SAS Programming

Columns splitting to second line in proc report

PrinceAde — Sun, 06 Oct 2024 18:21:01 GMT

Hello everyone. please I need help with replicating a listing template.
I want to display few columns using proc report based on a given template.
The columns are not staying on the same line. About three columns continue to the next line which is not looking good. This occurs because the cellwidth for each column is around 25. If I should reduce the cellwidth, the columns will stay on this same line, which is perfect. However, the template I'm trying to copy is well spaced around 25 width.
How can I retain the width(around 25) I want and still maintian the columns on the same line?

I have tried to use the papersize option to increase the size of the page, it is not working.
What can I do, please?

Thanks all for your replies.

Re: Columns splitting to second line in proc report

PaigeMiller — Sun, 06 Oct 2024 19:42:29 GMT

Please provide the code and sample data. Show us the incorrect output.

Re: Columns splitting to second line in proc report

ballardw — Mon, 07 Oct 2024 15:01:24 GMT

@PrinceAde wrote:

Hello everyone. please I need help with replicating a listing template.
I want to display few columns using proc report based on a given template.
The columns are not staying on the same line. About three columns continue to the next line which is not looking good. This occurs because the cellwidth for each column is around 25. If I should reduce the cellwidth, the columns will stay on this same line, which is perfect. However, the template I'm trying to copy is well spaced around 25 width.
How can I retain the width(around 25) I want and still maintian the columns on the same line?

I have tried to use the papersize option to increase the size of the page, it is not working.
What can I do, please?

Thanks all for your replies.

25 what? If you are counting letters to estimate space welcome to 1984. Character "space" varies depending on the display font and most of the default fonts used with SAS for output in HTML (results window), RTF, PDF, Excel will use proportional fonts as well. Which means that "iiii" takes up much less space than "WWWW" and is a very unreliable way to describe width.

SAS output for proc report has multiple units that you can use to control width of cells (and other things) 25in (likely way too large) 25mm, 25CM, 25px (pixels are display device dependent and also someone unreliable because you don't know what resolution a reader's monitor may have) in some cases percent of display width, EM and EX typesetting measurements or PT (printer's point often used as a Font size).

In some usages if you specify a "width" of 25 with no unit specified the result will be 25/150 inches.

If you have to specify widths then I strongly recommend using a unit of measure you are familiar width and understand.