Hi. I am linking StPs, see the attachment which is just an example. When I output to HTML, link is working, but when I output to XLSX, the link i not working. However, if I copy the URL from XLSX to the addressfield in Internet Explorer, it works. What do I miss in the URL in XLSX? To make i possible for the user to get an XLSX-output, I am trying to make a work around by placing the URL in a footnote, see the code below.. However, I am having trouble with passing parameters to the URL in the footnote. What am I doing wrong? I have debugged and I am certain of that the variables have values.   The code is below: . . . /* This code is for HTML output */ %Else %Do; %STPBEGIN; /* These variables have values */ %Put 'Dato:' &Dato.; %put 'Levaar:' &Levaar.; %Put 'Kansv_Inp:' &Kansv_Inp.; %Put 'Valg:' &Valg.; ODS escapechar='^'; /* Title1 and Title2 gets values for &Levaar., &Dato. and &Kansv_Title. Why does it work for the Titles, but not for Footnote? */ Title1 "^{style [font_size=14pt] ^{style [font_weight=Bold] ^{style [color=green] Vareleveranse for år &Levaar. pr. &Dato.}}}"; Title2 "^{style [font_size=11pt] ^{style [font_weight=Bold] ^{style [color=black] Oversikt over varemottakere for &Kansv_Title}}}"; /* The variables in Footnote1 are not replaced by values, but they are passed as their name. Why? */ Footnote1 link="%nrstr(do?_program=%2FLandkreditt+Bank+Informasjonsplattform%2FRapportering%2FAdministrasjon%2FStored+Process%2FUnder+arbeid%2FVareleveranse_StP_Print_Excel&Dato=&Dato.+&Levaar=&Levaar.+&Kundeansv=&Kundeansv+&valg=Excel)" "Open in Excel"; Proc report data=work.Grunnlag_Overordnet_url nowd style (header)=[background=aliceblue]; column Navn_Varemottaker Varemottaker Navn Leveranseaar Sum_Salgsverdi Sum_Omsetningsverdi Sum_Fratrekk; /* Viktig: Kolonne Navn_Varemottaker benyttes aom input parameter til neste StP, men er ikke vist i rapport fordi den inneholder UTF-8-tegn */ define Navn_Varemottaker /display Noprint; define Varemottaker /display; /* define Navn_Varemottaker /display; define Leveranseaar /display;*/ compute Varemottaker; /*urlstring='https://www.google.no/?q='!!strip(varemottaker)!!trim(left(Navn));*/ /* This is the URL which is working in HTML, but not in XLSX. However, if I copy the URL from XLSX to the addressfield i Internet Explorer, it works. */ urlstring = 'http://fdpsas001test.landkreditt.local/SASStoredProcess/do?_action=form%2Cproperties%2Cexecute%2Cnobanner%2Cnewwindow&_program=%2FLandkreditt+Bank+Informasjonsplattform%2FRapportering%2FAdministrasjon%2FStored+Process%2FUnder+arbeid%2FVareleveranse_StP_Print_Kansv&Dato='!!"&Dato."!!'+&Levaar='!!"&Levaar."!!'+&Aar_Ifj='!!"&Aar_Ifj."!!'+&Fra_Aar='!!"&Aar_Fra."!!'+&Navn_Mottaker='!!strip(Navn_Varemottaker)!!'+&Mottaker='!!strip(varemottaker)!!'+&Kundeansv='!!&Kansv_Inp!!'+&valg='!!"&Valg."; call define ('varemottaker','URL',urlstring); endcomp; Run; %STPEND; %End;   Regards   Morten Fredrik   ... View more

