SAS code node not working properly in SAS Enterprise Miner

[expertyejin]

I have SAS onDemand for Academics: Enterprise Miner 14.1. I am currently taking the e-course titled "Applied Analytics Using SAS Enterprise Miner", and the lesson "Model Implementation Using SAS Enterprise Miner" to be more precise. I'm following the exact same instructions given in each demonstration; however, the SAS Code node doesn't seem to be working. I feel frustrated because I am unable to find the reason that causes this so far, after having searched a lot of related threads online. In addition to the log attached below, I also attached the Diagram, the Run Status window and the SAS code that is supposed to do the job:

*------------------------------------------------------------*
User:                XXXXXXXXXX
Date:                February 10, 2017
Time:                07:07:50
Site:                XXXXXXXX
Platform:            Linux
Maintenance Release: 9.04.01M3P062415
EM Version:          14.1
* 
*------------------------------------------------------------*
* Training Log
Date:                February 10, 2017
Time:                07:07:49
*------------------------------------------------------------*
23103      proc freq data=EMWS5.EMCODE_VariableSet noprint;
23104      table ROLE*LEVEL/out=WORK.EMCODEMETA;
23105      run;
 
NOTE: There were 66 observations read from the data set EMWS5.EMCODE_VARIABLESET.
NOTE: The data set WORK.EMCODEMETA has 14 observations and 4 variables.
NOTE: PROCEDURE FREQ used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.01 seconds
      memory              98882.12k
      OS Memory           111416.00k
      Timestamp           02/10/2017 07:07:49 AM
      Step Count                        1  Switch Count  0
      Page Faults                       0
      Page Reclaims                     350
      Page Swaps                        0
      Voluntary Context Switches        1
      Involuntary Context Switches      0
      Block Input Operations            0
      Block Output Operations           1320
 
 
23106      proc print data=WORK.EMCODEMETA label noobs;
23107      var ROLE LEVEL COUNT;
23108      label ROLE = "%sysfunc(sasmsg(sashelp.dmine, meta_role_vlabel, NOQUOTE))" LEVEL = "%sysfunc(sasmsg(sashelp.dmine, meta_level_vlabel, NOQUOTE))" COUNT = "%sysfunc(sasmsg(sashelp.dmine, rpt_count_vlabel, NOQUOTE))";
23109      title9 ' ';
23110      title10 "%sysfunc(sasmsg(sashelp.dmine, rpt_varSummary_title  , NOQUOTE))";
23111      run;
 
NOTE: There were 14 observations read from the data set WORK.EMCODEMETA.
NOTE: The PROCEDURE PRINT printed page 1.
NOTE: PROCEDURE PRINT used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              98882.12k
      OS Memory           111416.00k
      Timestamp           02/10/2017 07:07:49 AM
      Step Count                        1  Switch Count  6
      Page Faults                       0
      Page Reclaims                     516
      Page Swaps                        0
      Voluntary Context Switches        24
      Involuntary Context Switches      0
      Block Input Operations            0
      Block Output Operations           0
 
 
23112      title10;
23113      %let EMEXCEPTIONSTRING=;
23114      %let syscc = 0;
PERFORMANCE  DETAILS
23480      *------------------------------------------------------------*;
23481      * EMCODE: Generation of macros and macro variables;
23482      * To see the code generated, set the EM_DEBUG macro variable to SOURCE or _ALL_;
23483      *------------------------------------------------------------*;
 
23484      %let syscc = 0;
23485      %inc "/my-path/eLearnEM/Workspaces/EMWS5/EMCODE/EMTRAINCODE.sas";
NOTE: %INCLUDE (level 1) file /my-path/eLearnEM/Workspaces/EMWS5/EMCODE/EMTRAINCODE.sas is file /my-path/eLearnEM/Workspaces/EMWS5/EMCODE/EMTRAINCODE.sas.
23486     +data aaem.expscrdata;
23487     +    set &EM_IMPORT_SCORE;
23488     +run;
 
