Formatting with condition

darkmoon178 — Tue, 14 Apr 2020 01:43:00 GMT

Hi everyone,

I'm trying to work with this dataset:

The original data having companies stack on top of each other, and it can only be separated if Id= 'H'

And here is the result that I want:

Any suggestions for my problem?

Thank you for reading. Have a good day!

Re: Formatting with condition

Tom — Tue, 14 Apr 2020 01:58:44 GMT

Use a RETAINed variable.

data want;
  set have;
  if id='H' then company=value;
  retain company;
run;