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: 
Kirotheninja
‎10-14-2019
  • 6 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Saving XML Data into a table from ECM

by Calcite | Level 5 in Fraud, AML and Security Intelligence
‎10-11-2019 02:32 AM
‎10-11-2019 02:32 AM
Hi.   So I've created a form for ECM UI, where the user has to enter information. The xml code is pasted below   My next interest is to create a button component upon whose clicking the entered information gets stored into a table. Also attached below is a snapshot of the form created.   Looking forward to your help.    Regards       ------------------------------------------------------------------------------------------------------------------------------------------------------ <?xml version="1.0" encoding="UTF-8"?><!DOCTYPE ui-definition SYSTEM "uiDefinition.dtd"> <ui-definition id="viewer" type="viewer"> <title></title> <screen id="main"> <app-title><message key="app.title"/></app-title> <title><message key="field.fcf.my.cases"/></title>   <column-layout> <column> <field name="case.FIRST_NAME" type="string"> <label separator-visible="true"><message key="first.name"/></label> </field> <field name="TEMP.LAST_NAME" type="string"> <label separator-visible="true"><message key="last.name"/></label> </field> <field name="TEMP.BRANCH" type="dropdown" values="GetLabelValues('RT_CASE_TYPE')"> <label separator-visible="true"><message key="branch.type"/></label> </field> <field name='TEMP.product4' type='checkbox' logic="OR" values="GetLabelValues('RT_ACCOUNT')" > <label><message key='Product.Type4'/></label> </field> </column> <column> <field name="TEMP.ACC_OPN_DT" type="date"> <label><message key="account.open.date"/></label> </field> <field name="TEMP.ACC_CL_DT" type="date"> <label><message key="account.close.date"/></label> </field> <field type="component" component-name="LabelComponent"> <label><message key="product.info"/></label> </field> <field name='TEMP.EMPLOYEE' type='boolean'> <label><message key='Product.Type1'/></label> </field> <field name='TEMP.RELATED' type='boolean'> <label><message key='Product.Type2'/></label> </field> </column> </column-layout> </screen> </ui-definition> -------------------------------------------------------------------------------------------------------------------------------------------------------------------------   ... View more

Re: Converting a column into an Array for nested do loops

by Calcite | Level 5 in SAS Programming
‎07-22-2019 02:47 AM
‎07-22-2019 02:47 AM
Thanks a lot 🙂 ... View more

Re: Converting a column into an Array for nested do loops

by Calcite | Level 5 in SAS Programming
‎07-21-2019 12:39 PM
‎07-21-2019 12:39 PM
data alert; ARRAY temp[7] (200 203 205 206 208 250 300); put _all_; /*Running nested do loops over the array*/ sum1=0; do i=1 to dim(temp); c=0;sum2=0; do j=1 to dim(temp); put temp[i]=; put temp[j]=; a=abs((temp[i]-temp[j])/temp[i])*100; if a<5 then sum2=sum2+temp[j]; put a=; c=sum2; if c>sum1 then sum1=c; put sum2=; put sum1=; end; end; drop i j sum2 a c temp1-temp7; /*Check with the threshold for AGP*/ threshold=300; if sum1>threshold then alert="Generated" ; else alert="Not Generated"; run; proc print; run; This is my intention. But here i'm having to put in the values into an array manually. is tthere any way i can reference these values automatically?  ... View more

Re: Converting a column into an Array for nested do loops

by Calcite | Level 5 in SAS Programming
‎07-21-2019 12:38 PM
‎07-21-2019 12:38 PM
yeah but i want to run a nested loop. like in this code shown below. data alert; ARRAY temp[7] (200 203 205 206 208 250 300); put _all_; /*Running nested do loops over the array*/ sum1=0; do i=1 to dim(temp); c=0;sum2=0; do j=1 to dim(temp); put temp[i]=; put temp[j]=; a=abs((temp[i]-temp[j])/temp[i])*100; if a<5 then sum2=sum2+temp[j]; put a=; c=sum2; if c>sum1 then sum1=c; put sum2=; put sum1=; end; end; drop i j sum2 a c temp1-temp7; /*Check with the threshold for AGP*/ threshold=300; if sum1>threshold then alert="Generated" ; else alert="Not Generated"; run; proc print; run; ... View more

Re: Converting a column into an Array for nested do loops

by Calcite | Level 5 in SAS Programming
‎07-21-2019 12:37 PM
‎07-21-2019 12:37 PM
data alert; ARRAY temp[7] (200 203 205 206 208 250 300); put _all_; /*Running nested do loops over the array*/ sum1=0; do i=1 to dim(temp); c=0;sum2=0; do j=1 to dim(temp); put temp[i]=; put temp[j]=; a=abs((temp[i]-temp[j])/temp[i])*100; if a<5 then sum2=sum2+temp[j]; put a=; c=sum2; if c>sum1 then sum1=c; put sum2=; put sum1=; end; end; drop i j sum2 a c temp1-temp7; /*Check with the threshold for AGP*/ threshold=300; if sum1>threshold then alert="Generated" ; else alert="Not Generated"; run; proc print; run; this runs perfectly as intended. please check ... View more

Converting a column into an Array for nested do loops

by Calcite | Level 5 in SAS Programming
‎07-21-2019 12:27 AM
‎07-21-2019 12:27 AM
data cash_flow; input account_num account_desc $ trans_key amount tran_status $ ; cards; 1 P 23 200 SUCCESS 2 P 45 205 SUCCESS 3 P 22 409 FAILURE 4 P 34 343 SUCCESS 1 P 23 343 SUCCESS 1 P 45 506 SUCCESS ; RUN; /* -------------------------------------------------------------------- Creating a table with required parameters -------------------------------------------------------------------- */ PROC SQl; create table dat1 as select * from cash_flow where account_desc='P' and tran_status='SUCCESS' and account_num=1; quit; proc sql; create table want as select amount from dat1; data arraysss; set want; array try[*] _numeric_; sum1=0; do i=1 to dim(try); c=0;sum2=0; do j=1 to dim(try); put try[i]=; put try[j]=; a=abs((try[i]-try[j])/try[i])*100; if a<5 then sum2=sum2+try[j]; put a=; c=sum2; if c>sum1 then sum1=c; end; end; drop i j; threshold=100; if sum1>threshold then alert=1; run; Can you tell me where i'm going wrong. If i write the values into the array manually, the loop seems to work just fine. but when i'm needed for the array to be as the data provided in the above table i haven't been able to 😕 ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-14-2019 07:57 AM
Quick links