Hello, I'm trying to simulate a Customer Journey in SAS VA. I would like something like this: ID wayOfContact Request DOIT reqBefStore reqInStore wocBefStore 1 Tel A 0 - - - 1 Store B 1 A B Tel 1 Tel C 0 - - - 1 In D 0 - - - 1 Store B 1 D B In 2 Fax D 0 - - - 2 Mail C 0 - - -   The DOIT variable is calculated when the same ID contact the company by wayOfContact <> Store and then Store. DOIT is 1 if wayOfContact is Store, 0 otherwise. If an ID contact the company only going to Store wayOfContact must be 0. And it is possible to hav also other column: - object of the request before Store (reqBefStore) - object of the request during Store (reqInStore) - wayOfContact before Store (wocBefStore)   Please help me.   Thank you ... View more

Hi everybody,   i'm currently not understanding so well how the LASR Schema works. I have one fact table 10M records and one dimension table 1M records. The cardinality it's 1 to n. Viewing the output i understand that: - VA performs an inner join - VA performs a sort by key: using the output table in an Exploration if i filter for a specific value, which should have two rows, i can see only the first row.   Could anyone help me?   Thank you ... View more

Hi everybody,   the question is: does LASR Star Schema support any other join condition besides the inner join?   I don't know how to change this condition. It seems to me so strange the impossibility to change the join condition in a star schema. May be by editing the code? How?   Please help me. Thank you very much.   Gabriele ... View more

Hi, do you know how can i run MCA in Enterprise Miner? I thought it was simple to find this but i can't.   Please help me. ... View more

Hello everybody,   i'm new at using WRS. I would like to build a dynamic report. I have this table: ID S1 S2 S3 1 3  . 1 2  . 1   3  . 1 2   and i would like WRS show me only the column with a value, depending on the ID i choose. If i filter the table by ID=1 the report should be: ID S1 S3 1 3 1   of course if i select ID in (1,2), the report will be: ID S1 S2 S3 1 3  . 1 2  . 1  .   How can i build this kind of report?   Thank's in advance   Gabriele ... View more

Hi everybody,   i'm using the proc transpose but it seems  truncs some of the values of the ID statement. A piece of the table is: NUMERO_CASO DESCRIZIONE_SERVIZIO COUNT_SERV 1-1107594808 ESTRATTO PAGAMENTI SENZA PIN 1 1-1107594808 PENSIONI - DETTAGLIO RATA PAGAMENTO CON PIN 7 1-1107594808 PENSIONI - DETTAGLIO RATA PAGAMENTO SENZA PIN 4 1-1107594808 PIN INPS - GESTIONE RICHIESTE 3 1-1107594808 STATO DOMANDA 2 1-1107594808 VISUALIZZAZIONE CORRISPONDENZA INPS 5   and the code i'm using is the following:   proc transpose data=from out=want ; by numero_caso; var count_serv; id descrizione_servizio; run;   but the error is:   ERROR: The ID value "'PENSIONI - DETTAGLIO RATA PAGAME'n" occurs twice in the same BY group.   As you see the value is has been truncated so the second and the third rows result equal to each other.   How can i solve this problem?     ... View more

Hi everybody,   i'm new in Text mining. I'm clustering some response, but when i analyze the results i can't figure out with a specific situation that appears in the Distance between Cluster window, which is the following: As you can see there are two clusters, which i highlighted, that are very close to each other. But the two are very different in meaning. How can it be possible? how can i explain this?   Thank you ... View more