topic How to set the length of the output of a column from proc report? in SAS Programming

How to set the length of the output of a column from proc report?

DavidPhillips2 — Wed, 24 Jul 2019 18:13:56 GMT

How do you set the length of the output of a column from proc report?

E.g length $100;

Re: How to set the length of the output of a column from proc report?

ChrisNZ — Wed, 24 Jul 2019 21:21:04 GMT

define VAR / ... width=100 format=$100.;

Re: How to set the length of the output of a column from proc report?

ballardw — Wed, 24 Jul 2019 21:40:47 GMT

In ODS destinations you can try

define age / style(column)=[cellwidth=.5in];

setting a specified width long enough to hold 100 characters of the expected font. I would guess 8in to 10in might get started.

You may have issues with ODS PDF or RTF and the papersize setting as the width of the logical paper may not hold 100 characters across if you are trying to prevent line wrapping in a cell, especially if other columns are involved.

Re: How to set the length of the output of a column from proc report?

Ksharp — Thu, 25 Jul 2019 12:22:36 GMT

define VAR / ... width=40% ;