Hi,
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!
Somehow I couldn't repeat your problem. I am running SAS 9.2 on XP pro box.
Haikuo
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.
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!
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: