topic Re: Can we control access/ permissions of RTF/ xlsx files using SAS. in SAS Programming

Can we control access/ permissions of RTF/ xlsx files using SAS.

SASuserlot — Thu, 20 Oct 2022 21:40:46 GMT

I encountered the following requests that I never think of it.

I need to generate the RTF using as and make as Read only RTF. is there any option that SAS will do this? I searched some but there is no luck . I know the access option for datasets but not RTF. I read about filename permission and tried but not sure how to use it.
It is also similar to the first one, but this one is xlsx file which is already exist. can we change the permission of the file, using the SAS

If SAS will not work , is there alternatives that we can do using SAS like vbscript or cmd commands.. etc. I am aware RTF is a text file giving this read-only doesn't guarantee any strong securities.

Any suggestion? Thanks.

Re: Can we control access/ permissions of RTF/ xlsx files using SAS.

Quentin — Thu, 20 Oct 2022 21:54:40 GMT

I would look into how to set those permissions from the OS.

If your SAS session has XCMD option enabled, then if you how to set the permissions via OS command, you can use the X or SYSTASK statement to execute the OS command.

So you're using SAS to generate the file, and also using SAS to set the permissions after generating the file. By having SAS send a command for the OS to execute.

So if you're on linux, look into the CHMOD command. And I'm sure there's something similar for windows.

Re: Can we control access/ permissions of RTF/ xlsx files using SAS.

SASuserlot — Thu, 20 Oct 2022 22:07:57 GMT

Thank you @Quentin for quick options. I am kind of new to use the cmd in SAS ( windows). by any chance can you guide to the reference or a syntax will help. Really appreciate your time.

/* create  renaming and looking for set read-only access*/

ods rtf file="c:\documents\sample.rtf";* style=table_rtf;
proc print data= sashelp.class;
run;
ods _all_ close;


*trying x command;
options noxwait;
data _null_;
x 'attrib r+ "c:\documents\sample.rtf"';
run;

Re: Can we control access/ permissions of RTF/ xlsx files using SAS.

Quentin — Thu, 20 Oct 2022 22:16:27 GMT

This paper has some examples:

https://www.lexjansen.com/pharmasug/2011/AD/PharmaSUG-2011-AD06.pdf

Re: Can we control access/ permissions of RTF/ xlsx files using SAS.

SASuserlot — Thu, 20 Oct 2022 22:31:39 GMT

thank you the references got what I need. It worked. Thanks you again.

options noxwait noxsync;
data _null_;
x 'attrib +r "D:\sample.rtf"';
run;