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
- 11459 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 |
what is the frontend and backend of sas? Is sas is a progaming langauge or tool? on which langauge sas depends?
Do you need to know if there are any missing values?
Why and when do you use proc sql?
How to limit decimal places for variable using proc means?
what is metadata? : Sas-bi
What do the SAS log messages "numeric values have been converted to character" mean?
How to read an input file in sas?
Hi, I have one dataset, could you please ans for this. id amount paid_amount 1 700 400 2 900 250 3 300 300 a 400 250 b 500 320 c 800 650 x 200 190 y 900 250 z 300 180 i want create new dataset having id and paid_amount who are paid high amount comparing amount. ex: 1d paid_amount 3 300 c 650 x 190
Best trainer in hyderabad for sas banking.if any one have details pls provide contact details.
What are exact SAS Base contents..?N what r SAS Tools..?
1.How many ways are there to create variables? 2.What is CLM,how can we use it? 3.what are the advontages of data step? 4.what is the extension of editor window in SAS 9.1.3? 5.How do you copy a particular data set from one library to another? 6.what is the use of double option? 7.Advontages of Proc Report? 8.what is the basic use of where statement? 9.How do you terminate the statments in SAS Programming? 10.What is the difference between symput and symget? 11.How would a identify the local and global variable? can any one answer for the 4'th question
What are the functions used for character handling?
Teradata 
