BookmarkSubscribeRSS Feed
deleted_user
Not applicable
I found the wonderful example from the SAS support site demonstrating how to generate multiple worksheets per Excel workbook without any file location warnings--this one, to be exact: http://support.sas.com/rnd/base/topics/templateFAQ/excelexamples.html#nowarn

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?
4 REPLIES 4
Eric_SAS
SAS Employee
Did you change the filepaths in the doc_head event in the tagset?

There are three places that will need your new filepath.

If you are using sas 9.1 I would also recommend that you take a look at
the ExcelXP tagset. With few exceptions this is the best way to create
workbooks at the current time.

The most current tagset and examples are available here.

http://support.sas.com/rnd/base/topics/odsmarkup

There are a few papers and more examples under papers and presentations.

http://support.sas.com/rndbase/topics/odsmarkup/pandp.html

Eric
Chevell_sas
SAS Employee
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;
start:
put "" NL;
put ' ';
put '' NL;
deleted_user
Not applicable
I could have sworn I changed all the paths earlier, but I left the program, went to lunch, returned, changed all the paths again, and now the program works. Go figure!

Yes, I have 9.1.3 and Excel 2002. I have to play around with the options somewhat, but I see how ExcelXP provides a lot of freedom without the filebased tables.

Thanks for the tips!
deleted_user
Not applicable
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....

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 904 views
  • 0 likes
  • 3 in conversation