BookmarkSubscribeRSS Feed
NKey11
Calcite | Level 5

Hi All

In SAS example /Products/SAS Intelligence Platform/Samples/Sample: Shoe Sales by Region code:

 

%let _ODSOPTIONS=%str(body=region1.html newfile=table);

%STPBEGIN;

proc report data=work.shoes nowd;

column region subsidiary product sales inventory returns;

define region / order noprint "Region";

define subsidiary / order "Subsidiary";

define product / order "Shoe Style";

define sales / sum "Sales";

define inventory / sum "Inventory";

define returns / sum "Returns";

break after subsidiary / summarize suppress style=Header;

break before region / page ;

compute before _page_ / center style=BeforeCaption;

line "Men's and Women's Shoe Sales Figures for " region $25.;

endcomp;

run;

*;

* Use STPEND to close the HTML output destination so that ODS will

* write the appropriate HTML to mark the end of the documents that

* have been created.

*;

%STPEND;

 

enables creating html files referred by links for each region.

 

My question is: when I try to create large number of files (let's say 1000) the first redirection from clicked link in SASPortal takes for example 10-20 second. And then every next navigation between links takes 1-3 seconds (seems like in a meantime some caching or optimalization was made). Is there any solution to force quick file searching (caching) in such case, not to wait longer for the first time ?

 

Best Regards

 

Norbert

 

 

 

2 REPLIES 2
Cynthia_sas
SAS Super FREQ
Hi, Norbert:
It sounds to me like something in the browser is still loading or hasn't finished loading when you click the first link.

I don't know of any option to force or impact caching. This would be the kind of thing where I would recommend you open a track with Tech Support. They are much better at performance type questions than anyone else I know.

cynthia
NKey11
Calcite | Level 5

Hi Cynthia

Thank you for your time. I will try to tackle this problem with TechSupport then.

Best Regards

Norbert

sas-innovate-2024.png

 

Secure your spot at the must-attend AI and analytics event of 2024: SAS Innovate 2024! Get ready for a jam-packed agenda featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events.

 

Register by March 1 to snag the Early Bird rate of just $695! Don't miss out on this exclusive offer. 

 

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
  • 2 replies
  • 824 views
  • 1 like
  • 2 in conversation