Read multiple records from a txt file into one value

[thogir28]

Hello,

I have a txt file that contains multiple equations which are separated by ";". 

Some equations are splited into 2 records because they are very long. 

In the example below eq1 and eq3 are not separated but eq2 is:

eq1 = x1*a+ x2*b + x3*c ;

eq2 = x1*a + x2*b +

x3*c + x4*d ; 

eq3 = x1*a + x2*b + x3*c ; 

I want to create a dataset with only 1 variable that contains one row for each equations like that : 

VAR1

eq1=eq1 = x1*a+ x2*b + x3*c

eq2 = x1*a + x2*b +x3*c + x4*d

eq3 = x1*a + x2*b + x3*c

The basic code to import is : 

data temp;
infile "txt_file" dlm=";" ;
input var1 :$1000.;
run;

I tried many things but nothing works. Every time SAS creates 2 rows for the splitted equations. I know with this exemple you can just add a data step after the import and concatenate the 2 separeted row for the equation 2 but I cannot do that with my real data.

Thank you for your help.

[Kurt_Bremser · Accepted solution]

Try this:

data want;
infile datalines4 truncover;
input equation $400.;
do while (substr(equation,length(equation),1) ne ';');
  input add_line $200.;
  equation = catx(' ',equation,add_line);
end;
drop add_line;
datalines4;
eq1 = x1*a+ x2*b + x3*c ;
eq2 = x1*a + x2*b +
x3*c + x4*d ; 
eq3 = x1*a + x2*b + x3*c ;
;;;;
run;

[thogir28]

It works ! Thank you.