How about: proc import datafile='c:\Test_Data.xls' out=test dbms=excel replace; usedate=no;scantime=no; run; data temp(drop=_date); set test(rename=(date=_date)); date=input(_date,datetime20.); format date datetime.; run; proc sql; create table want as   select * from temp    group by customer_id     having date=max(date); quit; Ksharp ... View more

If SAS put Enterprise Miner into Base SAS then they couldn't license EMiner.  That is a business decision, not a technical one. There is one technical side to it, however.  Many of the EMiner algorithms do not have closed form solutions; they require the use of itterative search algorithms.  To implement them effectively, the data needs to be in memory and that runs contrary to one of SAS' core strengths -- it's ability to handle arbitrarily large data sets.  EMiner uses the SEMMA approach (see its documentation) to break the data into smaller pieces and circle in on a reasonable approximate answer.  That is appropriate for activities that are necessarily approximate, but not for things that should have closed form solutions. Doc Muhlbaier Duke ... View more

If I was in your position, I would think of a very simple macro in Excel. Select the Range Cell( A,B) - Cell (X,Y) - Fromat them as Number if store as Text. Simple the job gets done in mater of minutes. You can also convert the headers to DATE format in Excel Macro - select the right rigne is what matters. ... View more

This requires you to have a license for SAS/IML (proc iml) and SAS/OR (proc netdraw).  This was code previously written by SAS to aide in performing tree type discrimination analysis.  It lost support a long time ago, I believe, and was removed from their site. ... View more

You could automate using the google translate restful services.  However, you will need to license this functionality, of course.  Here is a link to the pricing, it is quite reasonable, in my opinion. http://code.google.com/apis/language/translate/v2/pricing.html ... View more