Hi thanks for your support - please find the copy of the log from sas studio, regards François.
1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
55
56 /* procedure Analyse Tracs DG NEW SCORE - FW 02-03-2017 */
57
58 data sasdata.tracs;
59 set
60 analyse.BY2636_FW
61 ;
62
63 length statut $12. ;
64 if
65 (oq=oq06M & oq=1) then statut = 'NEW_UNIQUES';
66 else if
67 (oq=oq06M & oq>1) then statut = 'NEW_MULTIS';
68 else if
69 (oq>oq06M and oq06M=1) then statut = 'NEW_REACT';
70
71 else statut = 'MULTIS';
72
73 Dec_J2_num = input (Dec_J2,4.);
74 length Dec_J2_num 4 ;
75 drop Dec_J2;
76 rename Dec_J2_num=Dec_J2;
77
78 if (1 <= dolp <= 26) and statut in ('NEW_MULTIS','NEW_REACT','MULTIS') then
79
80 Score_New =
81 -1.89304
82 +dolp* -0.013604
83 +iresp06m* 1.58685
84 +npromodolp* -0.035831
85 +nosweep* -0.10951
86 +oq01m* 0.004549523
87 +oqdg03m* 0.071948
88 +smt2* 0.003231638
89 +dolt* -0.003026975
90 +doldg* -0.007273165
91 +eqdg* 0.000036164
92 +dolmt* -0.001203701
93 ;
94 Score_New = exp(Score_New) / (1+exp(Score_New))
95 ;
96
97 /* reconstitution Nouveaux Déciles */
98
99 IF (Score_New>=0.214860685270079)THENDecile ='01';
100 ELSE IF(0.149546433457333<=0.214860685270079)THENDecile ='02';
101 ELSE IF(0.109435786177266<=0.149546433457333)THENDecile ='03';
102 ELSE IF(0.0845282863987305<=0.109435786177266)THENDecile ='04';
103 ELSE IF(0.0652380199212249<=0.0845282863987305)THENDecile ='05';
104 ELSE IF(0.0499707174667324<=0.0652380199212249)THENDecile ='06';
105 ELSE IF(0.0387321478803584<=0.0499707174667324)THENDecile ='07';
106 ELSE IF(0.0295266058729593<=0.0387321478803584)THENDecile ='08';
107 ELSE IF(0.0225046222142513<=0.0295266058729593)THENDecile ='09';
108 ELSE Decile ='10';
109
110 if (1 <= dolp <= 26) and statut = 'NEW_UNIQUES' then
111
112 Score_Unik =
113 -1.8964
114 +dolp*-0.0155
115 +npromodolp*-0.0818
116 +iresp03M* 0.63
117 +sq* 0.0445
118 +dofs* -0.00254
119 ;
120 Score_Unik = exp(Score_Unik) / (1+exp(Score_Unik))
121 ;
122 if (1 <= dolp <= 26) and statut = 'NEW_UNIQUES' then Decile = '99';
123
124 if oqV<1 then oqV2=0; else oqV2=oqV;
125 mqV2=1;
126 RDT=oqV2 / mqV2;
127
128 run;
NOTE: Missing values were generated as a result of performing an operation on missing values.
Each place is given by: (Number of times) at (Line):(Column).
5071 dans 94:13 5071 dans 94:32 5071 dans 94:33 44559 dans 120:14 44559 dans 120:34 44559 dans 120:35
NOTE: There were 49630 observations read from the data set ANALYSE.BY2636_FW.
NOTE: The data set SASDATA.TRACS has 49630 observations and 391 variables.
NOTE: DATA statement used (Total process time):
real time 0.13 seconds
cpu time 0.12 seconds
129
130 proc freq data= sasdata.TRACS ;
131
132 tables oqV oqV2 mqV mqV2 dolp mediacd datatrac
133 Dec_J2 Decile Dec_DG_MULTI_FW1 QUA_DG_UNI_FW1 statut ;
134 tables Statut * Dec_DG_MULTI_FW1 ;
135 Tables Statut * Decile ;
136 Tables Statut * Dec_J2 ;
137 Tables Dec_DG_MULTI_FW1 * Dec_J2 ;
138 Tables Decile * Dec_J2 ;
139 Tables applidecile * eliminedecile ;
140 Tables mediacd * applidecile ;
141 Tables mediacd * deciletrac ;
142 Tables mediacd * oqv2 ;
143 Tables mediacd * eliminedecile ;
144
145 run;
NOTE: There were 49630 observations read from the data set SASDATA.TRACS.
NOTE: PROCEDURE FREQ used (Total process time):
real time 1.09 seconds
cpu time 1.11 seconds
146
147 proc means data= sasdata.TRACS ; output out=out.out1;
148 var RDT ; class Decile ;
149 run;
NOTE: There were 49630 observations read from the data set SASDATA.TRACS.
NOTE: The data set OUT.OUT1 has 60 observations and 5 variables.
NOTE: PROCEDURE MEANS used (Total process time):
real time 0.05 seconds
cpu time 0.06 seconds
150
151 proc means data= sasdata.TRACS ; output out=out.out2;
152 var RDT ; class mediacd;
153 run;
NOTE: There were 49630 observations read from the data set SASDATA.TRACS.
NOTE: The data set OUT.OUT2 has 120 observations and 5 variables.
NOTE: PROCEDURE MEANS used (Total process time):
real time 0.06 seconds
cpu time 0.06 seconds
154
155 proc freq data= sasdata.TRACS ;
156 where mediacd IN (
157
158 'BY26362003',
159 'BY26362102',
160 'BY26362303',
161 'BY26362402',
162 'BY26362403',
163 'BY26362502'
164
165 );
166 Tables eliminedecile * mediacd * deciletrac ;
167 run;
NOTE: There were 23169 observations read from the data set SASDATA.TRACS.
WHERE mediacd in ('BY26362003', 'BY26362102', 'BY26362303', 'BY26362402', 'BY26362403', 'BY26362502');
NOTE: PROCEDURE FREQ used (Total process time):
real time 0.20 seconds
cpu time 0.20 seconds
168
169
170
171
172
173 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
185