LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (July 1997, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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.


Back to: Top of message | Previous page | Main SAS-L page