selecting first obs of a combination

[ilikesas]

hi,

suppose that I have the following table already sorted in this specific way:

company	date	number
A	31/11/2010	1
A	31/11/2010	2
B	22/1/2009	2
C	1/1/2008	1

I just need the first row for each company-date combination so that the final result is:

company	date	number
A	31/11/2010	1
B	22/1/2009	2
C	1/1/2008	1

thank you!

[ilikesas · Accepted solution]

omg this is so simple that I just didn't think about it, I just do proc sort with nodupkey by company and date!!

[AnnaBrown]

Thanks for coming back to post your solution, ilikesas!