topic Re: Insufficient authorization to access clarification? in SAS Programming

Insufficient authorization to access clarification?

Phil_NZ — Thu, 06 May 2021 03:20:39 GMT

Hi all SAS Users,

When running the code below, I face an error:

PROC IMPORT OUT= WORK.PARM  DATAFILE= "C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & operating\test_present\parm.xls"  DBMS=EXCEL REPLACE;
  RANGE="parm";
  GETNAMES=YES;
  MIXED=NO;
  SCANTEXT=YES;
  USEDATE=YES;
  SCANTIME=YES;
RUN;
/*write a dataset with standard error on the same column of coefficient*/
data parm2;
set parm;
if not missing(stderr) and variable not in ('R-square','Adj.R-sq','N. Obs.') then do; 
value=estimate; type='coefficient'; output; end;
if not missing(stderr) then do; value=stderr; type='stderr' ;output; end;
if variable in ('R-square','Adj.R-sq','N. Obs.') then do; value=estimate; type=variable ;output; end; 
run;


proc format;           
	picture stderrf (round)       
     	low-high=' 9.9999)' (prefix='(')                                
            .=' ';                                                  
run;



ods html close;
ods html;
title;

64         ods html close;
65         ods html;
NOTE: Writing HTML Body file: sashtml16.htm
ERROR: Insufficient authorization to access C:\WINDOWS\system32\sashtml16.htm.
ERROR: No body file. HTML output will not be created.

I did a search and see the solution from @Reeza in this discussion but I do not understand the solution, therefore do not know how to apply in my case.

Apart from that, I also follow @Damo in this post to add "ods listing close;" at the top of my code but it still does not work.

34 ods listing close;
35 ods html close;
36 ods html;

NOTE: Writing HTML Body file: sashtml22.htm

ERROR: Insufficient authorization to access C:\WINDOWS\system32\sashtml22.htm.

ERROR: No body file. HTML output will not be created.ods listing close;
ods html close;
ods html;
title;

In this post, @Damo also mentioned that we can use PRINT System option Window to write the output to another folder but it is only for lst file, not htm.

I much appreciate if you can have a look on that?

Warm regards and thanks.

Re: Insufficient authorization to access clarification?

ballardw — Thu, 06 May 2021 03:36:52 GMT

What is most likely happening is your ODS Html has no file listed as an actual destination. So SAS is using an unexpected location :C:\windows\system32 and you don't have write permissions in that folder.

If you explicitly use an ODS destination it is a good idea to specify where that location will be and it needs to be one you know you have write access.

Re: Insufficient authorization to access clarification?

Phil_NZ — Thu, 06 May 2021 03:53:07 GMT

Thank you @ballardw for your explanation, but I am really naive regarding operating system thing.

If you explicitly use an ODS destination it is a good idea to specify where that location will be and it needs to be one you know you have write access.

I am ambiguous about this sentence, I much appreciate it if you can explain to me, what should I do to know which location I have write access to, please? I am using the desktop from my school.

Thank you.

Re: Insufficient authorization to access clarification?

SASKiwi — Thu, 06 May 2021 03:59:45 GMT

You need to specify a folder and file location on your ODS "open" statements to avoid writing to a default location you don't have access to:

ods html file="c:\temp\MyHTMLfile.htm";

Re: Insufficient authorization to access clarification?

Phil_NZ — Thu, 06 May 2021 04:04:19 GMT

Many thanks and warm regards, @SASKiwi