Hello I am trying to run a stored process in a process node but I am getting below error:
SAS CI Studio: The stored procedure must check for errors with the macro call %mastatus(&_stpwork.status.txt);.
The code is:
%stpbegin;
%maspinit;
/*Import login csv into Workspace*/
proc import datafile="/opt/database/survey_details/export_data.csv" replace
out=work.export_data; run;
proc sql;
create table login2
as select _SURVEY_ID, TIME format=datetime20.,_USERNAME
from work.export_data
having TIME=max(TIME) and _USERNAME="&_metauser.";
quit;
/*Import macro for survey_id*/
proc sql;
select max(_SURVEY_ID) into: sid from login2;
quit;
%MAStatus(&_stpwork.status.txt);
%stpend;