Date: Mon, 8 Mar 2004 14:45:23 -0500
Reply-To: Ken <1800okla@HANMAIL.NET>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Ken <1800okla@HANMAIL.NET>
Subject: Data Input Problem
Hi,
I have a simple question which bothers me for a while.
The INPUT DATA I want to read contain the data in fixed-record format
(with no carriage-return or new-line characters)
with a record length of 76 bytes.
Please note that the first 16 bytes are blank and each line has 1024 bytes
Would you kindly let me know how I can code this so that I can generate
either the OUTPUT 1 (preferably) or OUTPUT 2?
Thank you very much for your help in advance.
INPUT DATA:
========================
A D20020301 73001 31.15000000
17.0000000 -300 0A D20020301 73001
31.15000000 19.0000000 -1000 0A D20020301
73001 31.15000000 20.0000000 -100 0A
D20020301 73001 31.15000000 22.5000000 -200
0A D20020301 73001 31.15000001 32.5000000 -
4000 0A D20020301 73001 31.15000001
33.0000000 -1100 0A D20020301 73001
31.15000001 35.0000000 -700 0A D20020301
73001 31.15000001 37.0000000 -500 0A
D20020301 73001 31.15000001 40.0000000 -500
0A D20020301 73001 31.15000000 26.0100000 -
100 0A D20020301 73001 31.15000000 30.1900000 -
1000 0A D20020301 73001 31.15000000
29.8000000 -500 0A D20020301 73001
31.15000000 29.2000000 -1000 0A 1200
20301 73001 31.15000001 37.5000000 -200 0A
D20020301 73001 31.15000000 30.0600000 -1000
0A D20020301 73001 31.15000000 30.6400000 -
100 0A D20020301 73001 31.15000001 32.8000000 -
1000 0A D20020301 73001 31.15000000
29.6000000 -700 0A D20020301 73001
31.15000000 28.6000000 -700 0A D20020301
73001 31.15000001 32.6000000 -800 0A
D20020301 73001 31.15000001 32.2000000 -2000
0A D20020301 73001 31.15000001 32.1900000 -
1000 0A D20020301 73001 31.15000001
32.4900000 -2000 0A D20020301 73001
31.15000000 31.0000000 -1800 0A D20020301
73001 31.15000001 32.7900000 -3000 0A
D20020301 73001 31.15000000 30.7900000 -5400
0A D20020301 73001 31.15000001 32.5
300000 -5100 0A D20020301 73001 31.15000001
32.4800000 -500 0A D20020301 73001
31.15000001 32.9600000 -500 0A D20020301
73001 31.15000001 33.4800000 -500 0A
D20020301 73001 31.15000000 30.5500000 -21100
0A D20020301 73001 31.15000001 32.6500000 -
500 0A D20020301 73001 31.15000001 32.1000000 -
22200 0A D20020301 73001 31.15000001
32.2500000 -2000 0A D20020301 73001
31.15000001 33.6000000 -800 0A D20020301
73001 31.15000001 32.0000000 -3600 0A
D20020301 73001 31.15000001 31.9700000 -1000
0A D20020301 73001 31.15000001 31.9500000 -
2900 0A D20020301 73001 31.15000001
31.8800000 -600 0A D20020301 73001
31.15000001 31.8700000 -500 0A
D20020301 73001 31.15000001 33.0400000 -300
0A D20020301 73001 31.15000001 32.8500000 -
400 0A D20020301 73001 31.15000001
32.0700000 -200 0A D20020301 73001
31.15000000 30.3000000 -16100 0A D20020301
73001 31.15000001 31.8100000 -1000 0A
D20020301 73001 31.15000001 31.8500000 -1700
0A D20020301 73001 31.15000001 31.7000000 -
100 0A D20020301 73001 31.15000001 31.5000000 -
1000 0A D20020301 73001 31.15000001
31.3600000 -100 0A D20020301 73001
31.15000001 31.4300000 -1000 0A D20020301
73001 31.15000000 30.7400000 -100 0A
D20020301 73001 31.15000000 30.8700000 -2000
0A D20020301 73001 31.15000000 30.4700000 -
3000 0
============================
OUTPUT 1
A D 20020301 73001 31.1500000 0 17.0000000 -300
0
A D 20020301 73001 31.1500000 0 19.0000000 -1000
0
A D 20020301 73001 31.1500000 0 20.0000000 -100
0
A D 20020301 73001 31.1500000 0 22.5000000 -200
0
A D 20020301 73001 31.1500000 1 32.5000000 -4000
0
A D 20020301 73001 31.1500000 1 33.0000000 -1100
0
A D 20020301 73001 31.1500000 1 35.0000000 -700
0
A D 20020301 73001 31.1500000 1 37.0000000 -500
0
A D 20020301 73001 31.1500000 1 40.0000000 -500
0
A D 20020301 73001 31.1500000 0 26.0100000 -100
0
A D 20020301 73001 31.1500000 0 30.1900000 -1000
0
A D 20020301 73001 31.1500000 0 29.8000000 -500
0
A D 20020301 73001 31.1500000 0 29.2000000 -1000
0
A 1 20020301 73001 31.1500000 1 37.5000000 -200
0
A D 20020301 73001 31.1500000 0 30.0600000 -1000
0
A D 20020301 73001 31.1500000 0 30.6400000 -100
0
A D 20020301 73001 31.1500000 1 32.8000000 -1000
0
A D 20020301 73001 31.1500000 0 29.6000000 -700
0
A D 20020301 73001 31.1500000 0 28.6000000 -700
0
A D 20020301 73001 31.1500000 1 32.6000000 -800
0
A D 20020301 73001 31.1500000 1 32.2000000 -2000
0
A D 20020301 73001 31.1500000 1 32.1900000 -1000
0
A D 20020301 73001 31.1500000 1 32.4900000 -2000
0
A D 20020301 73001 31.1500000 0 31.0000000 -1800
0
A D 20020301 73001 31.1500000 1 32.7900000 -3000
0
A D 20020301 73001 31.1500000 0 30.7900000 -5400
0
A D 20020301 73001 31.1500000 1 32.5300000 -5100
0
A D 20020301 73001 31.1500000 1 32.4800000 -500
0
A D 20020301 73001 31.1500000 1 32.9600000 -500
0
A D 20020301 73001 31.1500000 1 33.4800000 -500
0
A D 20020301 73001 31.1500000 0 30.5500000 -21100
0
A D 20020301 73001 31.1500000 1 32.6500000 -500
0
A D 20020301 73001 31.1500000 1 32.1000000 -22200
0
A D 20020301 73001 31.1500000 1 32.2500000 -2000
0
A D 20020301 73001 31.1500000 1 33.6000000 -800
0
A D 20020301 73001 31.1500000 1 32.0000000 -3600
0
A D 20020301 73001 31.1500000 1 31.9700000 -1000
0
A D 20020301 73001 31.1500000 1 31.9500000 -2900
0
A D 20020301 73001 31.1500000 1 31.8800000 -600
0
A D 20020301 73001 31.1500000 1 31.8700000 -500
0
A D 20020301 73001 31.1500000 1 33.0400000 -300
0
A D 20020301 73001 31.1500000 1 32.8500000 -400
0
A D 20020301 73001 31.1500000 1 32.0700000 -200
0
A D 20020301 73001 31.1500000 0 30.3000000 -16100
0
A D 20020301 73001 31.1500000 1 31.8100000 -1000
0
A D 20020301 73001 31.1500000 1 31.8500000 -1700
0
A D 20020301 73001 31.1500000 1 31.7000000 -100
0
A D 20020301 73001 31.1500000 1 31.5000000 -1000
0
A D 20020301 73001 31.1500000 1 31.3600000 -100
0
A D 20020301 73001 31.1500000 1 31.4300000 -1000
0
A D 20020301 73001 31.1500000 0 30.7400000 -100
0
A D 20020301 73001 31.1500000 0 30.8700000 -2000
0
A D 20020301 73001 31.1500000 0 30.4700000 -3000
0
OUTPUT 2:
A D20020301 73001 31.15000000 17.0000000 -300
0A D20020301 73001 31.15000000 19.0000000 -1000
0A D20020301 73001 31.15000000 20.0000000 -100
0A D20020301 73001 31.15000000 22.5000000 -200
0A D20020301 73001 31.15000001 32.5000000 -4000
0A D20020301 73001 31.15000001 33.0000000 -1100
0A D20020301 73001 31.15000001 35.0000000 -700
0A D20020301 73001 31.15000001 37.0000000 -500
0A D20020301 73001 31.15000001 40.0000000 -500
0A D20020301 73001 31.15000000 26.0100000 -100
0A D20020301 73001 31.15000000 30.1900000 -1000
0A D20020301 73001 31.15000000 29.8000000 -500
0A D20020301 73001 31.15000000 29.2000000 -1000
0A 120020301 73001 31.15000001 37.5000000 -200
0A D20020301 73001 31.15000000 30.0600000 -1000
0A D20020301 73001 31.15000000 30.6400000 -100
0A D20020301 73001 31.15000001 32.8000000 -1000
0A D20020301 73001 31.15000000 29.6000000 -700
0A D20020301 73001 31.15000000 28.6000000 -700
0A D20020301 73001 31.15000001 32.6000000 -800
0A D20020301 73001 31.15000001 32.2000000 -2000
0A D20020301 73001 31.15000001 32.1900000 -1000
0A D20020301 73001 31.15000001 32.4900000 -2000
0A D20020301 73001 31.15000000 31.0000000 -1800
0A D20020301 73001 31.15000001 32.7900000 -3000
0A D20020301 73001 31.15000000 30.7900000 -5400
0A D20020301 73001 31.15000001 32.5300000 -5100
0A D20020301 73001 31.15000001 32.4800000 -500
0A D20020301 73001 31.15000001 32.9600000 -500
0A D20020301 73001 31.15000001 33.4800000 -500
0A D20020301 73001 31.15000000 30.5500000 -21100
0A D20020301 73001 31.15000001 32.6500000 -500
0A D20020301 73001 31.15000001 32.1000000 -22200
0A D20020301 73001 31.15000001 32.2500000 -2000
0A D20020301 73001 31.15000001 33.6000000 -800
0A D20020301 73001 31.15000001 32.0000000 -3600
0A D20020301 73001 31.15000001 31.9700000 -1000
0A D20020301 73001 31.15000001 31.9500000 -2900
0A D20020301 73001 31.15000001 31.8800000 -600
0A D20020301 73001 31.15000001 31.8700000 -500
0A D20020301 73001 31.15000001 33.0400000 -300
0A D20020301 73001 31.15000001 32.8500000 -400
0A D20020301 73001 31.15000001 32.0700000 -200
0A D20020301 73001 31.15000000 30.3000000 -16100
0A D20020301 73001 31.15000001 31.8100000 -1000
0A D20020301 73001 31.15000001 31.8500000 -1700
0A D20020301 73001 31.15000001 31.7000000 -100
0A D20020301 73001 31.15000001 31.5000000 -1000
0A D20020301 73001 31.15000001 31.3600000 -100
0A D20020301 73001 31.15000001 31.4300000 -1000
0A D20020301 73001 31.15000000 30.7400000 -100
0A D20020301 73001 31.15000000 30.8700000 -2000
0A D20020301 73001 31.15000000 30.4700000 -3000
0
