About PITERSON_X_TB

PITERSON_X_TB · ‎04-15-2022

I want to sum 1s for a given key, but only the last ones, if there was a gap, i.e. there was 0, I do not want to sum. example below: ID val_202001 val_202002 val_202003 val_202004 val_202005 val_202006 val_202007 val_202008 val_202009 val_202010 val_202011 val_202012 val_202101 val_202102 val_202103 expected 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 15 2 1 1 0 0 1 1 1 1 1 1 1 1 1 1 1 11 3 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 5 Thanks for your help / inspiration

PITERSON_X_TB · ‎10-05-2016

Hello:), I want to do some volatile tables on Terada and then volatile final table to save sas as dataset. All this would do from the SAS-a. Any Concepts? Tips? Thanks so much for your help 🙂 BR SPARK:)

PITERSON_X_TB · ‎12-04-2015

Hello, I am a beginner in modeling and preparation of data for modeling. Currently, we prepare the data for modeling churn customers in the TELCO and I have the following problem. I churn for the period 201505 and to join these data variables for say 6-9 months before the churn rate and it will targer churn = 1. The problem is with the TARGET = 0, which here should take contracts? Is such a database only from the period 201411 and variable calculated from 201411 to 201505? (only those which do not churn)? Should I take the entire database, or for example if I examine the commercial churn (201505) to take the base of such 201411, which will EOP (End of period) in the coming months (eg 6 months)? Apologizes for probably a trivial question, but as I wrote above, I am a beginner. Thank you very much for your help, advice, suggestions on what I should pay attention to. Thanks Pete

selective summation

CREATE a DATASET FROM TERADATA VOLATILE TABLE

Prepare Data for prediction churn analysis

selective summation

CREATE a DATASET FROM TERADATA VOLATILE TABLE

Prepare Data for prediction churn analysis