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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.