BookmarkSubscribeRSS Feed
india2016
Pyrite | Level 9

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;

 

4 REPLIES 4
india2016
Pyrite | Level 9

I am getting this as error 

ERROR: Insufficient authorization to access /sasdata/sasconf/config/Lev1/SASApp/&_stpwork.counts.txt.

pcapazzi
Pyrite | Level 9

Does this run properly in Enterprise Guide and you only receive this error in CI Studio?

pcapazzi
Pyrite | Level 9

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?

Dmitry_Alergant
Pyrite | Level 9

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.

-------
Dmitriy Alergant, Tier One Analytics
How to improve email deliverability

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.

Discussion stats
  • 4 replies
  • 1638 views
  • 0 likes
  • 3 in conversation