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
- 7405 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
how does sas handle missing values in assignment statements? : Sas programming
What is the difference between input and infile statement?
What is SAS informats?
what is sas data set?
What are all the problems you faced while validating tables and reports?
what are all the reports you generated in your recent project?
Do you know the features of sas?
what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming
how to debug and test the sas program? : Sas-administrator
What is the differnce between SDTM 3.1.2 to 3.1.1 version
What are the statements that are executed only?
How we can call macros with in data step? : sas-macro
how does sas handle missing values in a merge? : Sas programming
What are the parameters of scan function?
what is the difference between unique key and primary key? : Sas-di