Hi. Now I need help. I am running two kinds of StP, Stand alone and Chained. In both types I want the Proc Report to make a XLSX output. When I run the Stand alone StP, I get my XLSX output and I can open it without any errormessages.   But when I run the Chained StP, the XLSX is produced, but when I try to open it, I get en error message which tells me that the XLSX file contains unreadable contents. Why?   For the test, in both StPs I make the output from sashelp.class.   My codes are shown below. /*Stand alone StP - this works :*/ %global OUTPUT; *ProcessBody; %MACRO Eksport; %if &Output. = EXCEL %then %do; data _null_; rc = stpsrv_header('Content-type','application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'); rc = stpsrv_header('Content-disposition','attachment; filename=Test.xlsx'); Run; %End; %Mend %Eksport; %Macro Print; %if &Output. = EXCEL %then %do; ods excel file = _webout style=Plateau options (Sheet_label="IK" embedded_titles="yes" embed_titles_once="no"); Title color=green "Test"; proc print label data=sashelp.class noobs style (header) =[background=aliceblue] style (column) = [font_size=1.5]; run; ods excel close; %End; %Mend; %Print; /*Chained StP - this does not work for XLSX, but it works for HTML-output: The MAIN StP:*/ %global Output; *ProcessBody; %macro PUTMENU; data _null_; file _webout encoding='UTF-8'; put "<h1 style=color:ForestGreen align=center> Test of XLSX output"; put "</h1>"; put "<div Align=Center>"; put "<body>"; put "<form ACTION='&_URL'>"; put "<input TYPE='HIDDEN' NAME='_action' value='form,properties,execute,nobanner,newwindow'>"; put "<input TYPE='hidden' NAME='_program' VALUE='&_Program._Print'>"; put "<table BORDER=1 CELLSPACING=1 CELLPADDING=4 WIDTH='30%'>"; put "<tr BGCOLOR='ForestGreen'>"; run; data _null_; file _webout; put "</select>"; put "</tr></table><P>"; put "<input type='SUBMIT' name='valg' value='HTML'>"; put "<input type='SUBMIT' name='valg' value='EXCEL'>"; put "<input type='RESET' value='Tøm meny'>"; put "</body></div></html>"; run; %Mend; %PutMenu; /*The Evoked StP:*/ %global Output; *ProcessBody; %MACRO Eksport; %if &Output. = EXCEL %then %do; ods excel file = _webout; data _null_; rc = stpsrv_header('Content-type','application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'); rc = stpsrv_header('Content-disposition','attachment; filename=Interne konti med siste transaksjon.xlsx'); run; %end; %Mend; %Eksport; %Macro Print; %If &Output. = EXCEL %Then %Do; Proc print noobs label data=sashelp.class; Run; ODS Excel close; %end; %Mend; %Print;   Regards   AMUMOR ... View more

Hi,   Here's a new question regarding Chain of Stored Process. This time I have focus on the parameter Newwindow. According to SAS 9.4 Stored Process Developers Guide, Third Edition, The Parameter Newwindow should display the result in a new window. Do I understand the term "New window" correct if I think it is as a new browser window?   I invoke the main Stored Process from the SAS Delivery Portal. This SP displays a menu from where the user can select e.g. at date. The second SP, which is invoked using the parameter "Newwindow", will dsplay the result as either HTML or Excel. When I choose HTML the result is diplayed in the same window. Why is'nt it displayed in a new window? Below is my code: data _null_; file _webout encoding='UTF-8'; put "<h1 style=color:ForestGreen align=center> Interne konti med siste transaksjon"; put "</h1>"; put "<h3 style=color:Black align=center> Dato tilsvarer siste dag i foregående måned."; put "</h3>"; put "<div Align=Center>"; put "<body>"; put "<form ACTION='&_URL'>"; put "<input TYPE='HIDDEN' NAME='_action' value='form,properties,execute,nobanner,newwindow'>"; put "<input TYPE='hidden' NAME='_program' VALUE='&_Program._Print'>"; put "<table BORDER=1 CELLSPACING=1 CELLPADDING=4 WIDTH='30%'>"; put "<tr BGCOLOR='ForestGreen'>"; run; Regards     Morten Fredrik Amundsen ... View more

Hello, Since this question is about a norwegian letter "Ø", it may be in the limit of what you are able to answer. But I will try. 🙂   I am working succesfully with chain of Stores Processes (StP), but now I have met a problem I need help with. The StP I want to invoke from the first StP is placed in a folder with a name starting with the letter "Ø". This gives me trouble. I could of course rename the folder, but that is not what I want.   Du you have an idea of how to solve this?     data _null_;                 file _webout;                 put "<h1 style=color:ForestGreen align=center> Interne konti med siste transaksjon";                 put "</h1>";                 put "<h3 style=color:Black align=center> Valgt dato gjenspeiler siste dag i foregående måned.";                 put "</h3>";                 put "<div Align=Center>";                 put "<body>";                 put "<form ACTION='&_URL'>";                 put "<input TYPE='HIDDEN' NAME='_action' value='form,properties,execute,nobanner,newwindow'>"; put "<input TYPE='hidden' NAME='_program' VALUE='/Landkreditt Bank Informasjonsplattform/Rapportering/Økonomi/Regnskap/Stored Process/Under arbeid/Interne_konti_med_siste_trans_StP_Print'>"; /*The remaining PUT statements in this DATA step define the HTML table in which we will put our selection menu.*/                 put "<table BORDER=1 CELLSPACING=1 CELLPADDING=4 WIDTH='30%'>";                 put "<tr BGCOLOR='ForestGreen'>";   run;   Regards   Morten Fredrik Amundsen ... View more