Answer / shambhu verma

There are various method for it but the simple way to find
out total / sum of each numerical variables is...........

Proc print data= sas data set;
sum var-list;
run;

Answer / puja

Its total of each variable and not row total i suppose
hence the syntax can be given as
proc sql;
create table SUM as
select sum(a) as sum_a,
sum(b) as sum_b,
sum(c) as sum_c,
sum(d) as sum_d,
sum(e) as sum_e,
sum(f) as sum_f
from input_dataset_name;
quit;

Answer / manoj

Or instead of giving all the var-list you can just give:-

Proc print data= sas data set;
sum _numeric_;
run;

It will give sum of all the numeric variable present in the dataset.
Else if you have all the variables as numeric type, then you can give :-

Proc print data= sas data set;
sum _all_;
run;

Answer / naveen

proc print data=qqq;
sum a b c;
or
sum _all_;
run;

Answer / anik chatterjee

The last answer is right but if all the values are missing
then sum function will give a note in log. Best way to add
0 with all value. Hence if all value is missing then total
would be 0 and no note will be there.

proc sql;
create table SUM as
select sum(a) as sum_a,
sum(b,0) as sum_b,
sum(c,0) as sum_c,
sum(d,0) as sum_d,
sum(e,0) as sum_e,
sum(f,0) as sum_f
from input_dataset_name;
quit;

Answer / ak

sum = sum(of a-f);

what is the use of proc contents and proc print in sas? : Sas-administrator

0 Answers  

I am having a stored process.it needs to route my report to both hthml and Xls.By default SP routes to html.I used the PRINTTO to route the html to Xls.BUt it createsthe file not but no content was written to file(0KB)?how can i do it?

1 Answers  

in which companies SAS openings are there? List of companies using SAS technology.

14 Answers   MIR-IFCR, TCS,

do you prefer proc report or proc tabulate? Why? : Sas programming

0 Answers  

What is the order of evaluation of the comparison operators: + - * /** ()?

3 Answers   Quintiles,

how to import HTML files into SAS datasets?

3 Answers   HP,

what are the three main credit bureau names

1 Answers   Synchrony Financial,

Name statements that are recognized at compile time only?

3 Answers   Accenture,

how does sas handle missing values in an update? : Sas programming

1 Answers  

The Lion King is hosting an animal conference. All the animals in the world attend except one. Which animal does not attend?

6 Answers   Oracle,

Explain data step in SAS

0 Answers  

Differentiate between ceil and floor functions.

0 Answers