The SAS Output Delivery System and reporting techniques

html on remote path

Reply
Regular Contributor
Regular Contributor
Posts: 166

html on remote path

HI,
I wanted to save my html on a remote UNIX server. I have the following details with me HOST , Path = /mypath/ , Username , Password.

Secondly i want my GPATH to also point to the above remote path.

Will i be able to achieve this. If yes could someone please guide.
Super Contributor
Posts: 273

Re: html on remote path

First of all , be clearer

are you working on a sas windows and using a sas connect to work also upon a sas unix session?
are you working through a x11 screen from a windows pc
are you working on sas windows and wishing to save a file on a unix server
which is asking you a password to deposit the file on the (html) server?

Andre
Regular Contributor
Regular Contributor
Posts: 166

Re: html on remote path

Andre,
I am using EG4.2 on a BI Intelligence platform Server1 where my html query is executed.
I have a second server Server2(unix) where i wish to save the above created html output. I donot wish to open any sessions on this server i just wish to save the html on a given path.

I hope the above info proves useful if not please do let me know.
SAS Super FREQ
Posts: 8,740

Re: html on remote path

Hi:
An additional few questions...you say you have an HTML query??? is this an EG query that returns HTML output??? Are you running a Stored Process using either the Stored Process Server or the Workspace Server to execute the query as a stored process?? Where does the data for the query live??? (standalone data or defined in the metadata)

Is the second server your webDAV server??? Are you trying to publish your EG report to the webDAV server (like Xythos), so the report will be accessible to other clients on the BI platform???

cynthia
Regular Contributor
Regular Contributor
Posts: 166

Re: html on remote path

@cynthia,
The query is a regular ods html Query on EG on Workspace Server and the data is a standalone data.

I wanted to save the ouput on the second webDAV server so that i could use the URL to display my ouput on SAS portal so that it can be viewed by other clients.
SAS Super FREQ
Posts: 8,740

Re: html on remote path

Hi:
I don't have access to a 4.2/9.2 Platform installation right now. You can't just do a FILE--> SAVE AS to the webDAV server from EG. I believe there's an explicit PUBLISH choice someplace. It's either on the Results tab or on the HTML icon for the results, where you can select PUBLISH to publish the output to the webDAV server.

You might check with Tech Support for the publishing steps when you're dealing with the Platform.

cynthia
Regular Contributor
Regular Contributor
Posts: 166

Re: html on remote path

The second server / HOST that i talk about is not on my intelligence Platform .
Hence the Save as / PUBLISH option doesnot work.

I was Looking for something in the lines of the filename FTP Statement.

If a direct solution is not available My fianl Alternative will be to use the regular FTP protocol to tranfer my outputs to the remote host.
Regular Contributor
Regular Contributor
Posts: 166

Re: html on remote path

The second server / HOST that i talk about is not on my intelligence Platform .
Hence the Save as / PUBLISH option doesnot work.

I was Looking for something in the lines of the filename FTP Statement.

If a direct solution is not available My fianl Alternative will be to use the regular FTP protocol to tranfer my outputs to the remote host.
Regular Contributor
Regular Contributor
Posts: 166

Re: html on remote path

The second server / HOST that i talk about is not on my intelligence Platform .
Hence the Save as / PUBLISH option doesnot work.

I was Looking for something in the lines of the filename FTP Statement.

If a direct solution is not available My fianl Alternative will be to use the regular FTP protocol to tranfer my outputs to the remote host.

Thanks for your help
Regular Contributor
Regular Contributor
Posts: 166

Re: html on remote path

The second server / HOST that i talk about is not on my intelligence Platform .
Hence the Save as / PUBLISH option doesnot work.

I was Looking for something in the lines of the filename FTP Statement.

If a direct solution is not available My fianl Alternative will be to use the regular FTP protocol to tranfer my outputs to the remote host.

Thanks for your help
Regular Contributor
Regular Contributor
Posts: 166

Re: html on remote path

The second server / HOST that i talk about is not on my intelligence Platform .
Hence the Save as / PUBLISH option doesnot work.

I was Looking for something in the lines of the filename FTP Statement.

If a direct solution is not available My fianl Alternative will be to use the regular FTP protocol to tranfer my outputs to the remote host.

Thanks for your help
Regular Contributor
Regular Contributor
Posts: 166

Re: html on remote path

Found the following code in SAS help. Just the thing that i was looking for.
But i think this works only on 9.2.

filename output1 ftp "~user/dir" fileext host="host.unx.company.com"
user="userid" pass="userpass" recfm=s debug;
filename output2 ftp "~user/dir" dir fileext host="host.unx.company.com"
user="userid" pass="userpass" recfm=s debug;
ods listing close;
ods html body='body.html' path=output1 gpath=output2
frame='frames.html' contents='contents.html';
proc gtestit;run;quit;
ods html close;
ods listing;
Regular Contributor
Regular Contributor
Posts: 166

Re: html on remote path

Found the following code in SAS help. Just the thing that i was looking for.
But i think this works only on 9.2.

filename output1 ftp "~user/dir" fileext host="host.unx.company.com"
user="userid" pass="userpass" recfm=s debug;
filename output2 ftp "~user/dir" dir fileext host="host.unx.company.com"
user="userid" pass="userpass" recfm=s debug;
ods listing close;
ods html body='body.html' path=output1 gpath=output2
frame='frames.html' contents='contents.html';
proc gtestit;run;quit;
ods html close;
ods listing;
Ask a Question
Discussion stats
  • 12 replies
  • 241 views
  • 0 likes
  • 3 in conversation