topic Re: Selecting the last var1 from each distinct var2 in SAS Data Management

Selecting the last var1 from each distinct var2

TurnTheBacon — Mon, 08 Oct 2012 11:03:00 GMT

I need to create a data set that list the last dekning_sk for each distinct avtale_sk from the following source data set:

So, the output data set should say:

etc...

What kind of user written code would produce this kind of result? Either DATA STEP or PROC SQL would be fine.

Thanks for your time.

Linlin — Mon, 08 Oct 2012 11:36:58 GMT

try:

data want;

set have;

by avtale_sk dekning_sk notsorted;

if last.dekning_sk;

run;

TurnTheBacon — Mon, 08 Oct 2012 11:39:49 GMT

Thanks for the suggestion, but as far as I can tell the output data set looks exactly the same.

Linlin — Mon, 08 Oct 2012 11:49:52 GMT

How did you get 121 when avtale_sk=3 ? why not 122?

try the modified one:

data want;

set have;

by avtale_sk notsorted;

if last.avtale_sk;

run;

TurnTheBacon — Mon, 08 Oct 2012 11:54:13 GMT

I'm very sorry, that was a typo. I should have been more vigilant. It's been corrected now.

TurnTheBacon — Mon, 08 Oct 2012 11:59:11 GMT

Perfect, thank you very much Linlin.