Interested to Buy Any Domain ? << Click Here >> for more details...
calculate the sum of value using only DATA STEP.
data count_;
input year name $ value;
cards;
2006 xxx 10
2007 yyy 12
2006 xxx 20
2008 yyy 15
2007 xxx 15
;
out put should be like this
year name T_value
-----------------------
2006 xxx 30
2007 xxx 15
2007 yyy 12
2008 xxx 15
- 6 Answers
- 8451 Views
- I also Faced
- E-Mail Answers
Answer Posted / ashish
data new;
set tech ;
by year name;
if first.year or first.name then do;
sum=0;
end;
sum+value;
if last.year or last.name ;
run;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Describe the function and untility of the most difficult SAS macro that you have written.
what r the job openings SAS for fresher graduates !
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
What is SAS? What are the functions does it performs?
Enlist the syntax rules followed in sas statements.
What are the ways in which macro variables can be created in sas programming?
what are the component of range? : Sas-bi
what is sas application server? : Sas-di
how do the in= variables improve the capability of a merge? : Sas programming
What is the different between functions and PROCs that calculate the same simple descriptive statistics?
what is SAS OPTIMIZATION?
What are the advantages of using sas?
How substr function works in sas?
What is the role of sas grid administrator? : sas-grid-administration
what is the difference between infile and input? : Sas-administrator
