|Date: ||Fri, 11 Jul 1997 16:37:23 +0100|
|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|
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= ;
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
(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.