topic Re: deleting a row in SAS Programming

deleting a row

wajmsu — Tue, 31 May 2016 02:45:59 GMT

Hi,

Below is a table with matched dataset (cases and controls). Out of the five cases, first four cases have a duplicate case with missing values for all variables. How can I delete these row?

Thanks

Group	Type	Control Id	id	age	edu	race	parity	wt	ht	opwo	fev
1	Case	.	.	.	.	.	.	.	.	.	.
1	Case	.	5	32	9	1	0	90	5.2	1	1
1	Control	1	70	32	9	1	0	90	5.2	1	0
1	Control	2	99	35	10	1	0	90	5.2	0	0
2	Case	.	.	.	.	.	.	.	.	.	.
2	Case	.	12	35	12	1	2	110	5	0	1
2	Control	1	43	35	12	1	1	110	5	0	0
2	Control	2	101	33	11	1	2	110	5	0	0
3	Case	.	.	.	.	.	.	.	.	.	.
3	Case	.	22	25	14	3	0	110	5.4	0	1
3	Control	1	125	25	13	3	0	110	5.4	0	0
3	Control	2	51	28	12	3	0	110	5.4	0	0
4	Case	.	.	.	.	.	.	.	.	.	.
4	Case	.	29	27	12	2	1	95	5	1	1
4	Control	1	32	29	12	2	2	125	6.2	1	0
4	Control	2	31	27	10	2	1	95	5.5	0	0
5	Case	.	40	28	10	3	2	130	6	1	1
5	Control	1	58	28	10	3	2	130	6	0	0
5	Control	2	93	27	11	3	2	130	6	1	0

Re: deleting a row

PGStats — Tue, 31 May 2016 03:15:38 GMT

data want;
set have;
where id is not missing;
run;

Re: deleting a row

Ksharp — Tue, 31 May 2016 03:31:21 GMT

if cmiss(ControlId,id,age,edu,race,parity,wt,ht,opwo,fev)= 10  then delete;

Re: deleting a row

wajmsu — Thu, 02 Jun 2016 03:28:13 GMT

Hi Ksharp,

Please confirm 10 represents the number of variables in the parentheses.

thanks

Re: deleting a row

wajmsu — Thu, 02 Jun 2016 03:30:40 GMT

Hi PGStat,

I understand the code will keep thosr rows which do not have missing values. In that scenario, my all cases have first column with missing value. I am afraid it will delete that caso also and this way my all cases would be lost. Please guide me.

Thanks

Re: deleting a row

Ksharp — Thu, 02 Jun 2016 03:34:22 GMT

Yes. Confirm. I thought you know function CMISS() , didn't you ?