topic Re: Deleting Observations with Conditions in New SAS User

Deleting Observations with Conditions

MisterJenn — Sun, 13 Nov 2022 03:56:42 GMT

Not sure how to write this code. I am trying to answer this question:

Remove from the data set any observations where the date of delivery was recorded as before the date of admission to the hospital or after the date of discharge from the hospital.

When I use this code it says I have no observations:

date2 = date of delivery

date1 = date of admission to the hospital

dod = date of discharge

data dil_merge;
merge hw6.dil1 hw6.dil2_temp; 
by MEDRNO;
if xwtgainlb > 60 then delete; 
if xwtgainlb < 60 then delete; 
if date2 < date1 then delete; 
if date2 > dod then delete; 
run;

Re: Deleting Observations with Conditions

Kurt_Bremser — Sun, 13 Nov 2022 06:01:53 GMT

What are the values in xwtgainlb? Only exact values of 60 will not be deleted by your first two IFs.

Re: Deleting Observations with Conditions

tarheel13 — Sun, 13 Nov 2022 16:35:22 GMT

can you post your data?

Re: Deleting Observations with Conditions

fja — Sun, 13 Nov 2022 22:00:18 GMT

Hello!

A quick question: Does the code without the last to if clauses meet your expectations?

i.e. does the code:

data dil_merge;
merge hw6.dil1 hw6.dil2_temp; 
by MEDRNO;
if xwtgainlb > 60 then delete; 
if xwtgainlb < 60 then delete; 
run;

return the correct results.

If yes, then you needed to check on xwtgainlb as @Kurt_Bremser has already suggested.

--fja