ERROR: Write access to member AAEM.EXPSCRDATA.DATA is denied.
NOTE: View EMWS5.SCORE_SCORE.VIEW used (Total process time):
      real time           0.04 seconds
      user cpu time       0.02 seconds
      system cpu time     0.03 seconds
      memory              172544.84k
      OS Memory           183856.00k
      Timestamp           02/10/2017 07:07:49 AM
      Step Count                        1  Switch Count  7
      Page Faults                       0
      Page Reclaims                     1677
      Page Swaps                        0
      Voluntary Context Switches        23
      Involuntary Context Switches      0
      Block Input Operations            0
      Block Output Operations           0
 
NOTE: The SAS System stopped processing this step because of errors.
NOTE: DATA statement used (Total process time):
      real time           0.05 seconds
      user cpu time       0.02 seconds
      system cpu time     0.03 seconds
      memory              172544.84k
      OS Memory           183856.00k
      Timestamp           02/10/2017 07:07:49 AM
      Step Count                        1  Switch Count  4
      Page Faults                       0
      Page Reclaims                     1762
      Page Swaps                        0
      Voluntary Context Switches        27
      Involuntary Context Switches      0
      Block Input Operations            0
      Block Output Operations           0
 
 
NOTE: %INCLUDE (level 1) ending.
23489      *------------------------------------------------------------*;
23490      * Close any missing semi colons;
23491      *------------------------------------------------------------*;
23492      ;
23493      ;
23494      ;
23495      ;
23496      quit;
23497      *------------------------------------------------------------*;
23498      * Close any unbalanced quotes;
23499      *------------------------------------------------------------*;
23500      /*; *"; *'; */
23501      ;
23502      run;
23503      quit;
23504      /* Reset EM Options */
23505      options formchar="|----|+|---+=|-/\<>*";
23506      options nocenter ls=256 ps=10000;
23507      goptions reset=all device=GIF NODISPLAY;
*------------------------------------------------------------*
*
* ERROR: Run time error was encountered.  The system error returned was 1012.
* Please report unresolved problems to Technical Support.
*
*------------------------------------------------------------*

If no workaround exists for this issue, I'd at least like to know the reason: is it because the SAS Code node is experimental? Is this a bug? Is it because of access permission due to the fact that this client application of SODA runs on SAS Metadata Server which only grants write and/or other special permissions to site administrators rather than regular users? Or is it because of some other problems?

Thanks a lot!

[JuanS_OCS · Accepted solution]

Hello @expertyejin,

it seems to me that your problem is on missing file system authorizations or incorrect library assignments.

Your original error is:

ERROR: Write access to member AAEM.EXPSCRDATA.DATA is denied.

Which basically means that the library/libname AAEM does not have write permissions. At least, not on the EXPSCRDATA dataset.

Loooking into one of your screenshots, it seems like AAEM is the library asigned for your EM Import Tests. 

This problem has an easy solution. I suggest you to speak with your system admin to grant you the required permissions on your user locations. And this would not be possible, to suggest you to find a more suitable location on your file system.

I hope it helps a bit!

Kind regards,

Juan

[Kurt_Bremser]

If the same code is being run by different users, the first one to run it creates the dataset in question. With the default permissions (umask) given to UNIX users when they are created, this means that the dataset in question can only be overwritten by its owner/creator.

Possible solutions:

Have the person reponsible for the course remove the dataset before you run the code node.

Have the person responsible set group write permission on the dataset; every member of the creator's group can then overwrite it. If you don't share that group, write permission for "others" needs to be set.

If you have XCMD enabled, determine the complete pathname of the dataset and use "rm -f /path/datasetname.sas7bdat" to remove the file; this only requires write permission on the library (directory), which you must have anyway.

[expertyejin]

It seems that all I have to do is to fix the access permission issues by talking to the administrator/owner then. Thank you all for the useful tips!

Best regards,

Yejin

[JuanS_OCS]

Well done @expertyejin 🙂 Thanks for your feedback.

Juan