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 / nagesh sriram
Hi,
I am think that the difference between the first and last
records value?
data _null_;
set abc end=last;
retain first;
if _n_=1 then first=avg;
if last=1 then do;
diff=first - avg;
put 'The difference is =' diff;
stop;
end;
run;
here _n_=1 is hold the first record in the abc dataset.
Last=1 means is hold the last record in the dataset.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the implications?
What are pdv and it functions?
Explain the special input delimiters used in sas programming.
what is sas application server, database server, sas olap server and sas metadata server? : Sas-di
how the sas basic syntax style described? : Sas-administrator
what is information maps?
describe about metadata object? : Sas-di
How to create a permanent sas data set?
which date functions advances a date time or date/time value by a given interval? : Sas programming
What is the purpose of _character_ and _numeric_?
what are the types of interactive display types? : Sas-bi
what are sas bi dashboard components? : Sas-bi
Explain the use of proc print and proc contents?
what versions of sas have you used (on which platforms)? : Sas programming
what is enterprise guide? What is the use of it? : Sas programming