Subscribe Bookmark RSS Feed

Delete multiple rows in a data table

antoinesofradir

Community Trekker

Joined:

Apr 26, 2013

Hello,

My question is in the title !
How can i delete multiple rows in my data table's column ?

Thanks for your help !

1 REPLY
nishunksaxena

Community Member

Joined:

May 27, 2013

Hi try this

suppose your data is table my_data as

col1 col2

1     2

2     3

1     2

Sort first as

proc sort data=my_data noduplicates; by col1; run;

then my_data will have

Col1 col2

1     2   

2     3

Hope that helps.........Thanks