Longer but you have more control is to save the Excel file as CSV and then import that. There will be data step code generated in the log that can be copied and modified to provide much more control than proc import allows for excel files such as custom informats, length of character variables, assigning labels. Also additional calculations or custom warnings for data ranges can be added to the code. Since I deal with entry people who will type 'Missing' into a cell that is supposed to be numeric or a value plus text such as "100 weekly" I find this approach more effective in the long run.
... View more
