The SAS Output Delivery System and reporting techniques

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

Reply
SAS Employee
Posts: 160

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

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 ?
SAS Super FREQ
Posts: 8,743

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

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
SAS Employee
Posts: 160

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

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餝
SAS Super FREQ
Posts: 8,743

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

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
Ask a Question
Discussion stats
  • 3 replies
  • 281 views
  • 0 likes
  • 2 in conversation