LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (March 2004, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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


Back to: Top of message | Previous page | Main SAS-L page