I have no problems reading/copy an Excel file through Filename URL, like
filename dav URL "&input" debug recfm=s;
filename target "&target" recfm=n;
length x $32000 char $1;
infile dav length=len lrecl=32767 nbyte=nbyt;
nbyt = -1;
file target lrecl=32767;
do i = 1 to len;
char = substr(_infile_,i,1);
put char $char1. @@;
But when I try to write/copy an Excel file through Filename URL, I keep getting the error "URL/HTTP Access Method does not support Random mode".
Question is: How do I write(copy) an Excel file through Filename URL using data step ?
This is probably a question for Tech Support. You show the code that you use for reading the file, but you do not show the code you used for writing the file that generated the error message. Tech Support can look at your file and your code and help you figure out whether you can do what you want to do.
I saw your posting in that forum. I still think the quickest response would come from Tech Support. SAS has a publishing framework that would let you publish directly to a WebDAV repository, depending on the suite of products that you have available to you.