Date:         Fri, 19 Nov 1999 10:01:22 -0500
Reply-To:     Mike from Ottawa <mev@TIKACANOE.ON.CA>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Mike from Ottawa <mev@TIKACANOE.ON.CA>
Organization: Tika Systems Inc.
Subject:      Re: Reading VSAM-files (KSDS)
Content-Type: text/plain; charset=us-ascii

On Fri, 19 Nov 1999 14:22:08 +0100, "Elke Schmid" <e.schmid@kdrs.de>
wrote:

>Hi,
>has anyone ever heard about an infile-option FROMKEY or TOKEY?
>I want to read VSAM-datasets within a certain key-range. The above options
>should give me the opportunity to limit the CPU time by defining the start-
>and endkey-values.
>
>eg.
>INFILE  BANK  LIND  FROMKEY='15005000'
>                                     TOKEY='15005099'   ;
>
>Could you give me some information how to use these options?
>Are these options 'official' SAS-options?
>Maybe you could give me a tip into which SAS-Manual I have to take a look.
>
>Thanks in advance
>
>Elke

I have the manual you need: "SAS Guide to VSAM Processing."  I checked
for a FROMKEY/TOKEY option, but there isn't any.  If you're using a
batch job, why not use IDCAMS in a prior job step with the
FROMKEY/TOKEY options to select only the data you want, and then
follow it with a SAS step to read it in and manipulate it?

BTW, your INFILE statement above should include the keyword "VSAM" in
it.


---
To send me an e-mail, first
remove the watercraft from
my address