topic Trying to have first observation within a group (name AND ID) carry down in SAS Data Management

Trying to have first observation within a group (name AND ID) carry down

KPCklebspn — Wed, 28 Nov 2018 19:46:49 GMT

Dataset looks like this -

Name ID flag1.

AJ 1 1

AJ 1 .

AJ 2 .

How do I make dataset looks like this -

Name ID flag1. varWant

AJ 1 1 1

AJ 1 . 1

AJ 2 . .

Thanks!

KPCklebspn — Wed, 28 Nov 2018 19:53:25 GMT

To clarify - I want the first obs for flag within a group (name AND ID) to carry down

Astounding — Wed, 28 Nov 2018 19:55:54 GMT

As long as your data set is sorted by Name and ID:

data want;

set have;

by name id;

if first.id or flag1 > . then varWant = flag;

retain varWant;

run;