Yeah, the documentation step was a bit of a pain but I'm pretty militant on that 🙂 And fairly good at documenting my code for something that large because I know I won't remember it in a years time. ... View more

Here's an alternative that uses your original version of the data: data have; infile datalines dsd; length policynumber $ 10; input policynumber @@; datalines; m2227eqw,wy3747387,hsdahah schaxnbbxc 847e7w87 47ew7837 ds6778989 fg848484,rt222222,y72378w ; This code doesn't count the policy numbers, because your original code didn't count them.  But it does give you each policy number as a separate observation. Good luck. ... View more

May be this will help you PROC FORMAT; inVALUE $WEEK               'Saturday'=1                 'Sunday'=2      'Monday'=3      'Tuesday'=4      'Wednesday'=5      'Thursday'=6      'Friday'=7; QUIT; data have1; set have; date1=input(put(date,WEEKDATE9. -l),$week.); /*FORMAT DATE MMDDYY10.;*/ /*FORMAT DATE WEEKDATE9.;*/ RUN; Thanks, Jag ... View more

Set the GETNAMES option to YES in your libname. Eg :    libname doctors 'c:\clinicNotes\addresses.xlsx'  GETNAMES=YES ; Thanks Karthik ... View more

DATA DS1; INPUT DATE : DDMMYY10. AMOUNT COMMAMT INSENTIVAMT BONUSAMOUNT; FORMAT DATE  DDMMYY10.; CARDS; 31/01/2014  5000  6000  2345 4567 28/02/2014  6000  7000  5775 4587 30/03/2014  7000  8000  5464 4323 31/12/2013  3400  9000  2456 8970 30/11/2013  5000  6000  3456 7865 28/10/2013  6000  5000  4456 6758 28/05/2013  6000  7000  4563 7890 30/04/2013  7000  3400  6754 7856 31/03/2013  3400  5000  4567 2532 28/02/2013  5000  6000  7890 1324 31/01/2013  6000  3400  3456 3456 ;   RUN; proc sql ; select * into : date   from ds1    having date=max(date) union select *   from ds1    where year(date)+1 eq %substr(&date,7) and month(date)=%substr(&date,4,2)     having      date=max(date); quit; Xia Keshan Message was edited by: xia keshan ... View more

Not sure exactly what you want. But import the Excel file to SAS, do a three way  SQL join, and export the results back to Excel. ... View more

Please try proc export data = sashelp.class(keep=name) outfile='~path\name.xls' replace dbms=excel; run; Thanks, Jag ... View more