topic Re: Calculate difference between first and last observation in SAS Programming

Calculate difference between first and last observation

mhinchy — Sun, 09 Apr 2017 17:05:56 GMT

I have the following dataset

data have;
input profit;
datalines;
52
34

70
;
run;

I want to write a program that will create a new dataset, only containing the difference between the first and last observation?

In this case the code would show 70 (last observation) - 52 (first observation), so the output would be 18.

art297 — Sun, 09 Apr 2017 17:11:14 GMT

Here is one way:

data want;
  set have end=last;
  retain first;
  if _n_ eq 1 then first=profit;
  if last then do;
    result=profit-first;
    output;
  end;
run;

Art, CEO, AnalystFinder.com

novinosrin — Mon, 10 Apr 2017 04:50:17 GMT

hi,

data want(drop=_profit);
set have(firstobs=min);
set have(rename=(profit=_profit)) nobs=_nobs_ point=_nobs_;
d=_profit-profit;
output;
stop;
run;

Regards,

Naveen Srinivasan