Re: PROC FREQ v9.2 error win xp/sp2 or win7

  • Follow


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


1 Replies
528 Views

(page loaded in 0.041 seconds)

Similiar Articles:









7/21/2012 6:48:05 PM


Reply: