Hi, I am needing to import dozens of Excel documents (not different worksheets within a single document) into one SAS library simultaneously. Otherwise I will be here all day importing them one by one. Is there a quick way to do this? Thanks!
Seems like a Macro waiting to happen. But you would be here all day and then some if you were waiting for me to correctly write it.
If all of the files are in the same folder can you just write the code with Import Wizard and than just change source names and new names in that syntax. Not sure if dozens mean a couple or more, so this may or may not help.
Itddoo (08-23-2012)
I think a macro is the only way to do this.
"Facts are stubborn things, but statistics are more pliable." Mark Twain
Itddoo (08-23-2012)
Posting Permissions
|
|
Reply With Quote