Combining Headers in Proc Print

Lost_Gary — Tue, 11 Apr 2023 15:23:02 GMT

Is there a way to combine headers with the same label within the proc print function? For Instance, if I labeled gave both the firstname and lastname fields the same label as "name", could I run some variation such as:

proc print data=mydata label;

var firstname lastname /style(header)=[background =lightblue ];

run;

and get an output of:

Name
Bob	Jones
Daffy	Duck

Re: Combining Headers in Proc Print

ballardw — Tue, 11 Apr 2023 15:40:30 GMT

Not in proc Print.

You can do this with Proc Report:

data have;
   input name1 $ name2 $;
datalines;
Bob Jim
Fred Barney
;

proc report data=have;
   column ("Name label"  name1 name2);
   define name1 /"" ;
   define name2 /"";
run;

The ("Name label" name1 name2) sets a spanning header over the columns Name 1 and Name2 as indicated by the ( ) around the text.

The Define statements with the /"" suppress the default variable label that the individual variables would otherwise contribute.

topic Combining Headers in Proc Print in SAS Programming

Combining Headers in Proc Print

Re: Combining Headers in Proc Print