BookmarkSubscribeRSS Feed
FWILLEMIN
Calcite | Level 5

Hi Is somenone could explain me what does this mean and have a solution ? Thanks François

6 REPLIES 6
Kurt_Bremser
Super User

What were you doing when it happened? If you ran SAS code (or a task in SAS Studio), post the log, please. If no log was created, post the code sent to the workspace server.

FWILLEMIN
Calcite | Level 5
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

ballardw
Super User

@FWILLEMIN wrote:
Hi thanks for your support - please find the copy of the log from sas studio, regards François.


TRIM is not mentioned anywhere in this log. You log should include the message from SAS with the code.

 

It is also a good idea to post code and log results in a code box opened with the forum {i} icon. That will preserve formatting such as indents that the main message box removes. This is important with error messages as often there is an _ under the line that generates the error to indicate where the problem may exist. The main window will move the location and so the error is not quite as helpful.

Kurt_Bremser
Super User

OK, there's nothing in the code that makes me think it triggered the message (apart from one é character, sometimes NLS/Unicode characters can cause trouble when the code is submitted).

The message itself comes from Java, so it points to a problem in the Java applet of SAS Studio. Does it happen when Studio tries to display results or a result dataset?

samdupont
SAS Employee

Hi @FWILLEMIN,

 

Could you also provide us with more information so that we can try to reproduce here at SAS. Can you tell us what steps you did to get to this point.

 

1. What exact steps did you do ?  

1. For example, did you run a task? If so which one? Or, did you run code? If so what is the code?

2. what browser? what version of Studio?

 

3. + what @Kurt_Bremser asked.

 

 

 

ashmai
SAS Employee

I get the same error as original post when running different code. I get this error when I try to open the result dataset.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 6 replies
  • 2304 views
  • 0 likes
  • 5 in conversation