How to fill out blanc fileds with the last value populated

Aljosa — Tue, 19 May 2020 09:50:25 GMT

Hi all,

I have a column named ID filled out like this (with blancs):

data have;
input ID $;
infile datalines missover;
datalines;
1       
2      
3


4
5       
 
;

I would like to fill out all blancs with the last value populated, so the column I want would look like this:

data want;
input ID $;
infile datalines missover;
datalines;
1       
2
3
3
3
4
5
5
;

Thank you for your help. Kind regards

Re: How to fill out blanc fileds with the last value populated

ed_sas_member — Tue, 19 May 2020 09:52:56 GMT

Here is one approach to achieve this:

data want;
	set have;
	retain _ID;
	if not missing(ID) then _ID = ID;
	drop ID;
	rename _ID = ID;
run;

Best,