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
- 8403 Views
- I also Faced
- E-Mail Answers
Answer Posted / rpd
I can give logic part, rest kindly manage :)
step 1:proc sort the dataset by "PID YEAR"
step2 :in the datastep "SET" it using by PID YEAR
create a temp variable say _SUM and RETAIN _SUM,
reset _SUM=0 on FIRST.YEAR.
T_VALUE=_SUM+VALUE
I guess this will work
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Give an example where SAS fails to convert character value to numeric value automatically?
Difference between nodup and nodupkey options?
what r the job openings SAS for fresher graduates !
Describe a time when you were really stuck on a problem and how you solved it?
what can you learn from the sas log when debugging? : Sas programming
What are the difference between ceil and floor functions in sas?
What versions of SAS have you used (on which platforms)?
How will you use the WHO Drug Dictionary for Reporting Clinical Trials?
what is sas data set?
Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?
What are common programming errors committed in sas
What does the trace option do?
What are symget and symput? : sas-macro
Explain by-group processing?
what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?
