Date: Tue, 29 Nov 2005 16:53:33 -0800
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: Shouldl I Read the File Twice
Content-Type: text/plain; charset="us-ascii"
Obviously that should be 44, not 40.
-----Original Message-----
From: Schwarz, Barry A
Sent: Tuesday, November 29, 2005 3:36 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: Shouldl I Read the File Twice
Try a subsetting if to ignore all the dsn's that are "null".
IF dsn NE REPEAT(00X, 40);
-----Original Message-----
From: Srna, Carol (C.) [mailto:csrna@ford.com]
Sent: Tuesday, November 29, 2005 12:13 PM
To: Schwarz, Barry A; SAS-L@LISTSERV.UGA.EDU
Subject: RE: Re: Shouldl I Read the File Twice
............................................
00000000000000000000
00000000000000000000
According to the ESA/390 book, hex zeroes are null characters. Is there
a special way I should code this in SAS? Thanks In Advance
-----Original Message-----
From: Srna, Carol (C.)
Sent: Tuesday, November 29, 2005 3:11 PM
To: 'Schwarz, Barry A'; SAS-L@LISTSERV.UGA.EDU
Subject: RE: Re: Shouldl I Read the File Twice
1. I started at Column 2.
2. My viewing technique was option 3.4 on the mainframe, then hex on,
which shows 00000000 and not 40 as I stated earlier.
3. & 4 I will try your suggestions.
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Schwarz, Barry A
Sent: Tuesday, November 29, 2005 2:40 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: Shouldl I Read the File Twice
Since you say the data is FBA, your are missing column 1. You will need
to take that into account when you code your INPUT statement.
What viewing technique shows periods for hex 40 as you indicated in a
different message? Are you sure it wasn't hex 04? You will need to
find out exactly what the underlying hex code is if they are not true
periods.
Why read the file twice? Use the subsetting IF or the DELETE you
already have.
You can use the REPEAT function to simplify typing your constant.
Barry Schwarz
OS/390 System Programmer
M/S 80-JE
Phone: 253-773-4221
Fax: 253-773-1257
-----Original Message-----
From: Srna, Carol (C.) [mailto:csrna@FORD.COM]
Sent: Tuesday, November 29, 2005 9:30 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Shouldl I Read the File Twice
Hi Everyone. I need your help. Please tell me what I am doing wrong.
I only want an observation if the observation does not have
'..........................' in the DSN field. I do not want obs.
with The SAS System, or DATASET NAME, either.
Also, do I have to code 44 '.' to delete a field that has 44 '.'? Thanks
In Advance
Input data: (external file, FBA
The SAS System
JOB
DATASET NAME NAME
ACTION
------------ ----------
------------
............................................
............................................
............................................
AA.PROD.DCCVOMER.DATA AA74Q82 UPDATED
AA.PROD.DCCVOMER.DATE HSM SCRATCHED
AA.PROD.DCCVOMER.DATE HSM MIGRATED
AA.TST.DCCVOMER.DATA AA74J12 READ
AA.TST.DCCVOMER.DATA AA74J12 READ
AA.TST.PROJECTS.LIST AA74J12 READ
AACAP13.ISPPROF.V4.DATA AACAP13 UPDATED
AACAP13.ISPPROF.V4.DATA AACAP13 UPDATED
AACAP13.ISPPROF.V4.DATA AACAP13 READ
CODE:
DATA FILE01;
INFILE IN01;
INPUT @1 TEST1 $7.
@1 TEST2 $44..
@1 TEST4 $12.@;
IF TEST1 EQ 'THE SAS' THEN DELETE;
IF TEST2 EQ '.................................................' THEN
DELETE;
IF TEST4 EQ 'DATASET NAME' THEN DELETE;
INPUT @1 DSN $44.;
