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
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.
I think you should post some contents of original file to judge .
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.