BookmarkSubscribeRSS Feed
ninemileshigh
Obsidian | Level 7

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

53


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. 

3 REPLIES 3
kiranv_
Rhodochrosite | Level 12

check this link out.

 

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

ninemileshigh
Obsidian | Level 7

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?

 

 

deblee73
Calcite | Level 5

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.  

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 3069 views
  • 0 likes
  • 3 in conversation