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 |
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.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.