@Edulearnx wrote: Hi Everyone, I’m importing an Excel file using PROC IMPORT in SAS 9.4, but the numeric columns with decimal values are being read as character or getting truncated. I’ve tried using DBSASLABEL=NONE and even increased the GUESSINGROWS, but the issue still happens. Some columns mix numbers and text, but others are just decimals and they still don’t import cleanly. Is there a better way to control the column types during import, or is it better to switch to libname with XLSX? Thanks! Thank you for all 👍 my issue got solved.. Regards, Rovmen
... View more