The SAS Output Delivery System and reporting techniques

9.2 to 9.4 width of report column

Reply
Contributor
Posts: 25

9.2 to 9.4 width of report column

[ Edited ]

Dear community,

 

I recently switched from sas 9.2 to 9.4 and appreciate the new system.

 

I'm trying to run some old programs that were meant to be repetible, anyway probably in the proc report (ods rtf it could be useful) something changed and even if using "cellwidth=0.14 cm" option in the define statement the document result in a far wider column.

 

Do you know if it is possible to reproduce the old output?


Many thanks,
Gianlu

Esteemed Advisor
Esteemed Advisor
Posts: 7,217

Re: 9.2 to 9.4 width of report column

Well, we have old programs and it shouldn't make any difference going from 9.x to 9.4, we use RTF all the time and its the same (at least from memory 9.3-9.4).  Especially if you put cellwidth in your proc report as that overrides any stylesheet you might use.  Are you sure there is not something else going on?  Maybe your template is not being found and it defaults to rtf or another one?  Check the log, also check you have put:

style={cellwidth=1.4cm};

in your proc report on the correct variables.  Cellwidth 0.14cm seems very small for a column width, you would barely be able to get one character in that.

Contributor
Posts: 25

Re: 9.2 to 9.4 width of report column

[ Edited ]

Dear RW9 thank you very much for your answer.

Unfortunately the cellwidth is correct. That column was kind of a separator in a table, it only contains some ";" in some cases.

We found that this was the best solution to adopt in this case and this kinda became a standard.

The template is good, the program run fine, it always worked and still working on 9.2.

The problem is only that the proc report on 9.4 don't accept this width.

Esteemed Advisor
Esteemed Advisor
Posts: 7,217

Re: 9.2 to 9.4 width of report column

If indeed what you say is correct, then your only option is to speak to SAS Helpdesk.

Grand Advisor
Posts: 10,211

Re: 9.2 to 9.4 width of report column

How much is "far wider"?

What is the declared length of the variable displayed? Possibly you have some value that is attempting to place more characters than will fit into the specified width and a behavior for resolving that conflict has changed.

 

You may also want to look into the STYLE in effect. Even if the name hasn't change sometimes the actual style definition changes in places that may cause odd things (lesson learned between 9.1 and 9.2 )

Ask a Question
Discussion stats
  • 4 replies
  • 191 views
  • 0 likes
  • 3 in conversation