How to populate a group variable values to all obs

[knveraraju91]

Dear,

For sorting a dataset I need to populate the decod values all relavent OBS . Please help. Thank you very much

output needed;

Bodsys     decod         sev 

blsd                            mild
blsd                          moderate
blsd                          severe
blsd        anae
blsd       anae           mild
blsd     anae             moderate
blsd      anae            severe
blsd       lymp
blsd      lymp             mild
blsd      lymp           moderate
blsd      lymp             severe
;

data one;
input bodsys $4. +1 decod $4. +1 sev $8.;
datalines;
blsd      mild
blsd      moderate
blsd      severe
blsd anae  
blsd      mild
blsd      moderate
blsd      severe
blsd lymp 
blsd      mild
blsd      moderate
blsd      severe
;

[art297]

data want (drop=hold);;
  set one;
  retain hold;
  if not missing(decod) then hold=decod;
  decod=hold;
run;

Art, CEO, AnalystFinder.com

[knveraraju91]

Dear,

Thank you very much for the code.You code works for me for the sample data I posted. But if the bodsys values increase it is not getting the output i need.

 In the below example, The decod value='lymph' is populating for next OBS where bodsys='clsd'

Output needed;

output needed;

Bodsys     decod         sev 

blsd                            mild
blsd                          moderate
blsd                          severe
blsd        anae
blsd       anae           mild
blsd     anae             moderate
blsd      anae            severe
blsd       lymp
blsd      lymp             mild
blsd      lymp           moderate
blsd      lymp             severe

clsd                            mild
clsd                          moderate
clsd                          severe
clsd       cnae
clsd      cnae           mild
clsd     cnae            moderate

clsd     cnae            severe

data one;
input bodsys $4. +1 decod $4. +1 sev $8.;
datalines;
blsd      mild
blsd      moderate
blsd      severe
blsd anae  
blsd      mild
blsd      moderate
blsd      severe
blsd lymp 
blsd      mild
blsd      moderate
blsd      severe
clsd      mild
clsd      moderate
clsd      severe
clsd cnae  
blsd      mild
blsd      moderate
blsd      severe
;

data want;
 set one;
 retain hold;
 if not missing(decod) then hold=decod;
 decod=hold;
run;

output getting;

Bodsys     decod         sev 

blsd                            mild
blsd                          moderate
blsd                          severe
blsd        anae
blsd       anae           mild
blsd     anae             moderate
blsd      anae            severe
blsd       lymp
blsd      lymp             mild
blsd      lymp           moderate
blsd      lymp             severe

clsd      lymp             mild
clsd     lymp              moderate
clsd     lymp              severe
clsd       cnae
clsd      cnae           mild
clsd     cnae            moderate

clsd     cnae            severe

[art297]

You didn't show what you want in such a situation, but it might be:

data want (drop=hold);
 set one;
 length hold $4;
 by bodsys notsorted;
 retain hold;
 if first.bodsys then call missing(hold);
 if not missing(decod) then hold=decod;
 decod=hold;
run;

Art, CEO, AnalystFinder.com