topic Re: conditionally adding part of an entry in SAS Programming

conditionally adding part of an entry

soumri — Thu, 02 Jun 2016 13:28:55 GMT

Hi,

my data file is like this:

id h

bv01 lg0012

bv01 lg001

bv14 hk031

bv14 hk03

bv50 78412

bv50 784

ect....

what i want:

id h

bv01 lg0012

bv01 lg0012 *

bv14 hk031

bv14 hk031 *

bv50 78412

bv50 78412 *

help me please; thank you, first.

Reeza — Thu, 02 Jun 2016 14:01:07 GMT

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 — Thu, 02 Jun 2016 14:16:31 GMT

very nice; I tried things much more complicated.

thank you.