> Hi, Ted:
> Doing that (use a SAS dataset without accessing a
> SAS library defined in the metadata) would bypass
> all the security set up in the metadata. This is
> generally not a good idea. I believe that if you
> have local datasets (on your C drive, for example)
> that you can open them as a data source by
> navigating to the local drive location for the file.
>
>
> I strongly suggest, however, that you talk to your
> SAS Administrator about how you can access the
> libraries and tables without bypassing the metadata
> security.
>
> Cynthia
Interesting comment.. if you are going to protect the securtity of files through SAS Metadata you are asking for trouble. All our security is at the drive level and as stated you can get to your file system via the Enterprise Guide option for files. I think it is critical that you have file level security and that the Excel Add-in should have the same functionality as Enterprise Guide in terms of accessing files that are stored on the file drive... I highly recommend that you do not depend on Metadata security, but rather make sure you have setup file security as it is critical for proper industry standard protection no matter what the platform.
... View more