topic how to get total of variable through data step in SAS Programming

how to get total of variable through data step

karan96 — Sat, 22 Jun 2019 17:51:06 GMT

data test ;
input x;
datalines;
1
2
3
4
5
6
7
;
run;
Q) how can I get total of x in single observation ?

how to get total of variable through data step

karan96 — Sat, 22 Jun 2019 17:43:53 GMT

data test ;

input x;

datalines;

;

run;

Q) how can I get total of x in single observation ?

Re: how to get total of variable through data step

hashman — Sat, 22 Jun 2019 18:15:10 GMT

@karan96:

Any of the steps 2 through 4 below will work:

data test ;                                               
  input x ;                                               
  cards ;                                                 
1                                                         
2                                                         
3                                                         
4                                                         
5                                                         
6                                                         
7                                                         
;                                                         
run ;                                                     
                                                         
data need (drop = x) ;                                    
  set test end = z ;                                      
  sum_x + x ;                                             
  if z ;                                                  
run ;                                                     
                                                          
proc sql ;                                                
  create table need as select sum (x) as sum_x from test ;
quit ;                                                    
                                                         
proc means data = test noprint ;                          
  var x ;                                                 
  output out = need (drop = _:) sum = sum_x ;             
run ;

Kind regards

Paul D.