Interested to Buy Any Domain ? << Click Here >> for more details...
if i having variables named a b c d e f ,how to find total of
each variable ????give syntax...??
- 6 Answers
- 11240 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / 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;
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
how does sas handle missing values in formats? : Sas programming
How to test the debugging in sas?
Name any two sas spawners? : sas-grid-administration
What do the put and input function do?
Describe the function and untility of the most difficult SAS macro that you have written.
What are the different types of sas functions?
what versions of sas have you used (on which platforms)? : Sas programming
I have a dataset concat having a variable a b & c. How to rename a b to e & f?
what is sas metadata repository? : Sas-bi
Differentiate between format and informat? : sas-grid-administration
what is program data vector? : Sas-administrator
I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com
What is the general format of function in sas? : sas-grid-administration
How does proc sql work?
how would you create multiple observations from a single observation? : Sas programming
