Allright, so I have a project to create a lot of datasets and those datasets have to go to a lot of different locations. Each dataset has his own interval (once a week, once a day, once a month, etc). At the same time, all of this is and will stay under development, meaning every now and then there will be new datasets to copy to new locations. We use SAS eg on a linux server environment and till now, I use the "Copy Files" task to get datasets to our windows environment. This means one Copy Files for every dataset-location combination. My goal is to not have to use those specific "Copy Files" tasks. I don't want to manually have to create a Copy Files everytime my collegues make a new dataset. I want to ask them to write the dataset name in a spreadsheet, write down the location of the spreadsheet and I want the Copy Files funtionality to be able to use this input and export all the files. I've tried working with proc export, this is limit to the Linux environment only so this is not an option. I thinks assigning a library is also not going to work because of the server. I also tried giving a list of files and locations to the Copy Files but couldn't get that to work. Any help would be appreciated!
... View more