@liju wrote: I am trying to import an excel data with a variable contains both numeric and alpha numeric values. Unfortunately SAS determinies the variable type by looking at first observations and the variable got converted to Numeric type. Hence the alpha numeric values are not appearing in the imported data in SAS. Is there any way to import the data in specific format that we define.     Minor correction in understanding of what is going on: Excel tells SAS what the variables are and uses a very small number of rows to determine whether to consider character. This type of behavior is one reason why Excel is generally a poor medium for interchanging data. ... View more