@vThanu wrote: Using Call execute here we are invoking each file every time.... if we have more files those many times invoking is time taken process and for each extensionn we are invoking.... any other way
None that I'm aware of from any tool that I work with, which includes Python, R, or SAS.
If the files are structured exactly the same each time and there's a defined ETL process, you could streamline it for each type of files but not different types because they have to be handled differently. Reading all CSVs into a single file is easy - I have an example of that in the Library section of this website.
Excel is a pain because it doesn't enforce types so you will have to verify these files for each one to ensure you have the correct types needed.
MS Access is clean and easier because it enforces types, but each DB would need to be done separately as well.
Is this a one time process? Are you using SAS DI?
How different are the files? Why can't you import one at a time.
You can streamline the process for sure, having a process to scan the folder, find all the different file types and import each file type and save it within a single program. But not a single procedure.
... View more