Import the amount with %

[SASdevAnneMarie]

Hello Experts,

In my xlsx file I have this kind of data :

When I do the proc import, I have this result :

Do you know please, how to import the xlsx file in correcte way please to have the correct appearance of amount with % ?

Thank you !

[Kurt_Bremser]

The text in the first row forces the variable to be character, and the numbers are taken as raw values; since you also seem to have a numeric precision artifact in Excel, you get the funny representation.

Best remedy for such mixed data: save the file as csv, and read it with a data step where you can deal with "special" values.

What would you expect to get from the first row?

[SASdevAnneMarie]

Thank you, Kurt.
I would like to have the same values as in my file in the data sas.

[Kurt_Bremser · Accepted solution]

Save from Excel as csv, inspect the file with a text editor, and read it with a data step.

[SASdevAnneMarie]

Thank you, Kurt !

[GraphGuy]

Are you allowed to edit the Excel file?

If so, try creating an extra column, and add any "explanatory text" (such as "avec un mini de 50...") to that extra column. Once the numeric data column has only numeric data in it, it should be much easier for SAS to import.