import error

[DerekChan]

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

import script

[art297]

Unless you've created a macro variable priror to the macro you showed, with the name yymmdd, I don't see how that code could run.

[Ksharp]

I think you should post some contents of original file to judge .

[Doc_Duke]

DerekChan,

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.

Doc Muhlbaier

Duke