BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Hi,
I'm using excel tagsets to create an excel report using SAS/Intranet . When I run the program on my local machine it worked fine but when I copy into onto the Server and do "_webout" the program ran successfully and I also got that popup window where I can save the excel file. Here once I hit save it took long time for downloading the file from the server and finally when the download completed I see the an error Message " Problem came up in the following areas during load: Work Book Setting "

The file size was 6825 KB when I ran on my local machine.

Can someone help me resolve this error.



Regards,
Addy
1 REPLY 1
Cynthia_sas
SAS Super FREQ
Hi:
Usually, these type of Workbook setting errors or Table errors or Style errors come about because you are not using the most updated version of the tagset template. It is possible that you have one version of the template item store on your local machine and a different version of the item store on the server.

When you use SAS/IntrNet, you can use the _debug parameter to return the SAS log for your examination. This may provide some clue as to which version of the tagset template is being used. In addition, with SAS/IntrNet, you can use the APPSRV_HEADER function to explicitly send the appropriate CONTENT-TYPE header for the file (when you use _webout).

It's hard to debug SAS/IntrNet issues on the forum, because what comes into play is not just the code that you've put into the Application Dispatcher library, but the URL that you're using to execute that code, etc, etc.

You may want to open a track with Tech Support on this issue.

cynthia

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

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
  • 1 reply
  • 707 views
  • 0 likes
  • 2 in conversation