I've modified it to fit with my dataset, locations, output, etc., and it still gives me the "Some of the files in this Web page are not in the expected location" warning.
One interesting point: when I modified my filepaths to make the Excel file (allstudents.xls) generate in the root C:\ directory and the xml/html files to generate in the C:\allstudents_files directory, I had no problems and the program ran as intended. My issues started when I used an extended filepath to where I normally store my SAS programs and such, in a subdirectory on C.
Why would a subdirectory cause problems, if I still have the _files subdirectory within the subdirectory?
Do you also have this path specified in the tag within the event doc_head? Also if you have SAS 9.1 and Excel 2002 or greater, the ExcelXP tagset would be a better option because it allows you to generate multiple worksheets per workbook which is not file based.
define event doc_head;
put "" NL;
put ' ';
put '' NL;
Just a note of caution of writng files to the root directory of a drive. I accidently wrote 25,000 files to c:\ once - and that poor machine was never quite the same. I deleted the files immediately I realized the error, but the damage was already done....