Hi, I'm using SAS 9.4 M2 and I have the following problem. I'm running the below code and I cannot get the stpsrv_session -function to return (set) the variable values for _THISSESSION and _SESSIONID.   *stpsrv_session; data _null_;      file _webout;* html output;      if libref('SAVE') ne 0 then rc = stpsrv_session('create');      %put THISSESSION = &_THISSESSION;    %put SESSIONID = &_SESSIONID;   run;   --> The variable values are not set and I get: WARNING: Apparent symbolic reference _SESSIONID not resolved. _SESSIONID = "&_SESSIONID." WARNING: Apparent symbolic reference _THISSESSION not resolved. _THISSESSION = "&_THISSESSION."   I'm running the above code as a stored process with the code below. And I am not getting any error messages (except for the mentioned warnings).   proc stp program='/example_directory/stpsrv_session';      outputfile _webout = '/example_directory/webout.html';   run; ... View more

How to output the result of a summary statistics transformation in data integration studio into a sas data table, instead of the output window? ... View more

Hi all, A simple question: If I have the following code: if variable = 0 then yyyy = year if variable = 1 then yyyy = year-1 How can this be done with call symput? It needs to be something like (not actual code, just an example): if variable = '0' then call symput ('yyyy',year); else if variable = '1' then call symput ('yyyy',year-1); ... View more

I'm using proc sql in data integration studio transformation "sql execute". How can I make the following work so that I can delete from the table according to the other table. I have two inputs to the transformation &_input1. and &_input2. There is just some simple syntax error which I do not see ? user written code: proc sql; delete from &_input2. where  &_input2.variable = &_input1.variable quit; I cannot point to input one as: "&_input1.variable", how do I do that? ... View more

How can I abort a job in data integratin studio with a certain condition (for example if a variable is a certain value), for example so that if the job has 6 nodes and node number 4 makes the check and sfter this the remaining nodes are not executed and the execution jumps to the next job? ... View more