All of the following run without error on 9.1.3 on a Window's 2003
server environment. I wonder if they cause problems, for others, on
9.12.
Art
data smokecum;
set sashelp.class;
call missing (height);
run;
proc freq data=smokecum;
tables sex*height / list missing ;
run;
proc freq data=smokecum;
tables sex*height / missing ;
RUN;
data smokecum;
set sashelp.class;
call missing (height);
call missing (sex);
run;
proc freq data=smokecum;
tables sex*height / list missing ;
run;
proc freq data=smokecum;
tables sex*height / missing ;
RUN;
---------------
On Jan 22, 7:01 pm, "rick-pau...@uiowa.edu" <rick-pau...@uiowa.edu>
wrote:
> SAS v9.2 ts level 1M0
> os : win xp sp2 / win 7 (2 different computers give the same errors)
>
> Trying to generate a proc freq table where as it turns out 1 var is
> 100% missing.
> both vars are numeric.
> Any suggestions? The temp dataset is rather small, 568 obs, 11
> variables.
> I'm not seeing this specific error anywhere or a hot fix for it.
>
> this works:
>
> 131 proc freq data=smokecum;
> 132 tables smoke*eversmoke / list missing ;
>
> NOTE: There were 568 observations read from the data set
> WORK.SMOKECUM.
> NOTE: PROCEDURE FREQ used (Total process time):
> real time 0.03 seconds
> cpu time 0.03 seconds
>
> This generates an error:
>
> 133 proc freq data=smokecum;
> 134 tables smoke*eversmoke / missing ;
> 135 RUN;
>
> ERROR: Write Access Violation In Task [ FREQ ]
> Exception occurred at (03912976)
> Task Traceback
> Address Frame (DBGHELP API Version 4.0 rev 5)
> 03912976 03B2E3A4 sasfre7:mcn_main+0x11976
> 03907A21 03B2E3F0 sasfre7:mcn_main+0x6A21
> 03905D9B 03B2E450 sasfre7:mcn_main+0x4D9B
> 03905C89 03B2E474 sasfre7:mcn_main+0x4C89
> 66F2B628 03B2E5BC sasods:mcn_main+0x2A628
> 66F2A319 03B2E6E0 sasods:mcn_main+0x29319
> 652F1389 03B2ED40 sasfreq:mcn_main+0x30389
> 652CD159 03B2F858 sasfreq:mcn_main+0xC159
> 652C32F5 03B2FF8C sasfreq:mcn_main+0x22F5
> 015427C8 03B2FFA0 sashost:Main+0xC204
> 0162D038 03B2FFB4 sashost:Main+0xF6A74
> 7C80B699 03B2FFEC kernel32:GetModuleFileNameA+0x1BA
>
> NOTE: The SAS System stopped processing this step because of errors.
> ERROR: Write Access Violation In Task [ FREQ ]
> Exception occurred at (03912976)
> NOTE: There were 568 observations read from the data set
> WORK.SMOKECUM.
> NOTE: PROCEDURE FREQ used (Total process time):
> real time 1:18.91
> cpu time 11.53 seconds
|
|
0
|
|
|
|
Reply
|
art297 (4237)
|
1/23/2010 12:56:35 AM |
|
I think we got it narrowed down a bunch.
Adding this option causes the crash/error.
OPTION MISSING=' ';
Option missing sets the character to use for displaying missing
instead of a dot.
using a space is intended to supress those dots.
with a data set where 1 of the 2 numeric vars is all missing.
and the order on the tables statement makes a difference.
ref: sas v9.2 win XPsp2.
Try this program (save your current work first):
DATA x;
a=1; b=.; OUTPUT;
a=2; b=.; OUTPUT;
a=2; b=.; OUTPUT;
a=3; b=.; OUTPUT;
a=3; b=.; OUTPUT;
a=3; b=.; OUTPUT;
a=4; b=.; OUTPUT;
a=4; b=.; OUTPUT;
a=4; b=.; OUTPUT;
a=4; b=.; OUTPUT;
a=5; b=.; OUTPUT;
OPTIONS MISSING=' ';
PROC FREQ;
TABLE a * b / MISSING;
RUN;
|
|
0
|
|
|
|
Reply
|
rick
|
1/25/2010 6:50:58 PM
|
|