topic Re: Proc Report in ODS and Base Reporting

Proc Report

Lokraj — Tue, 26 Apr 2016 15:38:29 GMT

I have the following code.

data ListOfFiles;
set sqlSTL.Upload_Master;
if Meta_User="&user.";
length FileName_Desc FileName_Select FileName_Delete Button_Select $900 UploadDate UploadTime 8.;
format UploadDate mmddyy10. UploadTime hhmm.;
/*FileName_Desc="<A HREF=/SASStoredProcess/do?_program=%2FShared+Data%2FStudent+Listings%2FStudentFileUpload_Selection_2&_action=properties,execute,newwindow&amp"||'&filename_p='||strip(FileName)||"><b>Select</b></A>";*/
/*FileName_Desc="<A HREF=/SASStoredProcess/do?_program=%2FShared+Data%2FStudent+Listings%2FStudentFileUpload_Selection_2&_action=properties,execute,newwindow&amp"||'&filename_p='||strip(FileName)||">"||strip(FileName)||"</A>";*/
/*FileName_Select="<A HREF=/SASStoredProcess/do?_program=%2FShared+Data%2FStudent+Listings%2FStudentFileUpload_Selection_2&_action=properties,execute,newwindow&amp"||'&filename_p='||strip(FileName)||">"||strip(FileName)||"</A>";*/
FileName_Select="<A HREF=/SASStoredProcess/do?_program=%2FShared+Data%2FStudent+Listings%2FStudentFileUpload_Selection_2&_action=properties,execute,newwindow&amp"||'&filename_p='||strip(FileName)||">Select This File</A>";
FileName_Delete="<A HREF=/SASStoredProcess/do?_program=%2FShared+Data%2FStudent+Listings%2FConfirm_File_Deletion_1&_action=execute"||'&filename_p='||strip(FileName)||">Delete This File</A>";
UploadDate=Datepart(UploadDateTime);
UploadTime=Timepart(UploadDateTime);
/*Button_Select="<a href=/SASStoredProcess/do?_program=%2FShared+Data%2FStudent+Listings%2FStudentFileUpload_Selection_2&_action=properties,newwindow class='btn btn-primary btn-lg active' role='button'>Primary link</a>";*/
/*<a href="#"><button>Text</button></a>*/
run;

What I intended to do is when the user select the link it should open the different stored process in a new window.

For some reason the new stored process keeps opening in the same windows.

Couls anybody look at the above code and suggest me. Thanks.

Re: Proc Report

Cynthia_sas — Tue, 26 Apr 2016 18:38:22 GMT

Hi:
Is this a stored process question or a PROC REPORT question? IT looks like you are building your own HTML page with your own links to a SAS stored process. I seem to remember that if you want to pop an HTML file into a new window that you might have to add _target to the URL. The challenge is that with a stored process, the client application has to respect the use of _target. I am not sure that all the client applications where you run your stored process will respect/use _target. This is a question for Tech Support.

We also have a separate forum for SAS Stored Processes and this question would more appropriately be asked there if you are not going to open a track with Tech Support.

Here's the link to the other Forum for Stored Processes.
https://communities.sas.com/t5/SAS-Stored-Processes/bd-p/sas_stored_processes

cynthia

Re: Proc Report

Lokraj — Thu, 28 Apr 2016 19:33:34 GMT

Hello Cynthia,

Thanks for your prompt reply. This is a stored process question.

I made some changes and it works now.

I put target="_bank" at the end of href tag.

data ListOfFiles;
set Upload_Master;
length FileName_Desc FileName_Select FileName_Delete Button_Select $900 UploadDate UploadTime 8.;

FileName_Select="<A HREF=/SASStoredProcess/do?_program=%2FShared+Data%2FStudent+Listings%2FStudentFileUpload_Selection_2&_action=properties,execute,newwindow&amp"||'&filename_p='||strip(FileName)||" target=_blank>Select This File</A>";

run;

Lokraj