topic Re: Question regarding deleting missing values from two coloumns in SAS Programming

Question regarding deleting missing values from two coloumns

mehul4frnds — Tue, 03 Apr 2018 13:47:22 GMT

Hi,

I have a BP data where some of the id have missing data. I want to delete only those rows where both the values(SBP and DBP) are missing.

My data look like this

data have ;

id date SBP DBP

1 1/1/2011 122 84

1 2/1/2011 . .

1 3/1/2011 120 82

1 4/1/2011 . 86

2 1/1/2011 110 76

2 2/1/2011 146 88

2 3/1/2011 140 .

2 4/1/2011 . .

3 1/1/2011 124 80

3 2/1/2011 . 88

3 3/1/2011 130 90

I want data like this

data want

id date SBP DBP

1 1/1/2011 122 84

1 3/1/2011 120 82

1 4/1/2011 . 86

2 1/1/2011 110 76

2 2/1/2011 146 88

2 3/1/2011 140 .

3 1/1/2011 124 80

3 2/1/2011 . 88

3 3/1/2011 130 90

;

Kindly suggest

Thanks in advance.

ballardw — Tue, 03 Apr 2018 14:17:12 GMT

data want;

set have;

if not missing(SBP) and not missing(DBP);

run;

novinosrin — Tue, 03 Apr 2018 14:23:02 GMT

data want;
set have;
where coalesce(SBP,DBP)>.;
run;

mehul4frnds — Thu, 05 Apr 2018 13:28:26 GMT

Thanks it worked

mehul4frnds — Thu, 05 Apr 2018 13:29:51 GMT

Thanks or the reply.

This command deletes all the rows which have any of the missing values.