https://communities.sas.com/t5/SAS-Visual-Analytics/Importing-Excel-file/m-p/445469#M9677 <P>&nbsp;The most common reason why a numeric column is imported as character is that there is a non-numeric character somewhere in the column. Even a single blank space in a cell can cause this. What I usually recommend is to convert the file to CSV. In the Import Data dialog, select to scan only rows that have <EM>visible</EM> values. This usually eliminates any issues with blanks.</P> Wed, 14 Mar 2018 13:18:55 GMT Madelyn_SAS 2018-03-14T13:18:55Z https://communities.sas.com/t5/SAS-Visual-Analytics/Importing-Excel-file/m-p/445440#M9676 <P>Hi everyone,</P><P>&nbsp;</P><P>I am trying to upload an Excel file as a data source in the report designer.</P><P>The problem is that I have numeric values (which suppose to be measures), SAS VA is considering some of these values as Categories and others as Measures.</P><P>I tried to copy right format (from the measurment columns) to the categories columns, changing the format to numeric and nothing works.</P><P>When I replace these categories values with values that I enter by hand, it works.</P><P>Can anyone help please?</P> Wed, 14 Mar 2018 11:24:06 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Importing-Excel-file/m-p/445440#M9676 salamabdeen 2018-03-14T11:24:06Z https://communities.sas.com/t5/SAS-Visual-Analytics/Importing-Excel-file/m-p/445469#M9677 <P>&nbsp;The most common reason why a numeric column is imported as character is that there is a non-numeric character somewhere in the column. Even a single blank space in a cell can cause this. What I usually recommend is to convert the file to CSV. In the Import Data dialog, select to scan only rows that have <EM>visible</EM> values. This usually eliminates any issues with blanks.</P> Wed, 14 Mar 2018 13:18:55 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Importing-Excel-file/m-p/445469#M9677 Madelyn_SAS 2018-03-14T13:18:55Z