topic Re: Column formats in proc report in SAS Programming

Column formats in proc report

AKHILA — Fri, 26 Apr 2019 06:40:35 GMT

How to customise columns in proc report
I want my report to be looks like , (to leave some space after each heading.)
...................
Heading 1
aaa
Bbb
Ccc
Heading 2
Ddd
Eeee
Ffff
Heading 3
Hhhh
Iiii
Jjj.

Re: Column formats in proc report

andreas_lds — Fri, 26 Apr 2019 06:58:43 GMT

Sorry, i can't see the extra-space you want.

Are you creating text, rtf, html or pdf output?

Have you checked the style-option?

Re: Column formats in proc report

AKHILA — Fri, 26 Apr 2019 07:00:17 GMT

Rtf file

Re: Column formats in proc report

Ksharp — Fri, 26 Apr 2019 13:05:33 GMT

Add some 'blank' character like TAB.

Heading 1||'09'x||'09'x

or use

style={cellwidth=10cm};

Re: Column formats in proc report

Cynthia_sas — Fri, 26 Apr 2019 13:33:37 GMT

Hi:

PROC REPORT typically only puts HEADER rows at the top of the report. There would not typically be a Heading 2 or Heading 3 in PROC REPORT output unless you manipulated your data in some way.

What PROC REPORT code are you using? Can you post some test data? Without seeing your DATA, it's hard to visualize what PROC REPORT code is going to give you Heading 2 and Heading 3 on the report unless you use COMPUTE blocks of some kind.

For example, in this example, I create a text string called Heading 1 or Heading 2 based on the value of the PRODUCT variable and use a COMPUTE before block to write out the text string.

However, without seeing more of your data and YOUR code, it is impossible to say how to add more "space" to the report.

Cynthia