BookmarkSubscribeRSS Feed
Lost_Gary
Quartz | Level 8

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

 

 

1 REPLY 1
ballardw
Super User

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.

 

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 488 views
  • 1 like
  • 2 in conversation