DATA ABC;
INPUT TDATE DATE9. AVG;
CARDS;
18APR2008 150.00
19APR2008 167.00
20APR2008 123.00
21APR2008 145.00
;
RUN
HOW CAN I FIND THE DIFFERENCE BETWEEN AVG OF 18APR2008 ANF
21APR2008??
IF ANY ONE GETS IT PLS TRY TO POST IT.
Answer Posted / chandu
We can solve this with array......
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is the maximum and minimum length of macro variable
What will calendar procedure do?
Explain how merging helps to combine data sets.
Differences between where and if statement?
What are the statements that are executed only?
What is the difference between where and if statement?
what are informats in sas? : Sas-administrator
What are the features of SAS?
To what type of programms have you used scratch macros?
what are all the reports you generated in your recent project?
What is the use of the %include statement?
hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana
data data1; input dt account; format dt date9.; cards; 1745 1230 1756 1120 1788 1130 1767 1240 ; data data2; input startdt enddt total; format startdt date9. enddt date9.; cards; 1657 1834 12300 1557 1758 16800 1789 1789 12300 1788 1345 12383 1899 1899 13250 ; proc sql; create table data3 as select * from data1 as x left join data2 as y on x.dt>=y.startdt and x.dt<=y.enddt; quit; Here, we are getting cartision product. But,I want left join report consisting of this program. It should not get duplicate values. you can modify the program also.
What is PROC in SAS?
name the scheduler for scheduling job and explain the scheduler? : Sas-di