Date:         Fri, 11 Jul 1997 16:37:23 +0100
Reply-To:     redmanj@lloyds-bank.co.uk
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         James Redman <redmanj@LLOYDS-BANK.CO.UK>
Organization: Lloyds TSB Goup
Subject:      Getting garbage numbers from PROC SUMMARY
Content-Type: text/plain; charset=us-ascii

Dear All,
 
I am running a standard PROC SUMMARY :-
 
PROC SORT DATA=OE0101B ; BY MONTH SORTCODE ;
PROC SUMMARY DATA=OE0101B ;
  VAR INDEX ;
  BY MONTH SORTCODE ;
  ID GROUP AREA REGION GROUPCAT BRCHNAME ;
  OUTPUT OUT=NEWTOTAL (DROP=_TYPE_ _FREQ_) SUM= ;
RUN ;
 
PROC PRINT DATA=NEWTOTAL ; RUN ;
 
Running it in batch is producing really strange numbers like -9.12345E65
for the INDEX variable, while running it interactively produces the
correct number
(e.g. 19.23456). There are approx 270,000 obs involved and none of the
values for INDEX are negative. It might be something to do with whether
missing values are
involved. I'm running V6.08 on MVS.
 
Has anyone had similar problems and if so did they get around them.
 
Thanks in anticipation.
 
Cheers,
 
James.