cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
ozgegroove
‎02-06-2017
  • 7 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Cannot Use Missing Numeric Input Parameters in SAS Web Services

by SAS Employee in Developers
‎01-26-2016 08:28 AM
‎01-26-2016 08:28 AM
Hi community,   I am new to SAS Web Services..   I have created a SAS web service using a stored process. This stored process uses numeric and char input parameters. I have not chosen "Requires a non blank value" while creating prompts. But when I try to set null value for numeric parameters, it gives an error. Attached, you can see the request and response files. Here is an error when I submit the attached request(SUSPICIOUS_FLAG is missing). Also, attached you can see the SUSPICIOUS_FLAG prompt definition screenshots.   "A 'Client' type of exception occurred during execution of 'claim_info_ws1' service.  The exception follows: Exception occurred while parsing value for parameter 'SUSPICIOUS_FLAG'"   Additionally, even it is unrelated, I tried clicking "Missing Values" in Include Special Values in the second tab of the prompt, it still did not work.   It is likely to have some missing values for some numeric parameters. How could I define/submit the request file for such a situation? Urgent help is appreciated a lot. Thanks!!   Regards, Özge ... View more

Re: How to fetch specific tags in XML files and put those lines into a...

by SAS Employee in SAS Procedures
‎12-11-2015 08:55 AM
‎12-11-2015 08:55 AM
Perfect solution, thx a lot! ... View more

Re: SAS Code to Obtain Responses from REST web service

by SAS Employee in SAS Procedures
‎08-14-2015 03:37 AM
‎08-14-2015 03:37 AM
Xia, the environment is SAS9.3 unfortunately Do you have any idea about the error I get in the code? ... View more

Re: SAS Code to Obtain Responses from REST web service

by SAS Employee in SAS Procedures
‎08-13-2015 03:29 AM
‎08-13-2015 03:29 AM
Hi Xia, I have tried with proc http, however it did not work as well. but i didn't understand what you mean by your second advice? ... View more

SAS Code to Obtain Responses from REST web service

