HOWTO: reading/writing (or copy) Excel file through Filename URL

[GertNissen]

Hi all

I have no problems reading/copy an Excel file through Filename URL, like
[pre]
filename dav URL "&input" debug recfm=s;
filename target "&target" recfm=n;

data _null_;
length x $32000 char $1;
infile dav length=len lrecl=32767 nbyte=nbyt;
nbyt = -1;
input;
file target lrecl=32767;
do i = 1 to len;
char = substr(_infile_,i,1);
put char $char1. @@;
end;
run;
[/pre]
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 ?

[Cynthia_sas]

Hi:
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.

The doc for the URL method is here:
http://support.sas.com/documentation/cdl/en/lrdict/63026/HTML/default/viewer.htm#/documentation/cdl/...

To open a track with Tech Support, go to:
http://support.sas.com/ctx/supportform/createForm

cynthia

[GertNissen]

I have moved my question to a more appropriate forum (SAS Macro Facility, Data Step and SAS Language Elements)

http://support.sas.com/forums/thread.jspa?messageID=39197餝

[Cynthia_sas]

Hi:
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.

cynthia