Hi,
I am completly new to SAS world.
I have requirement to write the SAS macros which connects to oracle database and do certain operations (Integrate logical file, delete logical files,merge files etc) . But these macros needs not be exposed to the domain experts -though he should be able to use it to create the SAS program around it.
I have few questions
1) Can SAS macros be secured/hidden, so that user does not get to know SQL tables ?
2) Is there a centralized repository where SAS programs and macros can be stored?
3) Can we restrict the ability to write the macros to certain users? is there any role based authentication built into SAS?
Thanks in advance for the help!!