Hi everybody,   i'm facing some problem understanding the usage of the weigth in sankey diagram on VA. I have this kind of data  Trans_ID Item Order Elapsed 1 A 1 120 1 B 2 120 1 C 3 180 1 D 4 30 2 A 1 120 2 B 2 30 3 A 1 60 3 A 2 60 4 B 1 120 4 A 2 60 4 C 3 30   I would like that the width of the path would represent the average of elapsed (used as weigth). Is it possible? if yes, where i can change the aggregation measure for the weight.   Thank you   @FalkoSchulz  can you help me? ... View more

Hi everybody,   i need to enumerate the records based on three variables. The dataset must be orderd in ascending order by date.   I tried the following,   data want; set have; ord + 1; by ID CREATED PROD SUBPROD  ; if first.ID or first.PROD or first.SUBPROD then ord = 1; run;   but it doesn't work as you can se in the table below:   ID CREATED PROD SUBPROD ORD 1 01-ott-18 A A 1 1 02-ott-18 A A 1 1 02-ott-18 A A 2 1 02-ott-18 A A 3 1 05-ott-18 B B 1 2 02-ott-18 A A 1 3 03-ott-18 B B 1 3 04-ott-18 B B 1 3 05-ott-18 B B 1 4 01-ott-18 C C 1 4 02-ott-18 C C 1 4 02-ott-18 C C 2 4 02-ott-18 D D 1 4 05-ott-18 D D 1 4 06-ott-18 D D 1   The data set i want has to be like this:   ID CREATED PROD SUBPROD ORD 1 01-ott-18 A A 1 1 02-ott-18 A A 2 1 02-ott-18 A A 3 1 02-ott-18 A A 4 1 05-ott-18 B B 1 2 02-ott-18 A A 1 3 03-ott-18 B B 1 3 04-ott-18 B B 2 3 05-ott-18 B B 3 4 01-ott-18 C C 1 4 02-ott-18 C C 2 4 02-ott-18 C C 3 4 02-ott-18 D D 1 4 05-ott-18 D D 2 4 06-ott-18 D D 3   Thank you ... View more

Hi,   i need some help about the possibility of extracting SAS data from outside SAS. I have to create three sas view that my Customer has to execute and read when he wants. Theese views will be stored in Sql server.   Does anyone know how it can be done?   Thank you ... View more

Hello, I need to create multiple conditions in a where statement in a dynamic way. I'll explain. Let's say we have:   data want; set have; where first = "& vala" and second = "& valb" and third = "& valc"; run;   Where & val # are values taken from a table with three columns (first, second, third) and a row.   How can I do if I want to add one or more lines to the table and make the code in the following way:   data want; set have; where (first = "& vala1" and second = "& valb1" and third = "& valc1"    OR first = "& vala2" and second = "& valb2" and third = "& valc2"    OR first = "& vala #" and second = "& valb #" and third = "& valc #") run;   Thanks for the help.   One more question: is there a SAS application which permits the user to modify a table based on some prompt you designed? Such as add rows, upodate a column or something like this? ... View more