topic How to get single obs from one? in SAS Programming

How to get single obs from one?

Swati24 — Thu, 13 Dec 2018 10:14:26 GMT

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

Re: How to get single obs from one?

Kurt_Bremser — Thu, 13 Dec 2018 10:25:19 GMT

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

Re: How to get single obs from one?

singhsahab — Thu, 13 Dec 2018 10:25:23 GMT

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 🙂

Re: How to get single obs from one?

Jagadishkatam — Thu, 13 Dec 2018 15:10:31 GMT

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;

Re: How to get single obs from one?

Kurt_Bremser — Thu, 13 Dec 2018 14:55:49 GMT

@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.