topic Re: blank in header proc report in SAS Programming

blank in header proc report

Cristina_inet — Fri, 11 Aug 2023 12:32:54 GMT

Hello everyone,
we are generating some pdf reports, in them there are tables generated with proc report.
We are asked if it is possible for the header columns to appear as follows:

The cells above should appear blank.

Right now we are displaying it as follows:

The code:

proc report data=VER
      STYLE(header)=[ backgroundcolor=#8DB4E2 ]
      style(header)={verticalalign=middle};

  columns ('Tipo de vía' (TIPO_VIA_4F))  ("&anyo2."(muertos&anyo2.)) ("&anyo3."(muertos&anyo3.))  ('Diferencias'(FDIF_&anyo3._&anyo2. ));

  define TIPO_VIA_4F          / order order=data '' STYLE(header)=[backgroundcolor=white] STYLE(column)=[Color=darkblue] display left;
  define muertos&anyo2.       / order order=data 'Nº' display right;
  define muertos&anyo3.       / order order=data 'Nº' display right;
  define FDIF_&anyo3._&anyo2. / order order=data "&anyo3.-&anyo2." display right;

  compute  muertos&anyo2;       if TIPO_VIA_4F = 'TOTAL' then   call define (_col_,"style","STYLE=[fontweight=bold]"); Endcomp;
  compute  TIPO_VIA_4F;         if TIPO_VIA_4F = 'TOTAL' then   call define (_col_,"style","STYLE=[fontweight=bold]"); Endcomp;
  compute  muertos&anyo3;       if TIPO_VIA_4F = 'TOTAL' then   call define (_col_,"style","STYLE=[fontweight=bold]"); Endcomp;
  compute  FDIF_&anyo3._&anyo2; if TIPO_VIA_4F = 'TOTAL' then   call define (_col_,"style","STYLE=[fontweight=bold]"); Endcomp;
run;

Thank you very much for the help.
Greetings.

Re: blank in header proc report

data_null__ — Fri, 11 Aug 2023 17:25:28 GMT

@Cristina_inet wrote:

Hello everyone,
we are generating some pdf reports, in them there are tables generated with proc report.
We are asked if it is possible for the header columns to appear as follows:

The cells above should appear blank.

Right now we are displaying it as follows:

The code:

proc report data=VER
      STYLE(header)=[ backgroundcolor=#8DB4E2 ]
      style(header)={verticalalign=middle};

  columns ('Tipo de vía' (TIPO_VIA_4F))  ("&anyo2."(muertos&anyo2.)) ("&anyo3."(muertos&anyo3.))  ('Diferencias'(FDIF_&anyo3._&anyo2. ));

  define TIPO_VIA_4F          / order order=data '' STYLE(header)=[backgroundcolor=white] STYLE(column)=[Color=darkblue] display left;
  define muertos&anyo2.       / order order=data 'Nº' display right;
  define muertos&anyo3.       / order order=data 'Nº' display right;
  define FDIF_&anyo3._&anyo2. / order order=data "&anyo3.-&anyo2." display right;

  compute  muertos&anyo2;       if TIPO_VIA_4F = 'TOTAL' then   call define (_col_,"style","STYLE=[fontweight=bold]"); Endcomp;
  compute  TIPO_VIA_4F;         if TIPO_VIA_4F = 'TOTAL' then   call define (_col_,"style","STYLE=[fontweight=bold]"); Endcomp;
  compute  muertos&anyo3;       if TIPO_VIA_4F = 'TOTAL' then   call define (_col_,"style","STYLE=[fontweight=bold]"); Endcomp;
  compute  FDIF_&anyo3._&anyo2; if TIPO_VIA_4F = 'TOTAL' then   call define (_col_,"style","STYLE=[fontweight=bold]"); Endcomp;
run;

Thank you very much for the help.
Greetings.

*remove header text from column statement;
columns (TIPO_VIA_4F)  ("&anyo2."(muertos&anyo2.)) ("&anyo3."(muertos&anyo3.))  ('Diferencias'(FDIF_&anyo3._&anyo2. ));
*Add the text here;
define TIPO_VIA_4F          / order order=data 'Tipo de vía'  STYLE(header)=[backgroundcolor=white] STYLE(column)=[Color=darkblue] display left;Th

This is untested.

Re: blank in header proc report

Ksharp — Sat, 12 Aug 2023 09:37:58 GMT

proc format;
value $ fmt
'09'x='white'
other='#8DB4E2 ';
run;

proc report data=sashelp.class
      STYLE(header)=[ backgroundcolor=$fmt. ] nowd;
column ("09"x  name) ('xxxx' height) ("yyyy" weight);
define name/display ;
run;

Re: blank in header proc report

Tom — Sat, 12 Aug 2023 15:54:47 GMT

That is a cool trick. But it would be better to use something like 'A0'x instead of a TAB. Then it won't mess up the normal listing output column alignments.

Re: blank in header proc report

Ksharp — Sun, 13 Aug 2023 09:17:40 GMT

Tom,

But if I use '0A'x ,I got this under unicode sas or Chinese sas. (HTML destination)

Re: blank in header proc report

Tom — Sun, 13 Aug 2023 14:58:45 GMT

Not sure why you used a LINEFEED. Not sure why Chinese encoding would display a character for either a linefeed or a non-breaking space. Are you use double byte character set? If so you probably need to two byte character.

Why not just use a normal space then?

Re: blank in header proc report

Ksharp — Mon, 14 Aug 2023 11:25:37 GMT

Tom,
Opps. It is typo.
I am from China.
So I have to use multi byte character set,like Chines or UTF-8 .