Calcite | Level 5

## Calculate difference between first and last observation

I have the following dataset

data have;
input profit;
datalines;
52
34

60

57

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Opal | Level 21

## Re: Calculate difference between first and last observation

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

2 REPLIES 2
Opal | Level 21

## Re: Calculate difference between first and last observation

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

Tourmaline | Level 20

## Re: Calculate difference between first and last observation

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

Discussion stats
• 2 replies
• 2142 views
• 2 likes
• 3 in conversation