topic Re: HOWTO: reading/writing (or copy) Excel file through Filename URL in ODS and Base Reporting

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

GertNissen — Fri, 02 Jul 2010 13:22:33 GMT

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 ?

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

Cynthia_sas — Fri, 02 Jul 2010 13:43:15 GMT

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/en/lrdict/63026/HTML/default/a000223242.htm

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

cynthia

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

GertNissen — Wed, 07 Jul 2010 22:02:54 GMT

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餝

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

Cynthia_sas — Thu, 08 Jul 2010 02:33:14 GMT

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