topic Copy/paste Excel files via SAS in SAS Programming

Copy/paste Excel files via SAS

deleted_user — Tue, 08 Feb 2011 15:40:08 GMT

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

Re: Copy/paste Excel files via SAS

Peter_C — Tue, 08 Feb 2011 16:13:24 GMT

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

Re: Copy/paste Excel files via SAS

deleted_user — Wed, 09 Feb 2011 15:32:59 GMT

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