Hello everyone, I have a excel file with one column, I want to import it into SAS and get an character variable,I attached the excel file. My problem is : if I opended the excel file then run the SAS code, the variable will be like 0.745 for the first obs ,but if I close the excel file then run the SAS code ,the value of the first obs will be changed to 74.5%. Could anyone help me point out the reason of the problem? Thanks! Mike PROC IMPORT OUT= _test2 datafile="c:\temp\oops.xls" DBMS=EXCEL REPLACE; GETNAMES=YES; MIXED=YES; USEDATE=YES; SCANTIME=YES; RUN;
... View more