Hello, I'm struggling with importing multiple Excel Files into SAS onDemand for Academics. I'm using the Robintrack dataset and havelaready unpacked it on my PC. Now I have 8597 Excel files in my PC folder, which are all named according to the respective stock. Can someone help me to write an Macro to import all Excel files into one SAS table with an additional Variable which has the stockname in it? To import one file is not a problem but I'm not able to import all files at once in a macro, too save them all in one SAS table and to give assigne them a new variable which has the corresponding stock name. Thanks a lot!!!
... View more