Hi Kiran, Although may not be related to topic but your example is what I was looking for. If you do the same syntax in an sql server the result would be 123 345 23SEP1974 224 601 22SEP1974 It is major difference I have seen while trying to filter based on max/min group by. In SAS you would need following code proc sql; create table abcs as select distinct profile_number, sas_id, date as mindate format=Date9. from a group by profile_number having date = min(date) ; quit; I don't know how many types of SQLs are there but I tried on some online websites and they give filtering without using having. Just wanted to confirm if this is a documented difference with SQL and proc SQL or different SQLs ( MYSQL oracle) also behave differently. Regards Jaskeerat
... View more