BookmarkSubscribeRSS Feed
steve_citi
Calcite | Level 5
I do not have the directory location where the error messages for this type of error are placed. Is there any other way to diagnose what this error is? I am using the latest excelxp tagset (1.86).

Can I somehow redirect the error messages to another location?
5 REPLIES 5
Cynthia_sas
SAS Super FREQ
Hi:
If you have a worksheet error when opening a TAGSET.EXCELXP spreadsheet, the error comes from Excel having a problem with the XML or the STYLE. Usually, the error file from Excel is put in Documents and Settings under Local Application Data or something...I don't remember the exact location.

Whether you -can- redirect the error messages to another location would be a Microsoft Office setting.

cynthia
Linda_V
Obsidian | Level 7
I am using SAS on a server platform and trying to output a multiple sheet xls. I am trying to output the xls using Style=Normal and getting a Worksheet setting error when I try to open up the xls. I can use Style=EGDefault it will work, however I do not want those settings for the report.

I can not run the Tagsets because I don't have access to where the tagsets need to write to.. so I am trying to get some sort of work-around to work...

Any solutions??

Thanks..
Cynthia_sas
SAS Super FREQ
Hi:
When you use TAGSETS.EXCELXP to create a multi-worksheet file, you are creating a Microsoft Excel XML file that conforms to the Office 2003 specification for Spreadsheet Markup Language XML. So, you are not creating a "true binary .XLS file" -- you are creating an XML file that Excel 2003 knows how to open.

The issue with STYLE=NORMAL is interesting. On my machine, I can run a job using STYLE=NORMAL with TAGSETS.EXCELXP version SAS 9.1.3, v1.75, 07/26/07 and have no issues at all on opening the file. Can you examine the SAS log from your server job? I wonder whether you are getting a message like this in the log:
[pre]
WARNING: Style NORMAL not found; Default style will be used instead.
[/pre]

I don't understand what you mean by not being able to "run the Tagsets" -- the NORMAL style is a STYLE template, not a TAGSET template. You would not necessarily have to do anything with a TAGSET template in order to switch to a different style template. If STYLE=NORMAL isn't on the server machine, it may be that you will have to use EGDEFAULT or one of the other styles that is available on the server. One thing that you can do is submit a PROC TEMPLATE job -- to run on the server machine -- to see what the list of available style templates is.

Can you post the code you are running -- perhaps using SASHELP.CLASS or a simple PROC PRINT if you don't want to show your whole program? Are you submitting the code via the EG interface or as a stored process or through the SAS Add-in for Microsoft Office???

cynthia
deleted_user
Not applicable
C:\Documents and Settings\\Local Settings\Temporary Internet Files\Content.MSO

Check under the above folder. would be your user. what ever it is.

As Cynthia stated when you open a SAS generated XLS/XML file with errors, a SAS log file will be created in the above location. That log file gives you information on where you went wrong like STYLE , XML or unspecified. I usually see unspecified
error if my Excel file has too much of data.

Addy
Peter_C
Rhodochrosite | Level 12
the path that SASmatt reports is like one of those "magic" keywords.
Microsoft offers no way to redirect it, so it may be very reliable - at least until vista or windows 7 adapts the profile path or %temp% path
PeterC

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
  • 5 replies
  • 2799 views
  • 0 likes
  • 5 in conversation