But you should post your example data as a DATA step with DATALINES. Such a piece of code can easily be copy/pasted into the program editor and submitted (and leave no questions about real content and variable attributes), while the Excel file needs to be downloaded (which is often prohibited in corporate environments for security reasons), then uploaded to the SAS environment, and finally imported (where the vagaries of PROC IMPORT often cause the dataset to be different from yours).
... View more