Hi, I need to create as many execute statement in a pass through as the values in a ID variable. I have the A table which contains some variables, one of them is the ID variable. Let’s say i have 30 rows. So the ID has values from 1 to 30. I have to insert each one of those rows in an oracle table. One by one. So, using a macro, how can i handle multiple execute statement? Also, does the execute statement commit the script it runs? Or the process must disconnet from oracle in order to commit? ... View more

Hello, i would like to create an interaction between a Network Diagram and a Sankey diagram.  The thing i want is: selecting one node in the Network Diagram it filter the sankey diagram, or viceversa. I'm currently using the SAS VA 7.3, and I think it's not possible to do what i want. If it is, please tell me how. If it's not, can you suggest any solution?   Or may be, a separate table which contains the same item used in sankey and network diagram that permits me to filter both the diagram.   @FalkoSchulz  i mention you because you are an expert 🙂   Thank you ... View more

Hello everyone,   i'm facing some issue in parsing the value stored into a data set column.  You can see the data in the attacched file.   Here an example:  {"IdUtente":153592,"CodiceFiscale":"CCCCCCCC","DataUltimaClassificazione":"2019-02-27T16:50:06.810","ClassiUtente":[{"IdClasse":3,"Descrizione":"Superstiti","Semantiche":[{"Codice":"7604","Descrizione":"Familiari superstiti"}]},{"IdClasse":1,"Descrizione":"Famiglia","Semantiche":[{"Codice":"7581","Descrizione":"Famiglia"}]}]}   I would like to have just one data set but any suggestion are well excepted.   Thank you     ... View more

Hi, I have to analyze services that a customer asked for in order to propose to him a service which probably is going to ask in the next interaction. I Thought about Market Basket Analysis but i suppose that is based in the assumption that the items are independent. The items/services i have to study are dependent ti each other. What kind of analysis fit the requirement? ... View more

Goodmorning everyone, The problem I have to solve is to update a column based on some checks and changes made on the previous line and on the line itself. Below is the starting table "Data_from". ROW ID Periodo_Dal Periodo_Al Dal_Prec Al_Prec periodo_dal_new periodo_al_new 1 A 19JUN2017 31DEC2017 . . 19JUN2017 31DEC2017 2 A 07NOV2017 31DEC2017 19JUN2017 31DEC2017 07NOV2017 31DEC2017 3 A 01JAN2018 31MAY2018 07NOV2017 31DEC2017 01JAN2018 31MAY2018 4 A 01JAN2018 30SEP2018 01JAN2018 31MAY2018 01JAN2018 30SEP2018 5 A 02JAN2018 26APR2018 01JAN2018 30SEP2018 02JAN2018 26APR2018 6 A 26MAR2018 24MAY2018 02JAN2018 26APR2018 26MAR2018 24MAY2018 7 A 04APR2018 15MAY2018 26MAR2018 24MAY2018 04APR2018 15MAY2018 8 A 03MAY2018 29JUN2018 04APR2018 15MAY2018 03MAY2018 29JUN2018 9 A 04MAY2018 26AUG2018 03MAY2018 29JUN2018 04MAY2018 26AUG2018 10 A 08MAY2018 18JUN2018 04MAY2018 26AUG2018 08MAY2018 18JUN2018 11 A 02JUN2018 31DEC2018 08MAY2018 18JUN2018 02JUN2018 31DEC2018 12 A 08JUL2018 22JUL2018 02JUN2018 31DEC2018 08JUL2018 22JUL2018 What I have to do is: compare Periodo_Dal with Al_Prec (lag (Periodo_Al)) if Period_Dal <Al_Prec then replace the Period_Dal with Al_Prec. if Period_Dal> Periodo_Al, then replace Periodo_Al with Period_Dal. Reiterate this way for all the lines. I used this code but it does not work. data Data_from; set Data_to; if periodo_dal <= al_prec then do; periodo_dal =al_prec; if periodo_dal ge periodo_al then periodo_al=periodo_dal; end; Dal_Prec=lag1(Periodo_Dal); Al_Prec=lag1(Periodo_Al); run; The result is the following "Data_to": ROW ID Periodo_Dal Periodo_Al Dal_Prec Al_Prec periodo_dal_new periodo_al_new 1 A 19JUN2017 31DEC2017 . . 19JUN2017 31DEC2017 2 A 31DEC2017 31DEC2017 . . 07NOV2017 31DEC2017 3 A 01JAN2018 31MAY2018 31DEC2017 31DEC2017 01JAN2018 31MAY2018 4 A 31MAY2018 30SEP2018 01JAN2018 31MAY2018 01JAN2018 30SEP2018 5 A 30SEP2018 30SEP2018 31MAY2018 30SEP2018 02JAN2018 26APR2018 6 A 26APR2018 24MAY2018 30SEP2018 30SEP2018 26MAR2018 24MAY2018 7 A 24MAY2018 24MAY2018 26APR2018 24MAY2018 04APR2018 15MAY2018 8 A 15MAY2018 29JUN2018 24MAY2018 24MAY2018 03MAY2018 29JUN2018 9 A 29JUN2018 26AUG2018 15MAY2018 29JUN2018 04MAY2018 26AUG2018 10 A 26AUG2018 26AUG2018 29JUN2018 26AUG2018 08MAY2018 18JUN2018 11 A 18JUN2018 31DEC2018 26AUG2018 26AUG2018 02JUN2018 31DEC2018 12 A 31DEC2018 31DEC2018 18JUN2018 31DEC2018 08JUL2018 22JUL2018 As you can see it stops working on line 6. In Periodo_Dal the value 26APR2018 is reported instead of 30SEP2018.  In fact 26APR2018 is the value reported in Data_from table.    Do you have any ideas?   Thank you ... View more