SAS Support Communities

Yeah, the data are like that. An opp can or cannot be generated with a marketing touch point. However, when there is a marketing touch point then not always an opp is generated. The mkt_flag60 is the variable we wanna study as it is the one representing the mkt touch points ... View more

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; SYMBOLGEN: Macro variable _SASWSTEMP_ resolves to /r/ge.unx.sas.com/vol/vol110/u11/spndac/.sasstudio/.images/4f40afea-269a-46b8-867a-731823c2ccda SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing. SYMBOLGEN: Macro variable GRAPHINIT resolves to GOPTIONS RESET=ALL GSFNAME=_GSFNAME; NOTE: ODS statements in the SAS Studio environment may disable some output features. 73 74 proc logistic data=ateamd.model_source_imp_single ; 75 class mkt_flag60_t / descending ; 76 77 model opp_flag60(event="1")=n_opp_prev12 n_opp_prev24 78 tot_int_prev60 mkt_flag60_t n_opp_prev12_w n_opp_prev24_w 79 80 n_opp_prev12*n_opp_prev24* 81 tot_int_prev60*mkt_flag60*n_opp_prev24_w*n_opp_prev12_w 82 83 / expb; 84 ods output ParameterEstimates = model_win ; 85 run; NOTE: PROC LOGISTIC is modeling the probability that opp_flag60=1. NOTE: Convergence criterion (GCONV=1E-8) satisfied. WARNING: The information matrix is singular and thus the convergence is questionable. Try specifying a larger SINGULAR= value. NOTE: The data set WORK.MODEL_WIN has 8 observations and 9 variables. NOTE: Compressing data set WORK.MODEL_WIN increased size by 100.00 percent. Compressed is 2 pages; un-compressed would require 1 pages. NOTE: There were 2018674 observations read from the data set ATEAMD.MODEL_SOURCE_IMP_SINGLE. NOTE: PROCEDURE LOGISTIC used (Total process time): real time 9.15 seconds cpu time 8.06 seconds 86 87 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; SYMBOLGEN: Macro variable GRAPHTERM resolves to GOPTIONS NOACCESSIBLE; 99 ... View more

here you go  ... View more

Sorry, I understand what you are saying. The suffix "_t" is missing because I tabulated the numeric version of the same variable. But the values are exactly the same. ... View more

What do you mean what happen to the covariate? I just tabulated the value of the variable. did nothing more. ... View more

The mkt_flag60 has both positive and negative value, despite the negative being only associated to target=1.   This make sense as the mkt_flag tell us if a marketing touchpoint was present, and if to that touchpoint followed up an opportunity or not (there are no record where a marketing touchpoint did not happen; but there are records where an opportunity happened BUT no marketing touchpoint was not present)   Those opp 12 and 24 records count the number of opportunities in the previous 12 and 24 months preceding the marketing date (or before the 60th day before the opportunity date, if not marketing touchpoint did happen)   The int_60 days measure if there were other marketing touchpoints BEFORE the last touchpoint described bu the mkt_flag60. There are only values ONLY IF there is a mkt_flag=1 (as if there is no mkt touchpoint, then there can't be a chain of mkt touchpoint before that) ... View more

So I tired to generate a new table from the existing one using the datastep, and In addition to the loading time, this time also an error triggered:   80   data gmod.&train_table._2; 81   set gmod.&train_table; 82   format split $10.; 83   if email_dt<="&cutoff9"d then split="train"; 84   else split="test"; 85   run;   NOTE: Running DATA step in Cloud Analytic Services. NOTE: The DATA step will run in multiple threads. ERROR: Cloud Analytic Services failed writing to system disk space. Please contact your administrator. ERROR: Cloud Analytic Services failed writing to system disk space. Please contact your administrator. ERROR: Cloud Analytic Services failed writing to system disk space. Please   I will probably check with my admin what is going on here ... View more

I have no log, as I run the piece of code:   80 data gmod.&train_table._2; 81 set gmod.&train_table; 82 format split $10.; 83 if email_dt<="&cutoff9"d then split="train"; 84 else split="test"; 85 run; NOTE: Running DATA step in Cloud Analytic Services. NOTE: The DATA step will run in multiple threads.  It get stuck in running without completing  ... View more

GMOD is a caslibrary. The table is loaded in memory already. ... View more

yes, both CAS and multithread:  NOTE: Running DATA step in Cloud Analytic Services. NOTE: The DATA step will run in multiple threads. NOTE: There were 24160332 observations read from the table SPNDAC_TRAIN_TOPIC_PROP_V1 in caslib Global Marketing Models. NOTE: The table spndac_train_topic_prop_v1TEST in caslib Global Marketing Models has 128 observations and 539 variables. NOTE: Sentencia DATA used (Total process time): real time 2.63 seconds cpu time 0.04 seconds ... View more