How to get single obs from one?

[Swati24]

data one;
 infile datalines;
 input Group :$10. Count;
 datalines;
R&D 2
Testing 3
Sales 8
;
run;

 I have a data set like above and I need the output like this

Group	Count
Group Total	13

[Kurt_Bremser]

proc sql;
create table want as
select
  'Group Total' as group,
  sum(count) as count
from one;
quit;

[singhsahab]

Hello,

data one;
 infile datalines;
 input Group :$10. Count;
 datalines;
R&D 2
Testing 3
Sales 8
;
run;


proc sql ;
select 'Group Total' as Group,sum(count) as count from one;
quit; 

or 

proc sql ;
create table want as 
select 'Group Total' as Group,sum(count) as count from one;
quit; 

Thanks 🙂 

[Jagadishkatam]

alternatively in a data step with end option and sum function

data want(drop=count rename=(count2=count));
set one end=eof;
count2+count;
if eof;
run;

[Kurt_Bremser]

---

@Jagadishkatam wrote:

alternatively in a data step with end option and sum function

data want;
set one end=eof;
count_+count;
if eof;
run;

---

Neat. Needs just a little code to create the wanted summary line text.