https://communities.sas.com/t5/SAS-Procedures/Reading-data-from-multiple-lines/m-p/69096#M19812 Either you will need to have a fixed-format record or declare some delimiter-character that will be used to parse each record to create individual pieces, even as much with your header-row which appears cumbersome to deal with, from your data example. One approach would be to load the input buffer which populates special-named SAS variable _INFILE_ and then use a DO UNTIL(FOREVER); / END; code-paragraph along with SCAN function to assign variables (over compensating for length and type to get the data loaded first in to a SAS file). Then using another special variable _N_ assign an OBSNUM variable to track and re-connnect disjoint field-values, back into some purposeful orientation, possibly using PROC TRANSPOSE I would expect.<BR /> <BR /> Suggest the OP get the individual "component piece" parsing down first, then tackle how to reassemble pieces into usable data-rows, as needed.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc. Wed, 01 Sep 2010 21:12:54 GMT sbb 2010-09-01T21:12:54Z https://communities.sas.com/t5/SAS-Procedures/Reading-data-from-multiple-lines/m-p/69094#M19810 Very basic question but could not find on the forums with the search.<BR /> I have a dataset that has different information on different lines. How can I read in the info in a "linear" way.<BR /> Example:<BR /> 601 Part# Part Name Code1 Code2<BR /> 603 Model Info1 Info2 Info3<BR /> 604 Region Sales1 Sales2<BR /> 601 Part# Part Name Code1 Code 2<BR /> 602 Next Level Part <BR /> 603 Model Info1 Info2 Info3<BR /> 604<BR /> etc.<BR /> I want to pick out Part# Part Name Model Region as a single record for processing but there is no common "thread" in each line to tie to. There are also not always lines for each occurence, in this case part numbers.<BR /> What have I missed?<BR /> Thanks. Wed, 01 Sep 2010 19:02:29 GMT https://communities.sas.com/t5/SAS-Procedures/Reading-data-from-multiple-lines/m-p/69094#M19810 deleted_user 2010-09-01T19:02:29Z https://communities.sas.com/t5/SAS-Procedures/Reading-data-from-multiple-lines/m-p/69095#M19811 You can approach this more than one way. Using the INPUT statement you will probably want to be familiar with the trailing @ to read part of an input line while holding onto the line itself. Also you may want to use the # which allows you to read multiple input lines.<BR /> <BR /> The key is to read a portion of the input line, hold it with a trailing @ and then use logic to decide how to proceed with that specific line and subsequent lines for that observation. Wed, 01 Sep 2010 20:40:47 GMT https://communities.sas.com/t5/SAS-Procedures/Reading-data-from-multiple-lines/m-p/69095#M19811 ArtC 2010-09-01T20:40:47Z https://communities.sas.com/t5/SAS-Procedures/Reading-data-from-multiple-lines/m-p/69096#M19812 Either you will need to have a fixed-format record or declare some delimiter-character that will be used to parse each record to create individual pieces, even as much with your header-row which appears cumbersome to deal with, from your data example. One approach would be to load the input buffer which populates special-named SAS variable _INFILE_ and then use a DO UNTIL(FOREVER); / END; code-paragraph along with SCAN function to assign variables (over compensating for length and type to get the data loaded first in to a SAS file). Then using another special variable _N_ assign an OBSNUM variable to track and re-connnect disjoint field-values, back into some purposeful orientation, possibly using PROC TRANSPOSE I would expect.<BR /> <BR /> Suggest the OP get the individual "component piece" parsing down first, then tackle how to reassemble pieces into usable data-rows, as needed.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc. Wed, 01 Sep 2010 21:12:54 GMT https://communities.sas.com/t5/SAS-Procedures/Reading-data-from-multiple-lines/m-p/69096#M19812 sbb 2010-09-01T21:12:54Z