topic deleting duplicate rows from dataset in SAS Enterprise Guide

deleting duplicate rows from dataset

reddy19 — Thu, 26 May 2011 23:04:18 GMT

Hi,

I'm exploring enterprise guide...I would like to know how to eliminate duplicate records from external file (XL or CVS).

And also how would i delete entire row if one colum is empty using EG 4.1.

Thanks,
reddy

Re: deleting duplicate rows from dataset

ChrisHemedinger — Fri, 27 May 2011 12:06:29 GMT

You can easily do this with the Query Builder. Specify the columns you want, tick the box to get "distinct" records only, and set a filter to eliminate values that are MISSING (or NULL, as I think was used in the 4.1 query builder terminology).

The output table would have the result you want.

Chris

Re: deleting duplicate rows from dataset

reddy19 — Fri, 27 May 2011 16:46:11 GMT

Hi Chris,

I'm able to take distinct records from the table...could you please explain in detail about applying filter for missing values,

Thanks,
Reddy

Re: deleting duplicate rows from dataset

reddy19 — Fri, 27 May 2011 18:06:16 GMT

Thanks Chris.

Finally i'm able to figure it out.

deleting duplicate rows from dataset

coba — Tue, 06 Dec 2011 14:45:52 GMT

How did you manage?

Re: deleting duplicate rows from dataset

SASuserxx — Thu, 29 Oct 2015 01:59:12 GMT

Hi CHris,

how do you set filter to 'eliminate value'?

im using eg 5.1 and trying to delete duplicate in my dataset