Date:         Fri, 4 Jun 2004 11:00:48 -0700
Reply-To:     "Schwarz, Barry A" <barry.a.schwarz@BOEING.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Schwarz, Barry A" <barry.a.schwarz@BOEING.COM>
Subject:      Re: Question about sorting and copying
Content-Type: text/plain; charset="iso-8859-1"

I don't know if SYNCSORT is the same as IBM's DFSORT in this area, but my IBM manual says your first parameter should be 1:1,63 and the last should be 72:72,254.  The first number following the colon is the position of the data in the input, not the length.

-----Original Message-----
From: Ellie O'Donnell [mailto:ellie.odonnell.iei8@STATEFARM.COM]
Sent: Thursday, June 03, 2004 5:39 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Question about sorting and copying


Hi,

I am trying to copy a file and change the value of one of the fields
at the same time. The file is too big for me to edit it using the text
editor (because there is not enough room in memory (TSO.) I was going
to use SAS, but the file is 325 bytes long and has over 100 fields. I
thought maybe there was a quick way to do it using Syncsort, but am
having trouble getting the syntax right in my JCL and the manual isn't
helping and I can't find an example to model off. Does anyone have any
ideas? I simply want to copy the entire file and change the field that
begins in position 64 and goes for 8 characters to the new value of
'20060715'.

Here is my current syntax which is wrong:

//STEP06   EXEC SORTD
//SORTIN   DD DSN=ELLIE.TEST,DISP=SHR
//SORTOUT  DD DSN=ELLIE.TEST.JUL1506,
//            DISP=(NEW,CATLG,DELETE),
//*           DISP=(SHR,KEEP,KEEP)
//            DCB=(RECFM=FB,LRECL=325,BLKSIZE=0,DSORG=PS),
//            SPACE=(CYL,(100,100),RLSE),LABEL=RETPD=300,
//            UNIT=DISK
//SYSIN    DD  *
  SORT FIELDS=COPY
  OUTREC FIELDS=(01:63,
                 64:C'20060715',
                 72:254)
  END
 %ENDJOB

Thanks!
Ellie