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
- 8452 Views
- I also Faced
- E-Mail Answers
Answer Posted / ravi s
it need two steps
step 1 : proc sort; by year name;run;
Step 2: data total (drop = value);
set count_;
by year name;
if first.name then T_value =0 ;
T_value + value;
if last.name then output ;
run;
Note: Hence i am doing work in data step. i need to sort
the data first by using "Proc Sort".
Kindly let me know is the any other method to do?
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Will it bother you if the guy at the next desk times the frequency and duration of your bathroom or coffee breaks on the grounds that ?you are getting paid twice as much as he is??
how do you want missing values handled? : Sas programming
what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming
How do you specify the number of iterations and specific condition within a single do loop?
What are the special input delimiters used in SAS?
How would you identify a macro variable?
what is sas application server, database server, sas olap server and sas metadata server? : Sas-di
What are the data types does SAS contain?
Mention what is PROC in SAS?
Describe the ways in which you can create a macro variable?
is data integration and etl programming is same? : Sas-di
How do you use the do loop if you don’t know how many times you should execute the do loop?
What do you understand by the term Normal Distribution?
explain about sas business intelligence? : Sas-bi
Describe the ways in which you can create macro variables? : sas-macro
