Copy/paste Excel files via SAS

[deleted_user]

Hi everyone,

I'm looking for help on the following:
Within my SAS code, I want to copy an existing Excel file from one directory to another.
The background is, the existing file is an empty template which should then be populated by data from the SAS code in that new directory.

Any help is appreciated.
Thanks,
Holger

[Peter_C]

Would a binary copy do what you need?
X copy "oldpath/old template" "new path/new template" ;
but probably not in SAS Enterprise Guide.
SAS code could do this but the X copy seems much simpler and is probably faster.

peterC

[deleted_user]

That's exactly what I need, thanks a lot, it's appreciated.