topic Re: Reading macro variable value in proc fcmp in SAS Programming

Reading macro variable value in proc fcmp

ojaro — Wed, 23 Feb 2022 12:04:50 GMT

Hi all,

Does anyone know if there is somehow a way to read macro variable within proc fcmp or pass information to fcmp some other way e.g. using inlib?

I am hoping to do something similar to the the following:

%let sdk_location = "/sdk_home";

proc fcmp;
declare object py(python);
submit into py;

# Load SDK.
import sys  
sys.path.insert(0, sdk_location + '/python3')
from sdk import *
...
...
...
run;

Best regards,

Olli

Re: Reading macro variable value in proc fcmp

Kurt_Bremser — Wed, 23 Feb 2022 12:07:37 GMT

Did you try this:

proc fcmp;
declare object py(python);
submit into py;

# Load SDK.
import sys  
sys.path.insert(0, &sdk_location. + '/python3')
from sdk import *
...
...
...
run;

This is just a guess, to see if SAS resolves the macro variable before the code is handed over to Python.

Re: Reading macro variable value in proc fcmp

Kurt_Bremser — Wed, 23 Feb 2022 12:11:54 GMT

But you can always do this:

%let sdk_location = /sdk_home;

filename inc temp;

data _null_;
file inc;
put "proc fcmp;";
put "declare object py(python);";
put "submit into py;";
put "# Load SDK.";
put "import sys ";
put "sys.path.insert(0, '&sdk_location.' + '/python3')";
put "from sdk import *";
put "further code here";
put "run;";
run;

%inc inc;

filename inc clear;

Re: Reading macro variable value in proc fcmp

ojaro — Wed, 23 Feb 2022 14:15:42 GMT

Thanks @Kurt_Bremser . Using the include worked perfectly.