topic Re: Read multiple records from a txt file into one value in SAS Programming

Read multiple records from a txt file into one value

thogir28 — Wed, 20 Dec 2017 15:17:48 GMT

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.

Re: Read multiple records from a txt file into one value

Kurt_Bremser — Wed, 20 Dec 2017 15:20:39 GMT

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;

Re: Read multiple records from a txt file into one value

thogir28 — Wed, 20 Dec 2017 15:41:23 GMT

It works ! Thank you.