topic Re: How to Populate the missing values with baseline result in New SAS User

How to Populate the missing values with baseline result

Haricasas12 — Sat, 04 Sep 2021 11:09:25 GMT

Populate the missing values with baseline result where consider Visit=V1 as baseline.

USUBJID	PARAM	_NAME_	V1	V2	V3	V4
10	SYSBP	AVAL	100	120	130	110
20	SYSBP	AVAL	90	100	120	.

Re: How to Populate the missing values with baseline result

PaigeMiller — Sat, 04 Sep 2021 11:33:42 GMT

In a DATA step

if missing(v4) then v4=v1;

Re: How to Populate the missing values with baseline result

sbxkoenk — Sat, 04 Sep 2021 11:37:20 GMT

Here you are:

data have;
input USUBJID $ PARAM $ _NAME_ $ V1 V2 V3 V4;
cards;
10	SYSBP	AVAL	100	120	130	110
20	SYSBP	AVAL	90	100	120	.
;
run;

data want(drop=i);
 set have;
 array vs{*} V:;
 do i=2 to dim(vs);
  if vs(i)=. then vs(i)=v1;
 end;
run;
/* end of program */

Koen

Re: How to Populate the missing values with baseline result

Haricasas12 — Sat, 04 Sep 2021 11:51:16 GMT

Thanks a lot.. Its working.. Can briefly explain the code.. how is it working

Re: How to Populate the missing values with baseline result

sbxkoenk — Sat, 04 Sep 2021 12:06:01 GMT

Hello,

It's (data step) array processing.

You put all the variables starting with the letter 'V' in a numerical array (the colon : is a wildcard to avoid putting V1 V2 V3 V4).

You then use a do-loop to screen V2, V3 and V4 for a missing value. If missing, put the value of V1.

Kind regards,

Koen

Re: How to Populate the missing values with baseline result

Haricasas12 — Sat, 04 Sep 2021 17:25:51 GMT

Thank you so much for explanation..