topic Re: Unable to access links... in SAS Programming

Unable to access links...

MadhuKorni — Fri, 26 Jun 2015 07:48:21 GMT

Hi...

My SAS runs on Server Machine.

I created links for data values in the report procedure which is triggered through mail from SAS.

The content of the links are placed in SAS Server.

After executing the report procedure I can open the links in the output window.

Trying to access the same from the Mail Box in the PC which throws an error path does not exist.

The problem is that I am trying to access the files in the Server from PC with the help of links.

Is it possible???

If not what are the steps that are to be followed to access the same..

Thanks in advance!!!

Regards,

Madhu

Re: Unable to access links...

Kurt_Bremser — Fri, 26 Jun 2015 09:05:29 GMT

Please post the code.

Looks like you use paths local to the server that the client doesn't have access to.

Re: Unable to access links...

MadhuKorni — Wed, 01 Jul 2015 11:10:49 GMT

Hi KurtBremser,

data Sample;

input Sample $;

cards;

Sample1

Sample2

Sample3

Sample4

Sample5

;

The content of the Link is stored in the server.

%do i = 1 %to &cnt;

ODS HTML body="N:\SASFolder\Sample&i..html" ; ------------ Server Path

proc report data = Sample&i;

run;

ods html close;

%end;

Links are created to the data values in the report procedure and the report is triggered using mail.

%macro Mail;

filename XYZ email

to ="xsyz@xyz.com "

from=" "

sub = " "

type =" ";

ods html body = XYZ;

proc report data = abc;

%do i = 1 %to &cnt;

compute sample&i;

pth = "N:\SASFolder\Sample&i..html";

call define(_col_,"url", path);

endcomp;

%end;

run;

%mend;

%mail;

ods html close;

The report will be sent to the xyz@xyz.com

What steps are to be followed to access the links in the client location from Outlook on personal machine.

Thanks in advance.

Regards,

Madhu.

Re: Unable to access links...

Kurt_Bremser — Wed, 01 Jul 2015 11:24:15 GMT

So you create a file: type link in the report. Which necessitates that the file path is correctly visible on any client that tries to open that link.

If the client does not have the (same!) N:\ mapping, this can't work.

You can see the report in the output window on Enterprise Guide because EG tracks the creation of the output and does a download over its own connection. Or EG creates the same report as "SAS Report", which is just a specialized version of the HTML destination.

In order to create robust links, you need to find a way to place your output files where every possible client can easily access them. This may be a shared network location that is mapped on all the clients, or it may be a location accessible by browser via http, necessitating a webserver.

Have a talk with your infrastructure people about what's best for your organization.