Prev: CDISC format of XML
Next: Binary data
From: rick-paulos on 22 Jan 2010 19:01
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

From: rick-paulos on 25 Jan 2010 13:50
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;

 | 
Pages: 1
Prev: CDISC format of XML
Next: Binary data