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
- 8691 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
explain about various caches available in data integrator? : Sas-di
Name validation tools used in SAS
what does the run statement do? : Sas programming
what are 5 ways to perform a table lookup in sas? : Sas-administrator
In sas admin differentiate between roles and capabilities? : sas-grid-administration
WHAT IS SAS WEB SERVICE and what are the steps to create an xml service ?
How do you connect the desktop application to metadata server? : sas-grid-administration
what is the use of proc contents and proc print in sas? : Sas-administrator
In SAS explain which statement does not perform automatic conversions in comparisons?
Mention what is SAS data set?
Name types of category in which SAS Informats are placed?
How many data types are there in SAS?
which date functions advances a date time or date/time value by a given interval? : Sas programming
if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...
To what type of programms have you used scratch macros?
