Date: Tue, 31 Jan 2006 12:15:30 -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: COBOL to SAS problem
Content-Type: text/plain; charset="us-ascii"
You are using IBM 370 informats but you are probably not running on an
IBM mainframe. How did the data get transferred from the mainframe
(where it was apparently built) to the PC (based on the \ separator)
where you are running? Was it ftp? If so, was it in binary mode?
Have you looked at the file with a hex editor? That may help explain
what the invalid data errors are.
The file has a .txt suffix. Will a text file that contains binary data
(packed decimal) be processed properly on your system? (Some systems
treat hex 1A as EOF and hex 00 as end of record. Both are possible
values in a packed decimal field.)
-----Original Message-----
From: Eric B [mailto:emblabac@HOTMAIL.COM]
Sent: Tuesday, January 31, 2006 11:18 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: COBOL to SAS problem
Ok ... I guess I didnt find the issue ... my SAS dataset is a bunch a
garbage after running the input statement above. The LRECL = 284
according to the SAS output from the COB2SAS program ... I've tried
different RECFM options, but nothing works. If I use RECFM=F, I get a
lot of "invalid data" errors in the log, and if I use the default I get
this:
NOTE: The infile 'location ... \file.txt' is:
File Name='location ... \file.txt',
RECFM=V,LRECL=284
NOTE: 1 record was read from the infile 'location ... \file.txt'.
The minimum record length was 4.
The maximum record length was 4.
NOTE: SAS went to a new line when INPUT statement reached past the end
of
a line.
NOTE: The data set NEG.STEP_00_NEG has 0 observations and 21 variables.
NOTE: DATA statement used (Total process time):
real time 0.04 seconds
cpu time 0.00 seconds
Any suggestions ? I'm completely lost and getting frustrated ... Thanks