topic Deleting first row using ID in SAS Programming

Deleting first row using ID

Jessica98 — Thu, 12 Jun 2014 04:54:25 GMT

Hi guys,

I need some help with a code to delete the first row using unique ID, this is my data

ID	month	day	income
1	1	1	20
1	1	2	40
1	3	1	21
1	3	2	56
1	3	3	54
1	4	4	23
4	1	1	5
4	1	2	3
4	2	3	4
4	2	4	5
4	3	5	65
6	2	1	86
6	2	2	34
6	3	3	23
9	7	1	65
9	7	2	54
9	8	3	99
9	8	4	12
9	8	5	33
9	9	6	65
9	9	7	23
13	1	1	12
13	2	2	65
13	2	3	32

I want to delete the rows marked in red, that is the first row of each unique ID, any ideas?

Jessica

Re: Deleting first row using ID

Scott_Mitchell — Thu, 12 Jun 2014 05:26:42 GMT

Hi Jessica,

Use by group processing and if not first.id.

Regards,

Scott

Re: Deleting first row using ID

Jessica98 — Thu, 12 Jun 2014 05:33:26 GMT

Hi i did try this,

if first.id then delete;

but it does not work, am i doing anything wrong?

jessica

Re: Deleting first row using ID

Chrishi — Thu, 12 Jun 2014 05:40:36 GMT

Hi Jessica

You have to sort and use a by statement before using if then delete. it should work just check for them still if you are facing problem please present the full code so that we can help. The statement you have mentioned above is fine.

Sudeer

Re: Deleting first row using ID

Jessica98 — Thu, 12 Jun 2014 05:46:21 GMT

i have done the sorting, it says "Variable FIRST.id is uninitialized" . I have a very simple code,

DATA data_1 ;

SET data;

IF first.id then delete;

run;

Re: Deleting first row using ID

Jessica98 — Thu, 12 Jun 2014 05:56:39 GMT

I got it guys! thanks a lot.

Re: Deleting first row using ID

Jchapman — Thu, 12 Jun 2014 14:36:43 GMT

require by statement.

DATA data_1 ;

SET data;

IF first.id then delete;

by id;

run;

Re: Deleting first row using ID

Reeza — Thu, 12 Jun 2014 14:38:26 GMT

Please consider marking the question answered

Re: Deleting first row using ID

Jessica98 — Thu, 12 Jun 2014 14:44:45 GMT

sorry about that, i have marked it.