@me.turcotte: Actually, in answer to your question, there are usually a number of ways to achieve what one needs to accomplish. In fact, your question gives me an opportunity to promote a paper that a group of us did for SGF2012, and which I will be presenting again at the MWSUG meeting in September. The paper is called "Copy and Paste Almost Anything" and was written to give users a lot more control during an import than proc import allows for any file type. Its one catch, but which was really a feature, is that it only works with tables that one has copied to their system's clipboard. In the case of an Excel file, that simply means bringing up Excel, highlighting all of the columns by left clicking on the letter A (at the top left of the table) and, while holding the button down, dragging the mouse across the table until all columns (that contain data) are highlighted, and then clicking on copy. The code allows one to specify the informats and formats they want to use for every column. It has a number of other neat features, but they aren't relevant for your question, The paper and code can be found at: http://www.sascommunity.org/wiki/Copy_and_Paste_Almost_Anything Art
... View more