conditionally adding part of an entry

[soumri]

Hi,

my data file is like this:

id              h

bv01         lg0012

bv01         lg001      

bv01         lg001

bv14         hk031

bv14         hk03

bv50         78412

bv50         784

bv50         784

bv50         784

ect....

what i want:

id              h

bv01         lg0012

bv01         lg0012 *    

bv01         lg0012 *

bv14         hk031  

bv14         hk031  *

bv50         78412

bv50         78412  *

bv50         78412  *

bv50         78412  *

help me please; thank you, first.

[Reeza · Accepted solution]

Just to confirm the logic is keeping the first records value and filling down?

Use BY group processing with a RETAIN statement to keep the value. This creates a new variable with the values you want. 

Data want;
Set have;
By id;
Retain h_new;

If first.id then h_new = h;

Run;

[soumri]

very nice; I tried things much more complicated.

thank you.