https://communities.sas.com/t5/SAS-Data-Management/Numeric-data-imported-from-excel-appears-as-Char/m-p/529963#M16385 You can't control that from SAS, at least not easily. If this is one time, check the Excel file and make sure that if you test with isnumber() the fields return TRUE. <BR /><BR />Otherwise, convert to CSV and write a data step to read the data. Fri, 25 Jan 2019 03:37:06 GMT Reeza 2019-01-25T03:37:06Z https://communities.sas.com/t5/SAS-Data-Management/Numeric-data-imported-from-excel-appears-as-Char/m-p/529959#M16383 <P>I imported an excel data but all the numeric variables appears as character.</P> <P>How do I change all the variables to numeric. They are more than 200.</P> Fri, 25 Jan 2019 03:31:18 GMT https://communities.sas.com/t5/SAS-Data-Management/Numeric-data-imported-from-excel-appears-as-Char/m-p/529959#M16383 desireatem 2019-01-25T03:31:18Z https://communities.sas.com/t5/SAS-Data-Management/Numeric-data-imported-from-excel-appears-as-Char/m-p/529961#M16384 <P>Please provide more information. What is the code? What is the structure of the data that you are importing? Which variables are character when they should be numeric?</P> Fri, 25 Jan 2019 03:33:05 GMT https://communities.sas.com/t5/SAS-Data-Management/Numeric-data-imported-from-excel-appears-as-Char/m-p/529961#M16384 pink_poodle 2019-01-25T03:33:05Z https://communities.sas.com/t5/SAS-Data-Management/Numeric-data-imported-from-excel-appears-as-Char/m-p/529963#M16385 You can't control that from SAS, at least not easily. If this is one time, check the Excel file and make sure that if you test with isnumber() the fields return TRUE. <BR /><BR />Otherwise, convert to CSV and write a data step to read the data. Fri, 25 Jan 2019 03:37:06 GMT https://communities.sas.com/t5/SAS-Data-Management/Numeric-data-imported-from-excel-appears-as-Char/m-p/529963#M16385 Reeza 2019-01-25T03:37:06Z