No, the point is to not use Excel. That proc import code you have may seem wonderful, but I can guarantee after 1 or two runs you will be changing your code. Excel's biggest selling point is that you can doing anything you want in any cell, this is exactly the reason why, anyone who deals with data will hate the use of it. Several examples come to mind, changing column orders, multiple formats in cells, special characters, blank rows/headers. In fact until recently you could get differing results importing the same file twice. Again I would strongly recommend changing the file format to CSV (which can also be read in Excel) and then writing a datastep import rather than a guessing procedure.
... View more
