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 (July 2001, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Sun, 15 Jul 2001 17:21:21 GMT
Reply-To:     lebeau <lebeau777@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         lebeau <lebeau777@HOTMAIL.COM>
Organization: Excite@Home - The Leader in Broadband http://home.com/faster
Subject:      reading in a record with undetermined lines

I need to read in records that don't all have the same number of variables over more than 1 line. Each variable has a label and a new record should starts when I read a certain variable (Cust :)

ex. Cust : John Acct : 111 Amt : $150 Amt2 : $40 Cust : Jeff Acct : 458 Amt : $450 Cust : Kim Acct : 784 Amt : $214 Amt2 : $54

Problem is if I read in like: input @11 var1 $5 / @11 var2 $5 / @11 var3 $5 / @11 var4 $5 ; I lose the Kim record because it only has 3 variables to the record. Anything I try I lose records. Question is, how do you read in the records to make a one line per record flat file when you don't know how many lines a record (in the input file). Each record begins with Cust : .


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