by SAS Employee in SAS Procedures
‎08-12-2015 09:34 AM
‎08-12-2015 09:34 AM
Hi all, I am new to call REST web services from SAS. I have written below code to call it using some papers. I aim to get session_id however it gives me following log and cannot get session id. Can you help me to call it successfully? It is okay to put result into SAS dataset so that I can use session_id for other requests. Also added REST request used in SOAPUI. Thanks! -----------------------------BEGIN REQUEST CODE---------------------- *** FILENAME and URL will call REST; %let user=sasdemo; %let password=SASpwd1; filename price url 'http://kkbcsd00:8080/SASWIPClientAccess/rest/sessions?userid=&user.&password=&password.' debug; data price;   infile price length=len;   input record $varying200. len; run; -----------------------------END REQUEST CODE---------------------- ---------------------------LOG--------------------------------- NOTE: >>> GET /SASWIPClientAccess/rest/sessions?userid=sasdemo&password=SASpwd1 HTTP/1.0 NOTE: >>> Host: kkbcsd00:8080 NOTE: >>> Accept: */*. NOTE: >>> Accept-Language: en NOTE: >>> Accept-Charset: iso-8859-1,*,utf-8 NOTE: >>> User-Agent: SAS/URL NOTE: >>> NOTE: <<< HTTP/1.1 405 Method Not Allowed NOTE: <<< Server: Apache-Coyote/1.1 NOTE: <<< X-Powered-By: Servlet 2.5; JBoss-5.0/JBossWeb-2.1 NOTE: <<< Set-Cookie: JSESSIONID.SASServer1=59EA70C2F4EA3D813AD13A41079DAB95; Path=/ NOTE: <<< Allow: POST NOTE: <<< Content-Type: text/html;charset=utf-8 NOTE: <<< Content-Length: 1098 NOTE: <<< Date: Wed, 12 Aug 2015 13:32:28 GMT NOTE: <<< Connection: close NOTE: <<< ERROR: Invalid reply received from the HTTP server. Use the debug option for more info. NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.PRICE may be incomplete.  When this step was stopped there were 0 observations and 1 variables. WARNING: Data set WORK.PRICE was not replaced because this step was stopped. NOTE: DATA statement used (Total process time):       real time           0.03 seconds       cpu time            0.01 seconds ---------------------REQUEST FROM SOAPUI----------- <?xml version="1.0" encoding="UTF-8"?> <credentials> <userid>sasdemo</userid> <password>SASpwd1</password> </credentials> ... View more

Re: How to fetch specific tags in XML files and put those lines into a...

by SAS Employee in SAS Procedures
‎08-03-2015 10:40 AM
‎08-03-2015 10:40 AM
Hi RW9, Thanks for your quick response. Unfortunately I am supposed to maintain it with SAS coding. So, I have to assume it as a text file. I have tried your code sample as below. However, the result is not as expected. I want to get the all lines between FlowDefinition but can get the following results. Do you have any comments? ___________________ FILENAME response '/sas/MPayment_Project/XML_Files/getFlow_resp.xml'; FILENAME flowdef2 '/sas/MPayment_Project/XML_Files/flowdef2.xml'; data _null_;      infile response;      file flowdef2;      input buffer $20000.;      if (index(buffer,"<FlowDefinition")>0) then do;           end;   else; put buffer; run; _____________________ RESULT: TableColumnsAdd(_G_IO_READ_COLUMNS_TO_READ, { { 'TID', 'STRING' }, { 'TCKN_VKN', 'STRING' }, { 'RESULT', 'STRING' }, { 'RESULT_TYPE', 'STRING' }, { 'RESULT_CODE', 'STRING' }, { 'RESULT_DATETIME', 'DATETIME' } });</Expression></CodeNode><CodeNode displayNam TableRowsAdd(_G_IO_INSERT_TABLE_VALUES, { { _RQST_TCKN_1J2FM_C, _TODAYS_DATETIME } });</Expression></CodeNode><CodeNode displayName="Cell" name="DGEHRLGYPJCAU3HN"><Transition name="ToReply"><Rule>true</Rule><DestinationNodeName>BEFCQDTZUJGITU1X</Destinatio _CELL_DESC=.; _RESPONSE_TRACKING_CODE="10380201"; _TOTAL_TREATMENTS = 0; </Expression></CodeNode><CodeNode displayName="" name="standardReplyContext"><Description/><Transition name="TostandardReplyContext_3"><Rule>true</Rule><DestinationNodeName>standardReplyContext_3</DestinationNodeName></Transition><Expression>_CELL_NAME=""; _CELL_DESC=""; _REPLY_PACK_CODE="1039"; </Expression></CodeNode></FlowDefinition></GetFlowResponse> ... View more

How to fetch specific tags in XML files and put those lines into anoth...

by SAS Employee in SAS Procedures
‎08-03-2015 09:38 AM
‎08-03-2015 09:38 AM
Hi, I am trying to fetch FlowDefinition tag in a file having such a structure summarized below. __________________________ <GetFlowResponse xmlns="?"><FlowDefinition eventName="KKB_Bireysel_Master" lastModifiedBy="sasdemo" modified="2015-04-21T15:27:05.840Z" created="2015-04-21T15:27:05.840Z" displayName="Campaign279:Shared Data\Decision Tree:KKB Business Context" name="Campaign279_1_DFDFEPEM5ZGTUVVA">                         <Description>Campaign279:Shared Data\Decision Tree:KKB Business Context </Description> ……………. ………… </FlowDefinition></GetFlowResponse> __________________________ After having all lines between "<FlowDefinition" and "</FlowDefinition>", using these lines I want to replace another xml file(as below) which also includes FlowDefinition tag with my new FlowDefinition tag. And finally, I want to add "ns2:" prefix to each tag. __________________________ <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtd="?">    <soapenv:Header/>    <soapenv:Body>       <rtd:SubmitSimulation>          <rtd:SessionContextId>?</rtd:SessionContextId>          <rtd:RepositoryName>?</rtd:RepositoryName>          <!--Zero or more repetitions:-->          <rtd:FlowDefinition name="?" displayName="" created="?" modified="?" lastModifiedBy="?" activated="?" eventName="?" timeout="0" timeoutEnabled="false"> ……………. ………… </rtd:FlowDefinition>          <!--Zero or more repetitions:-->          <rtd:GlobalValue name="?">             <!--Zero or more repetitions:-->             <rtd:Value>?</rtd:Value>          </rtd:GlobalValue>          <rtd:SimulationDescription eventName="?" inLibraryName="?" inTableName="?" outLibraryName="?" outTableName="?" statsLibraryName="?" statsTableName="?" overwriteOutputTable="?" multiThreaded="?" timeZoneOptions="?" timeZoneColumnOrId="?"/>       </rtd:SubmitSimulation>    </soapenv:Body> </soapenv:Envelope> __________________________ So 3 things to code: 1. Fetch FlowDefinition tag from one xml files. 2. Replace an old FlowDefinition tag in another xml file with the new FlowDefinition tag. 3. Add prefix(ns2:) to each tag. What is the best way to code those? Any comment will be appreciated. Thanks a lot! Regards, Ozge ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎02-06-2017 06:48 AM
Quick links