topic Re: Filling in missing values in SAS Programming

Filling in missing values

maroulator — Wed, 16 Sep 2015 14:45:50 GMT

My data currently looks like this:

LoanId Product_Code

32456 Fixed-30

32456

75639 Fixed-15

75639

84732 Adjustable-Rate

84732

I need to fill in the blanks in the product_code variable so that my records have no blanks; please not that product_code is a character variable. Utlimately, I need my data to look like this.

LoanId Product_Code

32456 Fixed-30

75639 Fixed-15

84732 Adjustable-Rate

Any help would be extremely appreciated; thanks in advance.

Re: Filling in missing values

Jagadishkatam — Wed, 16 Sep 2015 14:54:56 GMT

I believe first. will be correct

Proc sort data=have;
by LoanId Product_Code;
run;

data want(rename=(product_code_=product_code));
set have;
by LoanId Product_Code;
retain product_code_;
if first.product_code then product_code_='';
if product_code ne '' then product_code_=product_code;
drop product_code;
run;

Thanks,

Jag

Re: Filling in missing values

ballardw — Wed, 16 Sep 2015 15:20:53 GMT

If you don't want to sort the data&colon;

data want;
   set have;
   if _n_=1 then lprod=product_code;
   retain lprod;
   if missing(x) then product_code= lprod;
   else lprod=product_code;
   drop lprod;
run;