Date:         Fri, 28 Oct 2005 11:16:10 -0400
Reply-To:     Peter Crawford <peter.crawford@BLUEYONDER.CO.UK>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Peter Crawford <peter.crawford@BLUEYONDER.CO.UK>
Subject:      Re: Resetting numeric variable length
Comments: To: Alistair.Gordon@NEWTYNE.COM

On Fri, 28 Oct 2005 06:03:49 -0700, Ali G <Alistair.Gordon@NEWTYNE.COM>
wrote:

>Is there any other way to reset a numeric variable length other than by
>this method?:
>
>data a;
>  length myvar 5;
>  set a;
>run;
>
>Using 8.2 on z/os.
>
>Many thanks.

Rather than wait for two passes through your "huge" data
while it is read in full precision, and written with rounding
errors,  you might be better to reduce your space requirements,
by reducing the number of rows and columns that need to be
returned from db2.

Perhaps you could process more on that server before extracting.

To temporary db2 tables, you could take any extra data needed
to support filtering and consolidation.

If you need all the data, you'll probably need a mainframe with
db2 to hold your data extract.

Good luck

Peter