Hi All, i am trying to find out the solution for below Unix folder security implementation. The SAS EBI servers configured on Unix OS and been configured with LDAP for authentication(for groups and user). 1. Users been added into individual LDAP Groups as required. 2. Folder structure created in UNIX for each Group and granted own ownership to each group. 3. User home directiry been mapped to each own group folders. Power users are having access multiple group folders, power user wants to copy/paste the files/folder into different group Unix folder so that own group users should be able to read that files. Example: Power user moved one folder called CODE(the folder contain file - test.sas) from 'SALES' to 'MARKET' Unix folder to use by MARKET group users. But the CODE folder permissions are RWXRWX--- and MARKET group users cannot open and getting "permission denied" message. if i apply the permission R-X on CODE folder for MARKET Group then MARKET group user are able to see. But User done want this to happen always seeking permission apply when Power user moved the files and apply the permission. Can someone suggest how to implement above folder permission more elegant solution? Thanks, Ram ... View more

Hi All, I am wondering how would I set up the SAS 9.4 metadata security implementation dynamically. I have defined users (added into groups) >Groups, then Permission granted to groups on folders and Oracle library TEST(the Same user are part of Groups at OS level to ownership with W permission) example: IT group and SALE group users are in the system. TEST Library should be accessed by IT group users, not for SALE Group Users. For this i have granted RM & R permissions to IT group and Deny for SALE - its working as well. Customer expectation: Oracle DB has role component with in it. If user from IT group want to access TEST library that should be go to Oracle Role table to do validation  if that user has permission to access TEST library then allow to access, it not then no access to that user. is this possible with SAS?  Would you please suggest how to implement if possible? thank you, Ram. ... View more

Hello, I have library in SAS SMC and users can access it in EG, But users cannot see/access the same library in SAS Studio. Do I need to add any option to see/access SAS SMC Library in SAS Studio 3.1? Thanks, Ram ... View more

Hi All, I would like to test the system performance using SAS EG Projcet sample project, By executing EG Project batch schedule. User created  and saved in SASApp machine(Unix),the project code  read data from '.csv' file which is available in Unix machine. system Meta, App and Web servers configured on UNIX machines. How to use that EG Project (from Unix)and schedule to run, once 10 minutes and generate log for each EG schedule running session to check CPU time and process time? 1. I have tried to create batch file to schedule using SAS EG 6.1. ---- File> Schedule, - ( but schedule option is grayed out). . 2. I have opened abc.egp project from Unix path and saved as to local machine(cause it prompt me to have project on local machine to schedule). 3. Then I opened abc.egp project from windows location, I could see "schedule abc", then followed the steps on like frequency to run and intervals in between. but the scheduled process created one .vb script on desktop, which is not working. as per the scheduled time, the batch script is not running and not generatin log file as per below code in C:\Temp\test folder(created test folder under C:\Test\) Added this code to run before execute SAS code in SAS EG >Tools>Options > SAS Programs >insert custom SAS code before submitted code ============================================================================================= options dtreset fullstimer; %let SAS_ListingDateTimeStamp   = SAS_Listing_%sysfunc(putn(%sysfunc(date()),yymmdd10.))__%sysfunc(translate(%sysfunc(putn(%sysfunc(time()),timeampm12.)),.,:)); %let ListingOutFile  = C:\temp\test\&SAS_ListingDateTimeStamp..txt; ods listing file="&ListingOutFile"; %let SAS_LogDateTimeStamp   = SAS_Log_%sysfunc(putn(%sysfunc(date()),yymmdd10.))__%sysfunc(translate(%sysfunc(putn(%sysfunc(time()),timeampm12.)),.,:)); %let LogOutFile  = C:\temp\test\&SAS_LogDateTimeStamp..txt; filename logfile "&LogOutFile"; proc printto log=logfile; run; ================================================================================================== Am i missing anything and doing incorrectly to generate log for each schedule SAS EG Session? Please comment how to run the scheduled batch job for SAS EG job? Thanks, Ram ... View more

HI ALL, we have SAS EBI system 9.4 on Unix servers. User having client applications having EG 6.1 on window 7. Issue 1: User A, having PC SAS and have create sas code, data sets and placed source files in shared drive. User B, wants to create library for User A windows path to use sas code, data sets and source file, which is not working(User A and B are in same group, but User B EG not PC SAS). Issue 2: User X trying to read data(.csv) fill from windows machine, its giveing error (attached) How to fix and enable users to create library for their windows path? Error: Libname bc ‘C:\xxxxx\data’; ERROR: Physical file does not exist, /opt/sas/Config/Lev1/SASApp/J:\User\ Provid07132015.csv. NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.TEST1 may be incomplete. When this step was stopped there were 0 observations and 11 variables. NOTE: DATA statement used (Total process time): real time 0.10 seconds cpu time 0.02 seconds 65 66 data file1; 67 set test1; 68 pbase1_3= ' '; 69 pbase5_8= ' '; 70 pid1_4 = ' '; 71 pid5_7 = ' '; 72 provkey = ' '; 73 pbase1_3 = substr(provbase,1,3); 74 pbase5_8 =substr(provbase,5,4); 75 pid1_4 =substr(provid,1,4); 76 pid5_7 =substr(provid,5,3); 77 provkey =pbase5_8||provtype||pid1_4||pbase1_3||pid5_7; 78 fname = scan(contname,1,''); 79 lname =scan(contname,2); 80 81 82 if email = ' ' then delete; 83 *if contname = ' ' then delete; 84 *drop contname; 85 86 87 run; NOTE: There were 0 observations read from the data set WORK.TEST1. NOTE: The data set WORK.FILE1 has 0 observations and 18 variables. NOTE: DATA statement used (Total process time): real time 0.08 seconds cpu time 0.02 seconds 88 proc sort data = file1; by provkey; 89 run; NOTE: Input data set is empty. NOTE: The data set WORK.FILE1 has 0 observations and 18 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.42 seconds cpu time 0.00 seconds 3 The SAS System 10:47 Wednesday, July 15, 2015 90 proc print data = file1(obs=10); 91 title "ARC Provider file with provider key"; 92 run; NOTE: No observations in data set WORK.FILE1. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 93 94 data bc.provider_file_&date.; 95 set file1; 96 by provkey; 97 *if provtype ='45'; 98 run;   ERROR: Library BC does not exist.   NOTE: The SAS System stopped processing this step because of errors.   NOTE: There were 0 observations read from the data set WORK.FILE1.   NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds Thanks, Ram ... View more