if i having variables named a b c d e f ,how to find total of
each variable ????give syntax...??
- 6 Answers
- 10411 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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;
| Is This Answer Correct ? | 18 Yes | 0 No |
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;
| Is This Answer Correct ? | 8 Yes | 3 No |
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;
| Is This Answer Correct ? | 5 Yes | 0 No |
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;
| Is This Answer Correct ? | 0 Yes | 5 No |
Do you need to rearrange the order of the data for the report?
how does sas handle missing values in functions? : Sas programming
Which date functions advances a date time or date/time value by agiven interval?
When looking for data contained in a character string of 150 bytes, which function is the best to locate that data: scan, index, or indexc?
Explain why double trailing @@ is used in input statement?
Where do the database management systems store data and how do u import them.
what is washout period?
Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro
What do the put and input function do?
what is sas metadata repository? : Sas-bi
why is a stop statement needed for the point=option on a set statement? : Sas programming
what is null hypothesis? why do you consider that?
0 Answers Accenture, Quintiles,
Teradata 
