how to get total of variable through data step

[karan96]

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

[karan96]

data test ;

input x;

datalines;

1

2

3

4

5

6

7

;

run;

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

[hashman · Accepted solution]

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