I have attached a sample EXCEL file that consists of 3 columns with all numeric, and a 2nd column is a trouble.
proc import datafile = "C:\test.xls"
out = _null11111_ replace dbms = excel ;
getnames = no;
range = "sheet$A6:c53";
dbdsopts="dbsastype=(F2='numeric')";
run;
After running as above code, I can find that something wrong with 2nd column.
Only 2nd column is imported as integer number. I don't know why.
The odd thing is that when I run SAS with opening Excel file, SAS can import all columns correctly.
Of course, I know that I can handle this problem by editing Excel file, but I would like to fix it with no editing Excel file.
Thanks for reading.
... View more
