Bonjour la communauté,
Actuellement nous sommes en plein tests en vue d'implanter SAS 9.3 64-bit sur Windows 2008 R2 mais certains de nos programmes qui fonctionnaient sans problème sur SAS 9.1.3 32-bit Windows 2003 rencontrent des des erreurs du genre (une partie du log):
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162 NOTE: There were 38072320 observations read from the data set WORK.RP2. NOTE: SAS threaded sort was used. NOTE: The data set RATEPAGE.RP2 has 38072320 observations and 32 variables. NOTE: Compressing data set RATEPAGE.RP2 increased size by 4.17 percent. Compressed is 777623 pages; un-compressed would require 746517 pages. NOTE: PROCEDURE SORT used (Total process time): real time 8:38.27 cpu time 2:49.99 68 PROC DELETE DATA=BR TERR DR RG AV AKM DUC LF NYLGP OCC RP RP1 RP2; 69 70 RUN; NOTE: Deleting WORK.BR (memtype=DATA). NOTE: Deleting WORK.TERR (memtype=DATA). NOTE: Deleting WORK.DR (memtype=DATA). NOTE: Deleting WORK.RG (memtype=DATA). NOTE: Deleting WORK.AV (memtype=DATA). NOTE: Deleting WORK.AKM (memtype=DATA). NOTE: Deleting WORK.DUC (memtype=DATA). NOTE: Deleting WORK.LF (memtype=DATA). NOTE: Deleting WORK.NYLGP (memtype=DATA). NOTE: Deleting WORK.OCC (memtype=DATA). NOTE: Deleting WORK.RP (memtype=DATA). NOTE: Deleting WORK.RP1 (memtype=DATA). NOTE: Deleting WORK.RP2 (memtype=DATA). NOTE: PROCEDURE DELETE used (Total process time): real time 4.22 seconds cpu time 4.18 seconds 71 72 OPTIONS USER=''; 73 ODS LISTING CLOSE; 74 OPTION PDFPAGEVIEW=FITPAGE ; /* <-- en 9.2 seulement */ 75 ODS PDF FILE=OUT style = styles.TEMPO; WARNING: Unsupported device 'ACTIVEX' for PDF destination. Using device 'ACTXIMG'. NOTE: Writing ODS PDF output to DISK destination "OUT", printer "PDF". 76 77 OPTIONS NODATE NONUMBER; 78 options FORMCHAR= "|----|+|---+=|-/\<>*"; 79 options formdlim='' nobyline; 80 The SAS System 81 82 PROC REPORT DATA=RATEPAGE.RP2 NOWD HEADLINE HEADSKIP CENTER 83 84 STYLE=[OUTPUTWIDTH=8IN OUTPUTHEIGHT=9in FRAME=BELOW RULES=GROUPS BORDERWIDTH=0.5PT CELLSPACING=0.25PT 84 ! CELLPADDING=0.25PT ] 85 STYLE(LINES)=HEADER{BACKGROUND=WHITE ASIS=ON FONT_SIZE=6PT 86 JUST=LEFT} 87 STYLE(HEADER)=HEADER{BACKGROUND=WHITE ASIS=ON FONT_SIZE=7PT 88 JUST=LEFT}; 89 90 BY TERR AV NYL NYPO OCC DUC GENDER PAGENO; 91 92 COLUMN ('DRIVING RECORD' RG AKM ) 93 (' -----------0-------------' D0A D0B D0C) 94 (' -----------1-------------' D1A D1B D1C) 95 (' -----------2-------------' D2A D2B D2C) 96 (' -----------3-------------' D3A D3B D3C) 97 (' -----------4-------------' D4A D4B D4C) 98 (' -----------5-------------' D5A D5B D5C) 99 (' -----------6-------------' D6A D6B D6C); 100 101 102 103 104 TITLE1 bold H=6 'THE PERSONAL INSURANCE COMPANY'; 105 TITLE2 font=times color=black h=2 'NOVA SCOTIA ANNUAL RATES - PRIVATE PASSENGER VEHICLES'; 106 TITLE3 ' '; 107 TITLE4 font=times color=black h=1 'Effective Date: New Business: January 1, 2009, Renewal: March 1, 2009'; 108 TITLE5 ' '; 109 TITLE6 font=times color=black h=4 'TERRITORY: #BYVAL(TERR) AGE OF VEHICLE: #BYVAL(AV) YEARS LICENSED: 109 ! #BYVAL(NYL)'; 110 TITLE7 font=times color=black h=4 'YEARS PO: #BYVAL(NYPO) GENDER: #BYVAL(GENDER) OCCUPATION: #BYVAL(OCC)'; 111 TITLE8 ' '; 112 TITLE9 font=Arial color=black h=0.5 'COVEAGE A: COMPULSORY+OPCF44 DEDUCTIBLE: $0 LIMIT: $1,000,000'; 113 TITLE10 font=Arial color=black h=0.5 'COVERAGE B: COLLISION DEDUCTIBLE: #BYVAL(DUC) COVERAGE C: COMPREHENSIVE 113 ! DEDUCTIBLE: #BYVAL(DUC)'; 114 115 FOOTNOTE1 H=1 'PAGE: #BYVAL(PAGENO)'; 116 footnote2 '--------------------------------------------------------------------------'; 117 footnote3 font=Arial color=black h=0.5 'If you require more information about your rate, please call 1-888-597-3673'; 118 footnote4 '--------------------------------------------------------------------------'; 119 120 DEFINE RG / DISPLAY WIDTH=1 'RG' STYLE(COLUMN)={CELLWIDTH=0.1IN} STYLE=[JUST=CENTER ] ; 121 DEFINE AKM / DISPLAY WIDTH=3 'ANN KM' STYLE(COLUMN)={CELLWIDTH=0.5IN} STYLE=[JUST=LEFT ]; 122 DEFINE D0A /DISPLAY FORMAT=4. ' A' STYLE=[JUST=CENTER]; 123 DEFINE D0B /DISPLAY FORMAT=4. ' B' STYLE=[JUST=CENTER]; 124 DEFINE D0C /DISPLAY FORMAT=4. ' C' STYLE=[JUST=CENTER]; 125 DEFINE D1A /DISPLAY FORMAT=4. ' A' STYLE=[JUST=CENTER]; 126 DEFINE D1B /DISPLAY FORMAT=4. ' B' STYLE=[JUST=CENTER]; 127 DEFINE D1C /DISPLAY FORMAT=4. ' C' STYLE=[JUST=CENTER]; 128 DEFINE D2A /DISPLAY FORMAT=4. ' A' STYLE=[JUST=CENTER]; 129 DEFINE D2B /DISPLAY FORMAT=4. ' B' STYLE=[JUST=CENTER]; 130 DEFINE D2C /DISPLAY FORMAT=4. ' C' STYLE=[JUST=CENTER]; 131 DEFINE D3A /DISPLAY FORMAT=4. ' A' STYLE=[JUST=CENTER]; 132 DEFINE D3B /DISPLAY FORMAT=4. ' B' STYLE=[JUST=CENTER]; 133 DEFINE D3C /DISPLAY FORMAT=4. ' C' STYLE=[JUST=CENTER]; 134 DEFINE D4A /DISPLAY FORMAT=4. ' A' STYLE=[JUST=CENTER]; 135 DEFINE D4B /DISPLAY FORMAT=4. ' B' STYLE=[JUST=CENTER]; The SAS System 136 DEFINE D4C /DISPLAY FORMAT=4. ' C' STYLE=[JUST=CENTER]; 137 DEFINE D5A /DISPLAY FORMAT=4. ' A' STYLE=[JUST=CENTER]; 138 DEFINE D5B /DISPLAY FORMAT=4. ' B' STYLE=[JUST=CENTER]; 139 DEFINE D5C /DISPLAY FORMAT=4. ' C' STYLE=[JUST=CENTER]; 140 DEFINE D6A /DISPLAY FORMAT=5. ' A' STYLE=[JUST=CENTER]; 141 DEFINE D6B /DISPLAY FORMAT=4. ' B' STYLE=[JUST=CENTER]; 142 DEFINE D6C /DISPLAY FORMAT=4. ' C' STYLE=[JUST=CENTER]; 143 144 145 RUN; ERROR: Out of memory for critical ODS processing in append_string. ERROR: Fatal ODS error has occurred. Unable to continue processing this output destination. ERROR: Fatal ODS error has occurred. Unable to continue processing this output destination. ERROR: An exception has been encountered. Please contact technical support and provide them with the following traceback information: The SAS task name is [REPORT (2)] ERROR: Read Access Violation REPORT (2) Exception occurred at (07C2568A) Task Traceback Address Frame (DBGHELP API Version 4.0 rev 5) 0000000007C2568A 0000000008169600 saspdpdf:tkvercn1+0x5464A 0000000007C0506D 0000000008169770 saspdpdf:tkvercn1+0x3402D 0000000007BD697F 0000000008169860 saspdpdf:tkvercn1+0x593F 0000000003694DA9 0000000008169868 sasxug:tkvercn1+0x3D69 0000000007231485 00000000081698E8 sasmrk:tkvercn1+0x90445 00000000071A4A07 0000000008169BB0 sasmrk:tkvercn1+0x39C7 0000000007B436D8 0000000008169BB8 saspso:tkvercn1+0x12698 00000000072131D6 0000000008169D40 sasmrk:tkvercn1+0x72196 0000000007B31749 0000000008169DA0 saspso:tkvercn1+0x709 0000000005FB0A8D 0000000008169DA8 sasods:tkvercn1+0x9FA4D 0000000005F389B0 000000000816A130 sasods:tkvercn1+0x27970 0000000005F92489 000000000816A1C0 sasods:tkvercn1+0x81449 0000000005F678F1 000000000816DD10 sasods:tkvercn1+0x568B1 00000000081ACAB8 000000000816DD18 sasrepmn:tkvercn1+0x3BA78 00000000081755A1 000000000816F590 sasrepmn:tkvercn1+0x4561 0000000007481114 000000000816F598 sasrepor:tkvercn1+0xD4 0000000002118FD7 000000000816FCB8 sashost:Main+0xF917 000000000211D5FD 000000000816FF50 sashost:Main+0x13F3D 0000000076B3652D 000000000816FF58 kernel32:BaseThreadInitThunk+0xD 0000000076D6C541 000000000816FF88 ntdll:RtlUserThreadStart+0x21 NOTE: The SAS System stopped processing this step because of errors. ERROR: An exception has been encountered. Please contact technical support and provide them with the following traceback information: The SAS task name is [REPORT (2)] ERROR: Read Access Violation REPORT (2) Exception occurred at (0720A784) NOTE: There were 11774489 observations read from the data set RATEPAGE.RP2. NOTE: At least one W.D format was too small for the number to be printed. The decimal may be shifted by the "BEST" format. NOTE: PROCEDURE REPORT used (Total process time): real time 11:27:48.85 cpu time 9:46:12.00
Le code source est :
Petite précision: dans la table finale on a 38072320 observations (RATEPAGE.RP2 has 38072320 observations and 32 variables) à afficher dans le fichier PDF, alors je me demande pourquoi on a cette erreur. Est-ce un problème de mémoire?
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79 OPTIONS USER=''; ODS LISTING CLOSE; OPTION PDFPAGEVIEW=FITPAGE ; /* <-- en 9.2 seulement */ ODS PDF FILE=OUT style = styles.TEMPO; OPTIONS NODATE NONUMBER; options FORMCHAR= "|----|+|---+=|-/\<>*"; options formdlim='' nobyline; PROC REPORT DATA=RATEPAGE.RP2 NOWD HEADLINE HEADSKIP CENTER STYLE=[OUTPUTWIDTH=8IN OUTPUTHEIGHT=9in FRAME=BELOW RULES=GROUPS BORDERWIDTH=0.5PT CELLSPACING=0.25PT CELLPADDING=0.25PT ] STYLE(LINES)=HEADER{BACKGROUND=WHITE ASIS=ON FONT_SIZE=6PT JUST=LEFT} STYLE(HEADER)=HEADER{BACKGROUND=WHITE ASIS=ON FONT_SIZE=7PT JUST=LEFT}; BY TERR AV NYL NYPO OCC DUC GENDER PAGENO; COLUMN ('DRIVING RECORD' RG AKM ) (' -----------0-------------' D0A D0B D0C) (' -----------1-------------' D1A D1B D1C) (' -----------2-------------' D2A D2B D2C) (' -----------3-------------' D3A D3B D3C) (' -----------4-------------' D4A D4B D4C) (' -----------5-------------' D5A D5B D5C) (' -----------6-------------' D6A D6B D6C); TITLE1 bold H=6 'THE PERSONAL INSURANCE COMPANY'; TITLE2 font=times color=black h=2 'NOVA SCOTIA ANNUAL RATES - PRIVATE PASSENGER VEHICLES'; TITLE3 ' '; TITLE4 font=times color=black h=1 'Effective Date: New Business: January 1, 2009, Renewal: March 1, 2009'; TITLE5 ' '; TITLE6 font=times color=black h=4 'TERRITORY: #BYVAL(TERR) AGE OF VEHICLE: #BYVAL(AV) YEARS LICENSED: #BYVAL(NYL)'; TITLE7 font=times color=black h=4 'YEARS PO: #BYVAL(NYPO) GENDER: #BYVAL(GENDER) OCCUPATION: #BYVAL(OCC)'; TITLE8 ' '; TITLE9 font=Arial color=black h=0.5 'COVEAGE A: COMPULSORY+OPCF44 DEDUCTIBLE: $0 LIMIT: $1,000,000'; TITLE10 font=Arial color=black h=0.5 'COVERAGE B: COLLISION DEDUCTIBLE: #BYVAL(DUC) COVERAGE C: COMPREHENSIVE DEDUCTIBLE: #BYVAL(DUC)'; FOOTNOTE1 H=1 'PAGE: #BYVAL(PAGENO)'; footnote2 '--------------------------------------------------------------------------'; footnote3 font=Arial color=black h=0.5 'If you require more information about your rate, please call 1-888-597-3673'; footnote4 '--------------------------------------------------------------------------'; DEFINE RG / DISPLAY WIDTH=1 'RG' STYLE(COLUMN)={CELLWIDTH=0.1IN} STYLE=[JUST=CENTER ] ; DEFINE AKM / DISPLAY WIDTH=3 'ANN KM' STYLE(COLUMN)={CELLWIDTH=0.5IN} STYLE=[JUST=LEFT ]; DEFINE D0A /DISPLAY FORMAT=4. ' A' STYLE=[JUST=CENTER]; DEFINE D0B /DISPLAY FORMAT=4. ' B' STYLE=[JUST=CENTER]; DEFINE D0C /DISPLAY FORMAT=4. ' C' STYLE=[JUST=CENTER]; DEFINE D1A /DISPLAY FORMAT=4. ' A' STYLE=[JUST=CENTER]; DEFINE D1B /DISPLAY FORMAT=4. ' B' STYLE=[JUST=CENTER]; DEFINE D1C /DISPLAY FORMAT=4. ' C' STYLE=[JUST=CENTER]; DEFINE D2A /DISPLAY FORMAT=4. ' A' STYLE=[JUST=CENTER]; DEFINE D2B /DISPLAY FORMAT=4. ' B' STYLE=[JUST=CENTER]; DEFINE D2C /DISPLAY FORMAT=4. ' C' STYLE=[JUST=CENTER]; DEFINE D3A /DISPLAY FORMAT=4. ' A' STYLE=[JUST=CENTER]; DEFINE D3B /DISPLAY FORMAT=4. ' B' STYLE=[JUST=CENTER]; DEFINE D3C /DISPLAY FORMAT=4. ' C' STYLE=[JUST=CENTER]; DEFINE D4A /DISPLAY FORMAT=4. ' A' STYLE=[JUST=CENTER]; DEFINE D4B /DISPLAY FORMAT=4. ' B' STYLE=[JUST=CENTER]; DEFINE D4C /DISPLAY FORMAT=4. ' C' STYLE=[JUST=CENTER]; DEFINE D5A /DISPLAY FORMAT=4. ' A' STYLE=[JUST=CENTER]; DEFINE D5B /DISPLAY FORMAT=4. ' B' STYLE=[JUST=CENTER]; DEFINE D5C /DISPLAY FORMAT=4. ' C' STYLE=[JUST=CENTER]; DEFINE D6A /DISPLAY FORMAT=5. ' A' STYLE=[JUST=CENTER]; DEFINE D6B /DISPLAY FORMAT=4. ' B' STYLE=[JUST=CENTER]; DEFINE D6C /DISPLAY FORMAT=4. ' C' STYLE=[JUST=CENTER]; RUN; /* reset the directory path by default */ ods path sasuser.templat(update) sashelp.tmplmst(read); ods path show; ODS PDF CLOSE;
Vos réponses seront les bienvenues
Partager