topic Re: Query Builder - Display Distinct Rows Based On ID in SAS Enterprise Guide

Query Builder - Display Distinct Rows Based On ID

Fistful_Dollars — Wed, 27 Sep 2017 00:04:19 GMT

How do I display only distinct accounts/IDs? Right now the output pops out dozens of the same exact row, except certain columns have different dates.

Re: Query Builder - Display Distinct Rows Based On ID

FredrikE — Wed, 27 Sep 2017 06:03:44 GMT

Just keep the ID column 🙂

Then use the resulting table to join with other data you need.

//Fredrik

Re: Query Builder - Display Distinct Rows Based On ID

Fistful_Dollars — Wed, 27 Sep 2017 15:42:27 GMT

Great, thank you FredrikE. Worked very well. I created another query(see below) to use only for joining. There was another column ID I needed. I used the MAX function for that column so there would be no repeat IDs from the first column, and because I only need the highest number for that variable.