Hi Paige,   Thanks for your answer. I have tested and it worked 🙂  just not sure if it would pick up all the ones with random combination of symbols.   But it worked for my data.   Cheers       ... View more

it worked.   instead of using the existing dataset, I have created a new dataset and used PUTTY and "chmod 770" to change the new dataset with "-rw-rw-r-- " to the group, I believe the problem is resolved and other members in the team can run the project and override the new dataset from then.     Thanks for everyone who has helped.:) ... View more

after I run the macro,  log provided below info:   Pipe command="chmod 777 /sas_user_*****/***_WEEKLY_data" Message(s) received from the pipe command: chmod: cannot access `/sas_user_*****/***_WEEKLY_data': No such file or directory ... View more

Hi Reeza,   Totally agreed what you said.   I have run below code and confirmed x command enabled- what next? proc options option =xcmd; run;     The X Command is valid in this SAS session. ... View more

Hi Tom,   1) SAS EG is running from server. 2) I don't really understand the terminology "X points", therefore I don't know how to getting there as to your suggestion? I can create new datasets in the library  GOT, does that mean I do have the write access to the directory?   Thanks Sue     ... View more

Hi TomKari,   Yes, only 1 person from the team will be running it on a weekly basis. Currently problem is if the original file is created by one of member, other member from the team can only access the file but not update the file.   I believe it is to do with read/write access to the file, but don't have enough knowledge to resolve it myself. Tom may have provided a solution but I don't quite get it yet.   Cheers   Sue ... View more

Hi there,   further to my question, I have searched a solution and tested but failed :   http://support.sas.com/kb/25/198.html   %macro chmod(libname,dataset,permis=777);   proc sql;      /* get the absolute path of the libname */      select path into: extpath from dictionary.members        where libname="%UPCASE(&LIBNAME)";      /* find out if there are any datasets in the library */      select count(path) into: cnt from dictionary.members        where libname="%UPCASE(&LIBNAME)";      /* if there are datasets...then issue the below command to change the         permissions of the dataset called in this macro  to 777 */      %if &cnt > 0 %then %do;         filename chmod pipe "chmod &PERMIS %trim(&extpath)/&dataset..sas7bdat";         data _null_;           file chmod;         run;      %end; %mend;   /* assign a libref to test the macro */ libname GOT '/*******/******/****'; /* test the macro on the 'WEEKLY_Data' dataset in the 'GOT' library */ %chmod(GOT,WEEKLY_Data);     ... View more

Hi Tom! Exactly! I had the same idea, and it works!!   Thank you for being there and providing ideas !     ... View more