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 is the Population you used in your project, is it ITT or PP?
What are the advantages of using sas?
Mention what are the data types does SAS contain?
Given an unsorted data set, how to read the last observation to a new data set?
What are the difficulties u faced while doing vital signs table or dataset?
how will you location sas platform applications available from web browser? : Sas-bi
What do the put and input function do?
How does proc sql work?
what is slowly changing dimension? : Sas-di
What is SAS informats?
What are the special input delimiters used in SAS?
Of all your work, where have you been the most successful?
Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?
How many data types are there in SAS?
Explain data step in SAS