Use subquery. such as below   proc sql; select c1.make, c1.model, c1.invoice, ( select count(*) from sashelp.cars c2 where c2.make=c1.make and c2.invoice>=c1.invoice ) as rankings from sashelp.cars c1 order by c1.make,c1.invoice DESC ; run; ... View more

Thanks S.boeko. That's got it ! Cheers ... View more

Thanks Chris, I'll follow those up, good suggestions, Cheers. ... View more

Thanks data_null_; & Arthur, For some reason I didn't notice the option to select 'Date' instead of 'Date Time' ... Cheers ... View more

Thanks Patrick ! I had tried that using just '04' but didn't think to include the %, DUH ... ... View more

Thanks ballardw/Patrick, I'll give these a try.  :smileycool: ... View more

DATE() = TODAY() But TODAY() is indeed more self_documenting! ... View more

Thanks Bruno !! ... View more

Thanks Tom, I changed the PERCENT6 TO PERCENT8 & it now calculates correctly. Many thanks !! ... View more

Thanks ballardw ... View more

Thanks After a lot of testing the functions, I used DATDIF to manually subtract the date field value from 1st Jan 1960 which gave me a number, I could then match these number fields. I think that's what you were trying to tell me Reeza. This is a lot of messing about to sort such a simple issue out??? I thought I'd just have to truncate the HH:MM:SS off the date Time field & I'd get matches, but no ...  I used datepart to change the date from a normal date format to a number on the date/time field & then create a number from a date using datedif for the other table.   DATDIF('01jan60'd, my_date_field ,'act/act'). Thanks to both of you - surely there's an easier way ??? ... View more