topic Re: %Include failing in SAS EG app server in SAS Programming

%Include failing in SAS EG app server

novinosrin — Tue, 21 Jan 2020 22:21:22 GMT

Hello Folks, A fellow colleague and friend asked me for a solution for the following problem.

She says-"somehow I couldn't use %include in sas eg. it works when I connect to local, but doesn't work when I connect to SASApp server. The program file is on the sharedrive. so is it in local? if I connect to local, it works. I store a macro as a .sas. could like to call it whenever I need it"

LOG note:

WARNING: Apparent invocation of macro CIS_TELLER_TRANSACTION not resolved.
26 %CIS_Teller_Transaction;
_
180

Any advice for a fix would be greatly appreciated.

PS I am afraid these things are not my cup of tea, so seeking your earnest help. Thank you in advance!

Re: %Include failing in SAS EG app server

SASKiwi — Tue, 21 Jan 2020 22:44:42 GMT

I'm assuming the %INCLUDE file is a program defining the macro CIS_Teller_Transaction - is this correct?

If the %INCLUDE fails when running on your remote SAS server, that simply means the shared folder location of the SAS program is not defined, or is defined differently on that server. Talk to your SAS administrator to resolve this as it has to be fixed at the OS level and is not really a SAS problem.

Posting the %INCLUDE statement and error would help.

Re: %Include failing in SAS EG app server

unison — Wed, 22 Jan 2020 01:48:13 GMT

Try opening the program and Save As to a location on the server. Then include with the path to the file on the server.

Otherwise, you will need to save it to a network drive that the remote machine has access to - for example, we run SAS on a linux machine and have a network drive specifically for exporting datasets to be retrieved locally.

Re: %Include failing in SAS EG app server

novinosrin — Wed, 22 Jan 2020 14:32:23 GMT

Thank you @SASKiwi and @unison for your responses. She says

From her:

"Thanks

The two replies in the community are what I thought too, the sharedrive I used may not the one of the SASApp server. Server could need a special connection.

Thanks for your help.

Thanks."

Subject: %Include failing in SAS EG app server

From me to her:

"Hey, Just to confirm my understanding and the discussion we had , I posted the question to see what responses we could get"

Re: %Include failing in SAS EG app server

ballardw — Wed, 22 Jan 2020 21:33:15 GMT

Network environment and UNC paths may be the solution if currently using drive letters in a Windows environment. Once spent hours trying to resolve "missing data" between two users to eventually find that drive Q: which looked the same for the first 40+ characters wasn't actually the same UNC path, one of those 0 O issues hard to see in long names with lots of digits in various directories.

Re: %Include failing in SAS EG app server

novinosrin — Wed, 22 Jan 2020 21:40:59 GMT

Thank you Sir @ballardw I will ask my colleague to read your post too. She might not know unless I let her know. Cheers!