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
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.
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.
If indeed what you say is correct, then your only option is to speak to SAS Helpdesk.
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 )
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.