06-05-2012 10:29 AM
I'm using PROC IMPORT to bring an Excel file into SAS. The Excel file is formatted to only display 2 decimals, however, the actual number goes out to 16 decimal places. When I import this file into SAS, it'll only bring in the number with two decimal places. Is there any way to read in all the decimal places, without having to change the Excel file to display all the numbers?
Thanks for any help you can provide!
06-05-2012 11:27 AM
hmm...interesting. I tried it with another file and it's working correctly. I'll have to look into this specific Excel file to see why it's not reading in correctly.
Thank you for looking into it.
06-05-2012 12:25 PM
For those who encounter this issue in the future, if the variable is formatted as currency in Excel, then SAS will only read in that variable to 2 decimal places, even if the decimal place goes out further. The only solution I see is to format the variable as a general number in Excel. Any other suggestions are welcome!