topic Re: Title in proc report make lower in ODS and Base Reporting

Title in proc report make lower

DmytroYermak — Mon, 05 Mar 2018 18:12:27 GMT

Hi all,

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

Re: Title in proc report make lower

ballardw — Thu, 01 Mar 2018 16:19:00 GMT

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.

Re: Title in proc report make lower

Cynthia_sas — Thu, 01 Mar 2018 16:55:01 GMT

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

Re: Title in proc report make lower

Cynthia_sas — Thu, 01 Mar 2018 17:11:29 GMT

Hi,

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

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.

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

Cynthia

Re: Title in proc report make lower

DmytroYermak — Mon, 05 Mar 2018 18:05:28 GMT