DATA Step, Macro, Functions and more

Copy/paste Excel files via SAS

Reply
N/A
Posts: 0

Copy/paste Excel files via SAS

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
Valued Guide
Posts: 2,177

Re: Copy/paste Excel files via SAS

Posted in reply to deleted_user
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
N/A
Posts: 0

Re: Copy/paste Excel files via SAS

That's exactly what I need, thanks a lot, it's appreciated.
Ask a Question
Discussion stats
  • 2 replies
  • 159 views
  • 0 likes
  • 2 in conversation