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
- 11458 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
what is hierarchy flattening? : Sas-di
what is business intelligence? : Sas-bi
How are numeric and character missing values represented internally?
What are the scrubbing procedures in sas?
what is operational data and operational system? : Sas-di
Give some examples where proc report’s defaults are same as proc print’s defaults?
What does proc print, and proc contents are used for?
what do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming
Of all your work, where have you been the most successful?
How to read an input file in sas?
Explain the use of proc print and proc contents?
I have 3 years of work experience at a startup and recently got certified in Data Science with SAS. I need to know how to get into the analytics industry
In SAS explain which statement does not perform automatic conversions in comparisons?
what is slowly changing dimension? : Sas-di
What is the difference between input and infile statement?
