DATA Step, Macro, Functions and more

conditionally adding part of an entry

Accepted Solution Solved
Reply
Contributor
Posts: 55
Accepted Solution

conditionally adding part of an entry

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.


Accepted Solutions
Solution
‎06-02-2016 10:05 AM
Super User
Posts: 17,750

Re: conditionally adding part of an entry

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;

View solution in original post


All Replies
Solution
‎06-02-2016 10:05 AM
Super User
Posts: 17,750

Re: conditionally adding part of an entry

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;
Contributor
Posts: 55

Re: conditionally adding part of an entry

very nice; I tried things much more complicated.

thank you.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 179 views
  • 0 likes
  • 2 in conversation