topic Re: SAS X Command and Read-Only in SAS Programming

SAS X Command and Read-Only

craig159753 — Mon, 09 May 2016 08:22:55 GMT

Hi all,

So I was wondering, can you run the following bit of code within SAS to set a file to read only mode?

x attrib r+ C:\My Work\Documents\example.doc;

%sysexec attrib r+ C:\My Work\Documents\example.doc;

I tried running it and it did not work, am I missing something?

Thanks!

Re: SAS X Command and Read-Only

RW9 — Mon, 09 May 2016 08:35:05 GMT

In your first example you miss quotes:

x 'attrib r+ "C:\My Work\Documents\example.doc"';

Note the singel quotes around the whole DOS part, and the double quotes around the path - double quotes are needed as there are spaces in the path - this means the actual underlying path is not really like that as old dos does not allow spaces or long paths etc. so the UNC path needs quoting.

Although why you are doing it this way is a mystery to me? If its needs to be secure then post it to a document storage (version/access controlled) such as Sharepoint, or use the VCS on your system. Otherwise every time you want to do anything you need to unlock run re-lock, which just seems a bit pointless.

Re: SAS X Command and Read-Only

RahulG — Mon, 09 May 2016 08:45:06 GMT

I think you command should be attrib +r instead of attrib r+

x attrib +r C:\My Work\Documents\example.doc

Even if it do not work then provide full path of attrib.exe i.e. C:\Windows\system32\attrib.exe

x C:\Windows\system32\attrib.exe +r C:\My Work\Documents\example.doc;

Re: SAS X Command and Read-Only

craig159753 — Mon, 09 May 2016 09:26:59 GMT

Hi Perfect!

I agree a CVS system is far better, however I am unable to use this at this moment in time.

Quick additional question is there a way to stop the command window open and closing, I want it to run like SAS code, with no windows popping out? Because currently when it runs, the command window flashes up quickly.

Re: SAS X Command and Read-Only

RW9 — Mon, 09 May 2016 09:30:42 GMT

Yep:

options noxwait;

http://support.sas.com/documentation/cdl/en/hostwin/67962/HTML/default/viewer.htm#n0xwt90ik8vxdrn13708w6n3nm4o.htm

Re: SAS X Command and Read-Only

craig159753 — Mon, 09 May 2016 09:38:32 GMT

Sorry I explained that poorly, the NOXWAIT means it closes the prompt and I return to SAS automatically, I just want to not see the command prompt pop up at all, even for a split second, I do not want to see it (this is my OCD kicking in!)

Re: SAS X Command and Read-Only

RW9 — Mon, 09 May 2016 09:50:04 GMT

Afraid not, if you call a shell command, it opens the command window.

Re: SAS X Command and Read-Only

FreelanceReinh — Mon, 09 May 2016 10:09:13 GMT

Hi @craig159753,

If you issue the shell command via a pipe, the command prompt should not pop up:

filename doscmd pipe 'attrib +r "C:\My Work\Documents\example.doc"';

data _null_;
infile doscmd;
run;