Re: deleting duplicate rows from dataset

reddy19 · Posted 05-26-2011 07:04 PM

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

ChrisHemedinger · Posted 05-27-2011 08:06 AM

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

SAS For Dummies 3rd Edition! Check out the new edition, covering SAS 9.4, SAS Viya, and all of the modern ways to use SAS!

reddy19 · Posted 05-27-2011 12:46 PM

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

SASuserxx · Posted 10-28-2015 09:59 PM

Hi CHris,

how do you set filter to 'eliminate value'?

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

reddy19 · Posted 05-27-2011 02:06 PM

Thanks Chris.

Finally i'm able to figure it out.

coba · Posted 12-06-2011 09:45 AM

How did you manage?

deleting duplicate rows from dataset