sas >> Integer divide by zero

by chsuan » Thu, 09 Oct 2003 01:06:03 GMT

Hi,

I have an excel spreadsheet that I converted into SAS version 8 (via
StatTransfer). The conversion seems to have worked properly -- I can open
the SAS dataset without a problem. However, when I'm programming in SAS
and trying to do simple data manipulations (including proc sort and proc
freq), I get the following error message: "ERROR: Integer divide by zero"

Any idea what's happening & how to fix it?

Thanks,

Charleen

Charleen Hsuan
Research Assistant
Department of Health Policy and Management
Harvard School of Public Health
677 Huntington Avenue
Boston, MA 02115
Phone: (617)432-3419

sas >> Integer divide by zero

by HERMANS1 » Thu, 09 Oct 2003 02:04:45 GMT


That error message does not usually have anything to do with division by
zero in a SAS program. You may have any one of a number of problems with
attributes of the dataset imported from Excel, or with your configuration of
SAS. A PROC CONTENTS of the dataset will show formats and informats
associated with column variables. In particular you might try disassociating
formats from character variables using
FORMAT <charVarName>;

Sig

-----Original Message-----
From: Charleen Hsuan [mailto: XXXX@XXXXX.COM ]
Sent: Wednesday, October 08, 2003 1:06 PM
To: XXXX@XXXXX.COM
Subject: Integer divide by zero


Hi,

I have an excel spreadsheet that I converted into SAS version 8 (via
StatTransfer). The conversion seems to have worked properly -- I can open
the SAS dataset without a problem. However, when I'm programming in SAS and
trying to do simple data manipulations (including proc sort and proc freq),
I get the following error message: "ERROR: Integer divide by zero"

Any idea what's happening & how to fix it?

Thanks,

Charleen

Charleen Hsuan
Research Assistant
Department of Health Policy and Management
Harvard School of Public Health
677 Huntington Avenue
Boston, MA 02115
Phone: (617)432-3419

sas >> Integer divide by zero

by Bob Burnham » Thu, 09 Oct 2003 02:12:32 GMT


XXXX@XXXXX.COM (Charleen Hsuan) writes:

+----------------------------------------------------------------
| I have an excel spreadsheet that I converted into SAS version 8
| (via StatTransfer). The conversion seems to have worked
| properly -- I can open the SAS dataset without a problem.
| However, when I'm programming in SAS and trying to do simple
| data manipulations (including proc sort and proc freq), I get
| the following error message: "ERROR: Integer divide by zero"
+----------------------------------------------------------------

Hi Charleen,

There is a FAQ file at UCLA that has a good work around for
exactly the issue that you are describing. Check it out here:

http://www.ats.ucla.edu/stat/sas/faq/dividezero.htm

Best regards,

Bob

--
Bob Burnham
XXXX@XXXXX.COM
http://www.dartmouth.edu/ ~bburnham

Similar Threads

1. Floating Point Zero Divide

Hi All

While executing  proc genmod in sas ,I came across this Error .

ERROR: Floating Point Zero Divide.

ERROR: Termination due to Floating Point Exception

Could you please suggest how to resolve this.


proc bgenmod data=dataset_name desc;
model flag  =

var1
var2
var3
.
.
.
.
var_n
/ dist=bin link=logit;
bayes seed=2345 plots=all nbi=2000 nmc=10000
coeffprior=normal(input=Prior);
ods output PosteriorSample=Post;
run;


2. Dividing by Zero

3. Floating Point Zero Divide Error

When running PROC UNIVARIATE with a BY statement, I get a floating point
zero divide error. There are missing values in the SAS data file that might
be the cause, but I'm not sure.

Running 8.2 in Windows 2000, is there a relatively easy way to overcome
this error?

Thanks.

Paul Ehresmann

4. less than zero and equal to zero

5. Robust standard errors in Zero inflated Poisson and Zero inflated

I have used Proc Genmod and Repeated Subject statement to obtain robust
standard errors in Poisson and negative binomial regression. Could anyone
please tell me something  about the STATEMENT AND possible SYNTAX that can be
used to obtain robust standard errors in Zero inflated Poisson and Zero
inflated negative binomial regression?

6. Dividing time from patient start dates to unscheduled visits

7. Help in coding matrix divide

I've matrix of X and Y. I want to get the result of X divided by Y.
Which procedure I could use to do that?

Proc IML does not work for doing that.

Thanks so much!

8. Dividing time from patient start dates to unscheduled visits into