Floating Point Zero Divide

ninemileshigh — Thu, 16 May 2019 16:05:25 GMT

As of three days ago, all (every script that I've tried) of my previously working SAS scripts keep failing, with Floating Point Zero Divide errors. I am using SAS 9.4 (TS1M3) for Windows 10 64 bit. One example of my code is below

/***************************************************************************
* SCAN THE EXISTING FLUX DATASET TO REDUCE THE FILES READ IN- i.e. DON'T *
* READ IN FILES THAT HAVE ALREADY BEEN PROCESSED *
***************************************************************************/

PROC FREQ DATA= DATASET.LINEARFIT;
TABLES FILENAME / OUT= PROCESSED NOPERCENT NOCUM;
RUN;;

DATA PROCESSED;
SET PROCESSED;
DROP PERCENT;
PROCESSED= 'Y';
PROC SORT;
BY FILENAME;
RUN;

Which returns the following log:

/***************************************************************************
46 * SCAN THE EXISTING FLUX DATASET TO REDUCE THE FILES READ IN- i.e. DON'T *
47 * READ IN FILES THAT HAVE ALREADY BEEN PROCESSED *
48 ***************************************************************************/
49
50 PROC FREQ DATA= DATASET.LINEARFIT;
51 TABLES FILENAME / OUT= PROCESSED NOPERCENT NOCUM;
52 RUN;

ERROR: Floating Point Zero Divide.
ERROR: Termination due to Floating Point Exception
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.PROCESSED may be incomplete. When this step was stopped there were
0 observations and 0 variables.
NOTE: PROCEDURE FREQ used (Total process time):
real time 2.14 seconds
cpu time 0.15 seconds

54 DATA PROCESSED;
55 SET PROCESSED;
56 DROP PERCENT;
57 PROCESSED= 'Y';

WARNING: The variable PERCENT in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 0 observations read from the data set WORK.PROCESSED.
NOTE: The data set WORK.PROCESSED has 0 observations and 1 variables.
NOTE: DATA statement used (Total process time):
real time 2.48 seconds
cpu time 0.12 seconds

I have no idea how to approach fixing this error. The scripts were working absolutely fine prior to this. I've seen examples if this error on other PROCS online, but none of the literature seems relevant to my code.

Re: Floating Point Zero Divide

kiranv_ — Thu, 16 May 2019 16:29:59 GMT

check this link out.

http://support.sas.com/kb/46/318.html

Re: Floating Point Zero Divide

ninemileshigh — Fri, 17 May 2019 09:36:58 GMT

thank you. I have downloaded the zip folders from the link, but when I try to apply thee hot fixes using deployment manager I just get a warning that Hot fix packages do not exist in the selected directory. I haven't installed hot fixes before- are they version specific, as I am running 9.4 and the hot fix appears to be for 9.3?

Re: Floating Point Zero Divide

deblee73 — Tue, 05 Nov 2019 15:18:06 GMT

I have the exact same issue when I export to an Access Database on scripts that have worked for years. I notice it only happens when I reboot my PC which is about every other month.

topic Re: Floating Point Zero Divide in New SAS User

Floating Point Zero Divide

Re: Floating Point Zero Divide

Re: Floating Point Zero Divide

Re: Floating Point Zero Divide