topic Re: INFILE Statment using &var in SAS Enterprise Guide

INFILE Statment using &var

RJ2016 — Fri, 01 Jul 2016 11:56:17 GMT

Hi,

I am using %connect to connect to mainframe and connect to a table i am using macro varible &business2 which i have as a %let statment in another node within my SAS project before this code runs Business2 = 160629, when i put &business2. by it self the log shows it has resolved to 160629 however in the INFILE it does not like it and log advises WARNING: Apparent symbolic reference BUSINESS2 not resolved. now i have used different INFILE styles from

INFILE "EXAW.TF.LA.BEK.TGHUP03.FALCANT.D&Business2";

INFILE "EXAW.TF.LA.BEK.TGHUP03.FALCANT.D&Business2.";

INFILE = "EXAW.TF.LA.BEK.TGHUP03.FALCANT.D&Business2";

INFILE "EXAW.TF.LA.BEK.TGHUP03.FALCANT.D&Business2"

INFILE "EXAW.TF.LA.BEK.TGHUP03.FALCANT.D&Business2."

can anyone help?

Re: INFILE Statment using &var

Kurt_Bremser — Fri, 01 Jul 2016 12:15:58 GMT

To use a macro variable in rsubmit during a connect session, you first need to use the %syslput statement (in the local context, before the rsubmit) so that the macro variable is created in the remote context.

Re: INFILE Statment using &var

jklaverstijn — Fri, 01 Jul 2016 12:16:58 GMT

Hi.

It is difficult to tell from the code you provide. Can yhou give us the entire rpogram / macro code and the log? Often this kind of error is due to the scope of a variable. Also, try and run your code using

OPTIONS MPRINT MLOGIC SYMBOLGEN;

Thes eporvide valuable troubleshooting info in the log.

Regards,

Jan.

Re: INFILE Statment using &var

RJ2016 — Mon, 04 Jul 2016 14:21:55 GMT

Hi Kurt,

Managed to get this to work thanks to your response thank you