topic Re: Filling missing strings form non-missing strings in SAS Programming

Filling missing strings form non-missing strings

Zakir — Fri, 17 Sep 2021 14:25:41 GMT

Dear All,

Good day. I have the following dataset where I am unable to fill the missing strings. Any help would be highly appreciated.

Exe_name ceoann gvkey year

Bob CEO 1045 1992

Bob CEO 1045 1993

Bob 1045 1994

David 1004 1992

David CEO 1004 1993

David CEO 1004 1994

James 9999 1992

James CEO 9999 1993

James 9999 1994

Thanks in advance.

Kind regards,

Zakir

Re: Filling missing strings form non-missing strings

PaigeMiller — Fri, 17 Sep 2021 16:12:10 GMT

This seems like a very unusual example. It seems like you want to place CEO everywhere it is missing. Is that what you want? If so ...

data want;
    set have;
    if missing(ceoann) then ceoann='CEO';
run;

Re: Filling missing strings form non-missing strings

Jagadishkatam — Fri, 17 Sep 2021 15:00:55 GMT

Proc sort data=have;
by exe_name descending ceoann;
run;

data want;
set have(rename=(ceoann=_ceoann));
by exe_name descending  _ceoann;
retain ceoann;
if first.exe_name then ceoann=_ceoann;
run;

Re: Filling missing strings form non-missing strings

Ksharp — Sat, 18 Sep 2021 12:22:57 GMT

data want;
merge have have(keep=exe_name ceoann rename=(ceoann=new_ceoann) where=(new_ceoann is not missing));
by exe_name;
run;

Re: Filling missing strings form non-missing strings

Zakir — Mon, 20 Sep 2021 04:26:44 GMT

Thank you so much Jagadishkatam.

Best

Zakir