topic Re: How to give one label for a group of variables . in SAS Programming

How to give one label for a group of variables .

Swati24 — Thu, 13 Dec 2018 06:00:24 GMT

I have the following data set like this :

Group_Name	Head_Name	LastYear_Count	BeforeLastYear_Count
R&D	IT	1	2
R&D	Testing	0	5
R&D	Production	4	0
R&D	Development	1	0
Sales	Book	5	4
Sales	Product	10	0
Sales	Kit	1	1
Admin	Marketing	4	1
Admin	HR	5	2
Admin	Project	6	3

and I want to get the output like the following attachment using proc report.:

Re: How to give one label for a group of variables .

singhsahab — Thu, 13 Dec 2018 06:19:58 GMT

HI,

data test;
input Group_Name $ Head_Name $	LastYear_Count	BeforeLastYear_Count;
cards;
R&D IT 1 2
R&D Testing 0 5
;
run;


proc report data=test style(header)=[background=white];
 col ('Groups ' Group_Name Head_Name)
 ('total count' LastYear_Count BeforeLastYear_Count );
run;

Thanks,