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;
I am getting this as error
ERROR: Insufficient authorization to access /sasdata/sasconf/config/Lev1/SASApp/&_stpwork.counts.txt.
Does this run properly in Enterprise Guide and you only receive this error in CI Studio?
Another thought:
What are the permissions of /sasdata/sasconf/config/Lev1/SASApp/ ?
Does it allow for group level write access for the SAS group?
For Linux:
ls -la /sasdata/sasconf/config/Lev1/
Look for SASApp
drwxrwxr-x 13 sas sas 4096 Jun 28 13:06 SASApp
Is that w highlighted in red there?
Also is the service account that CIS is using in the SAS group?
Hi, were you able to resolve the issue?
I'd check whether you have checked the "Package" output type checkbox for your Stored Process execution.
It should help.
Also it's a good idea to add the %macount execution (before %mastatus call)
Best regards, Dmitriy.
Listen to the Reimagine Marketing podcast
Assess your marketing efforts with a free tool
SAS Customer Intelligence Learning Subscription (login required)
SAS' Peter Ansbacher shows you how to use the dashboard in SAS Customer Intelligence 360 for better results.
Find more tutorials on the SAS Users YouTube channel.
Listen to the Reimagine Marketing podcast
Assess your marketing efforts with a free tool
SAS Customer Intelligence Learning Subscription (login required)