If you have the boundary files (spatial files such as SHP) for your postal codes look at GINSIDE to map the points to a spatial area. This will be more accurate than a distance method.  ... View more

Ok gotcha. Thanks for the quick reply. Makes sense...was just trying not to get tickets from end users, but you gave me an idea I will play around with.       ... View more

Thank you so much! ... View more

@Matthijs wrote: Thank you very much! This is very helpfull. I guess your original problem came from the fact that you asked yourself 'How do I deal with the last of the month?' Instead I took the approach 'How do I deal with the first of a month', which is easier to detect and maybe handle.   It has often happened to me that approaching a problem from the "reverse side" led me to an easier solution. ie using last. instead of first. or vice-versa. ... View more

I was too slow on the draw. The only thing I would add to the solution is to make sure your data is properly sorted. Specifically be careful with date sorting. Based on the current format 02-03-2016 would be sorted as earlier than 11-03-2010. ... View more

I am not familiar with AMO for inpace excel editiong, so it may be a better solution.   If you want to update excel in place the options are limited. If the first column is a primary key you can use 'SQL' passthru and and add rows(at the end) and I believe change individual cell values. I do not think it is possible to insert a row or reorder the data using SQL passthru.   You may have to create a named range.   Microsoft Excel drives have limitations, excel is not a relational database.   I have some posts on this in SAS-L.   R/Python  are quite flexible and R can read SAS datasets.    R/Python may have some usefull packages. For instance R/Python can create named ranges, read cell formattinng...       Anthig is possible if you load the data into SAS and create a and write a new sheet. ... View more

Good to know! ... View more