topic Re: Chain of Stored Process in Developers

Chain of Stored Process

AMUMOR_SAS — Wed, 19 Apr 2017 14:53:06 GMT

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

Re: Chain of Stored Process

BrunoMueller — Wed, 19 Apr 2017 15:13:30 GMT

Morten

Define "gives me trouble", what happens with the Ø character.

Can you call the STP directly using the URL or the SASStoredProcess web app

Bruno

Re: Chain of Stored Process

Quentin — Wed, 19 Apr 2017 15:14:57 GMT

I don't know much about this, but I will look into the encoding option for both the SAS session and perhaps the browser. If you just put the URL into a browser, can you get the STP to work? If you put a URL into the browser, that goes to /Landkreditt Bank Informasjonsplattform/Rapportering/, can you see the Økonomi folder their?

Re: Chain of Stored Process

AMUMOR_SAS — Wed, 19 Apr 2017 19:08:35 GMT

Hi Bruno,

I have attached a Word Document which I think defines my trouble.

Regards

Morten Fredrik

Re: Chain of Stored Process

AMUMOR_SAS — Wed, 19 Apr 2017 19:14:32 GMT

Hi Quentin,

Thanks to both you and Bruno for the Replys.

I have attached a Word Document to my Reply to Bruno. See I you are able to open it. I think it explaines my trouble.

Regards

Morten Fredrik

Re: Chain of Stored Process

BrunoMueller — Thu, 20 Apr 2017 07:26:55 GMT

Morten

Looks like an encoding problem to me. Try adding ENCODING= option to the FILE statement, see example below

file _webout encoding='utf-8';

Hope that will.

If this does not help, contact SAS Denkmark technical support, I am sure they have had this challenge before.

Bruno

Re: Chain of Stored Process

AMUMOR_SAS — Thu, 20 Apr 2017 08:00:08 GMT

Hello Bruno,

Thanks, that worked. 🙂

Morten Fredrik