Don't use a character informat in the first place? Remove the $ sign, I would also use the DSD option and Truncover on my infile statement. data get_data; Length Supplier $20. City $20. Item Category $20.; format cost revenue unit_price dollar12.; informat cost revenue unit_price dollar12.; infile " file location of the excel where it is located" DSD truncover; Input Supplier $ City $ Item Category $ Month $ Cost Revenue Unit_Price Units_Available Units_Sold; run; proc print; run;
... View more