Hi, I have been struggling with an ODS RTF problem for quite a while. The problem is that I would need to generate a RTF report with dynamic texture styles (different colors, sizes, styles etc.). The only way to do this (with my knowledge) is to use proc report/print to print out text datasets where ods escapechar is used to inject RTF tags into it. However this method has a major drawback and it is that the output is printed into tables/cells and not as "normal" text, and it makes the post processing of the RTF file really complicated. What I would think would be the way to go is the ODS TEXT, but as far as I know there is no control statements for the ODS TEXT styles? Or is there some undocumented statements involved (if so then it could still be a problem since the code needs to work with future SAS versions too)? Third option that I have thought, but not yet tried is to reformat the template ODS TEXT uses (if even possible?) _every_time_ before the ODS TEXT statement. This solution obviously would extremely inconvenient. Do you guys have any solutions for this? I am using SAS 9.4 and the reports are generated by SAS Stored Processes. ... View more

Hi, I am trying to get repeated values to be shown one of my group columns in proc report. I have tried the trick described in the Allison McMahill's article: COMPUTE week; IF week NE ' ' then holdw=week; IF week EQ ' ' then week=holdw; ENDCOMP; However this trick does not work when spanrows option is enabled (and I need it to be enabled for the other columns to avoid confusion). Is there a way to get this thing working? Any help is much appreciated. ... View more

landHi, I am struggling with PROC REPORT a lot. Firstly I would need to somehow "compress" the output since my report is in RTF landscape, and the headers of the report columns might be quite long and steal most of the space available on the page. The problem is that if the header takes a lot of room then only 1-3 observation rows will fit into the landscape page, and every time a page changes the header is replicated by default in PROC REPORT. This leads to an "infinite loop" where there will be thousands of pages all containing only few observations and all other area is filled with the headers. So what I would want is that there would be only one header per PROC REPORT print, so that the table would continue to the next page without the header replication. Edit: I attached an example of my PROC REPORT code. It might be that my SAS knowledge is too limited or this problem is not doable with SAS but I hope someone could help me out. There could be an optional way to reduce the header size with font size (but this method is really limited since the text becomes unreadable very soon). Other way would be that if I could somehow control the total width of the main across variable (in sample code var5) and let the second across variable (sample code var6) vary in length freely "under" the first across variable. This however does not work with outputwidth command and I have to fix both across variable widths as a constant. My report is dynamic and constant column widths are "stupid" for my use (in my opinion this is one of the biggest issues with SAS, compared to competitive alternatives, that you can't explicitly tell PROC REPORT to have total maximum width for the table and under that constraint it can automatically decide the proper widths for the columns, PLEASE CORRECT ME IF I AM WRONG). ... View more

Hi, Is it somehow possible to maintain the "imagemap" feature into RTF output with proc sgplot? I know that word itself is not the limiting factor here since it works with proc gchart (only the graphs are ancient...). ... View more

I am losing my mind here. I just can not get the X axis on my SGPLOT to be symmetrical. I define values (-&count to &count by 5) in the xaxis statement and what happens is that SAS just randomly decides which of the values it should show for example the axis could be lik -11 -6 -1 4 9 14 which makes just no sense. I would need to get the axis to always contain 0 and then have symmetrically distributed value ticks around 0 witht the MIN/MAX value being at the end of the values list. How can I do this? Is there some style element that drives this? I have tried to force this by assigning also white reflines at the MIN and MAX points with noclip option but it does not work. ... View more