09-20-2016 06:14 PM
I am somewhat new to SAS. I am working on a project and am hoping to get some ideas and or instruction on how to best go about it.
I have several vendors that submit 4 files per month to me. I would like to create a SAS application that would import the files and then append each vendor's file as they are received. I want to keep each vendor's submission in a seperate file. Once the files are imported, I want anybody that access the application to be able to run a query that I will create utilizing a date parameter that they input.
I also would like to create a stored process (I think this would work) that would automatically search a particular directory and automatically import the files once they are downloaded. Looking forward to reading your response!!
09-20-2016 07:01 PM
Your process seems relatively straightforward. Before trying to automate or standardize get the whole process working for hard coded data files. This way you can find out where all your issues are before automation, rather than trying to debug multiple things at once. Afterwards you can work on transitioning it to an automated script.
Things to keep in mind: