topic Re: Import the amount with % in SAS Programming

Import the amount with %

SASdevAnneMarie — Fri, 29 Apr 2022 08:37:23 GMT

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 !

Re: Import the amount with %

Kurt_Bremser — Fri, 29 Apr 2022 09:03:27 GMT

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?

Re: Import the amount with %

SASdevAnneMarie — Fri, 29 Apr 2022 09:53:38 GMT

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

Re: Import the amount with %

Kurt_Bremser — Fri, 29 Apr 2022 10:21:01 GMT

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

Re: Import the amount with %

GraphGuy — Fri, 29 Apr 2022 11:36:13 GMT

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.

Re: Import the amount with %

SASdevAnneMarie — Fri, 29 Apr 2022 17:13:16 GMT

Thank you, Kurt !