Read code from Text file as part of sas code

[rahulsaha2127]

I have a SAS code which will refer to a formula stored in external text file.

input data:

x	y
10	67
15	70
30	71

output data:

x	y	z
10	67	77
15	70	85
30	71	101

Written SAS Code:

data want;

set have;

%include "path/file_ln_model.txt"; 

run;

Text file (file_ln_model.txt):

z= x+y;

This above sas code throws the following error:

27 +z=x+y;
_____________
180

ERROR 180-322: Statement is not valid or it is used out of proper order.

Please help to find the error in this code and provide any alternative situations.

Thanks in advance.

[s_lassen · Accepted solution]

To me it looks like your file does not contain "z= x+y;", but "+z= x+y;". You can check what you %INCLUDE by using the SOURCE2 option:

data want;
  set have;
  %include "path/file_ln_model.txt" /source2; 
run;

[PeterClemmensen]

There seems to be a preceding plus sign in your .txt file. Your code looks fine.