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?
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.
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.
Hi Kurt,
Managed to get this to work thanks to your response thank you
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.