Build reports by using ODS to create HTML, PDF, RTF, Excel, text reports and more!

Title in proc report make lower

Accepted Solution Solved
Reply
Regular Contributor
Posts: 214
Accepted Solution

Title in proc report make lower

[ Edited ]

 

 

Hi all,

 

I really have stuck on making names of my columns in the proc report. 

 871x251.jpg


Accepted Solutions
Solution
‎03-01-2018 01:52 PM
Regular Contributor
Posts: 214

Re: Title in proc report make lower

[ Edited ]
Posted in reply to Cynthia_sas

All Replies
Super User
Posts: 13,950

Re: Title in proc report make lower

Posted in reply to DmytroYermak

You should provide an example of what the data would look like with "names of the columns well-balanced in vertical measures."

 

Since you current code shows vertically nested column headings I suspect the approach might involve summarizing your data such that you no longer use nested column headings.

SAS Super FREQ
Posts: 9,434

Re: Title in proc report make lower

[ Edited ]
Posted in reply to DmytroYermak

Hi: In order to "correct your code" people need data. Otherwise, they have to make data, which may or may not work with your program. So, either you need to provide some test data to work with or you need to recast your program using SASHELP data, which everyone has available. Also, you don't show your RTF statements, margin settings, orientation settings, style or macro variable values. So in order to run your code, you are asking for someone to essentially recreate everything that your program does before this step.

Offhand, my guess is that your parentheses for spanned headers are wrong in the COLUMN statement.

cynthia

SAS Super FREQ
Posts: 9,434

Re: Title in proc report make lower

Posted in reply to Cynthia_sas

Hi,

In looking at your DEFINE statements, your placement of the headers is causing the issues.

header_issue.png

everything in yellow is on the same report row. So, then, your spanning headers for Cohort3 and Cohort4 are going to be ABOVE this row.

 

You could try moving the headers for VAR2 and VAR3 into the COLUMN statement and then putting a blank on the DEFINE statement for those variables.

possible_fix.png

 

But without data or the rest of your code, that is just a guess.

 

Cynthia

Solution
‎03-01-2018 01:52 PM
Regular Contributor
Posts: 214

Re: Title in proc report make lower

[ Edited ]
Posted in reply to Cynthia_sas

 

 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 279 views
  • 1 like
  • 3 in conversation