topic Re: How to set the folder properties through programming under the system of MS windows in SAS Programming

How to set the folder properties through programming under the system of MS windows

blueskyxyz — Sun, 17 Jan 2021 08:49:29 GMT

When start a new clinical study, the first step is to bulid the folders for programmer users.

you can click the mouse to create the folder and set the folder properties on your PC.

How to set the folder properties through programming under the system of MS windows, and only the owner can change and update his or her own code, others have no right to do.

*******************************************
How to set the folder properties in the code under the system of  MS windows 

When start a new clinical study, the first step is to bulid the folders for programmer users.

you can click the mouse to create the folder and set the folder properties on your PC, but how to use the code to do those things automatically?
******************************************;

%MACRO SETUP;
%let Sponsor=COMPANY001;
%let Study=STUDY001;
%let root=D:\&Sponsor\&study;
%let PHASE=DRAFT; 
%LET QCUSER=TOM;

/*-----------------------------------------------------------------------------
  Create folder and Libnames
  ----------------------------------------------------------------------------*/
options noxwait;
  x mkdir "&root\";
  x mkdir "&root\0_DOC";
  x mkdir "&root\&PHASE";
  x mkdir "&root\&PHASE\0_DOC";
  x mkdir "&root\&PHASE\PROD";
  x mkdir "&root\&PHASE\PROD\ADAM";
  x mkdir "&root\&PHASE\PROD\SDTM";
  x mkdir "&root\&PHASE\PROD\RAW";
  x mkdir "&root\&PHASE\QC";

%if %upcase(&QCUSER) ne  %then %do;
  x mkdir "&root\&PHASE\QC\&QCUSER\ADaM\";
  x mkdir "&root\&PHASE\QC\&QCUSER\Programs\";
  x mkdir "&root\&PHASE\QC\&QCUSER\Macros\";
  x mkdir "&root\&PHASE\QC\&QCUSER\Output\";

/*  How to set the folder properties through programming under the system of  MS windows
    1.only the owner can change and update his or her own code, others have no right to do*/
  libname ADaM "&root\&PHASE\QC\&QCUSER\ADaM\";
  libname SDTM "&root\&PHASE\QC\&QCUSER\SDTM\";
  libname RAW "&root\&PHASE\QC\&QCUSER\RAW\";
  libname Output "&root\&PHASE\QC\&QCUSER\Output\";
%end;
options xwait;
%MEND;

%setup;

Re: How to set the folder properties through programming under the system of MS windows

Kurt_Bremser — Sun, 17 Jan 2021 09:49:00 GMT

A quick Google search that there is a utility in Windows (Server) called icacls that does this.

Re: How to set the folder properties through programming under the system of MS windows

blueskyxyz — Sun, 17 Jan 2021 14:27:11 GMT

Thanks @Kurt_Bremser
the cmd command is a good option, is there any X command in sas code to grant the read and exectute access?

In excel, the user can record the simple VBA macro code when click the icon of record macro, do you know any software can record the cmd command to create batch file quickly?

Re: How to set the folder properties through programming under the system of MS windows

Kurt_Bremser — Sun, 17 Jan 2021 18:54:32 GMT

The X statement (and other SAS means) executes a system command (like mkdir).

icacls is just another system command, so you execute it the same way.

Re: How to set the folder properties through programming under the system of MS windows

blueskyxyz — Mon, 18 Jan 2021 07:34:17 GMT

@ KurtBremser, appreciate your reply & suggestion, I'll try to optimize my code