12-28-2011 10:59 PM
there are a error when importing the file by script. (You can see row 107 - 120)
But it is alright when file is imported manually.
correct result from manual import
wrong result from script import
01-02-2012 10:59 AM
I agree with Ksharp that we don't have enough information to help directly. However, you could try the Enterprise Guide Data --> open task to get the spreadsheet into SAS. EGuide has much better Excel data handling than PROC IMPORT.