Hi,
I have multiple tabulates within my SAS code but when I come to connect it in excel via the web connection, I get this error message
This file could not be accessed. Try one of the following:
- Make sure the specific folder exisits
- Make sure the folder contains the file is not read only
- Make sure the file name does not contain any of the following charecters < > ? [ ] : | or *
- Make sure the file/path name doesn't contain more than 218 charecters
All of these seem fine so I am at a loss as to why it won't work. Any ideas please?
This is the HTML SAS String used
ods html body="X:/location/Dep/Area/KTY.HTML" style=HTMLBlue;
Then closed off the tabulate with
run;
ods html close;
I have tried to open it with Internet explorer and Chrome but neither work.
Hi Brandon,
Try this instead
ODS HTML path='X:\location\Dep\Area\' body='KTY.HTML'
I get this error message when running with that code
'body=
___
22
202
16 ! 'KTY.HTML'
ERROR 22-322: Syntax error, expecting one of the following: ;, (, ANCHOR, ARCHIVE, ATTRIBUTES, BASE,
BODY, CHARSET, CLOSE, CODE, CONTENTS, CSS, CSSSTYLE, ENCODING, FILE, FRAME, GFOOTNOTE,
GPATH, GTITLE, HEADTEXT, IMAGE_DPI, LAYOUT, METATEXT, NEWFILE, NOGFOOTNOTE, NOGTITLE,
OPTIONS, PACKAGE, PAGE, PARAMETERS, PATH, RECORD_SEPARATOR, RENDER, STYLE, STYLESHEET,
TEXT, TRANTAB.
ERROR 202-322: The option or parameter is not recognized and will be ignored.
But it works fine for me
ods html path='C:\Users\Wong\Desktop\' body='cars.html';
proc print data=sashelp.cars; run;
ods html close;
7 ODS HTML path='C:\Users\Wong\Desktop\' body='cars.html';
NOTE: Writing HTML Body file: cars.html
8 proc print data=sashelp.cars; run;
NOTE: There were 428 observations read from the data set SASHELP.CARS.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.48 seconds
cpu time 0.31 seconds
9 ods html close;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.