sq

Problem Notes for SAS®9 - 65682: Running FedSQL with an Oracle table is slow, even when you use a LIMIT clause

When you query an Oracle table and use the LIMIT clause using either SAS  Federation Server or FedSQL, a row limit is not passed to the database. In this scenario, a Full Article



sq

Problem Notes for SAS®9 - 65835: A series of PROC SQL queries might not generate a distinct set of rows

A set of PROC SQL queries that create a view, contain a constant column, contain a computed column, and a create a table do not generate a unique set of rows in the table that is created.




sq

Problem Notes for SAS®9 - 65597: An SQL procedure query with a WHERE clause that contains multiple subselects might return incorrect results

An issue occurs when code contains a complex SQL procedure query with a WHERE clause that contains multiple subselects. Incorrect results might be returned. Click the Hot Fix tab in this note to




sq

CARPHA urges public to guard against mosquito-borne diseases

PORT OF SPAIN, Trinidad, CMC – The Trinidad-based Caribbean Public Health Agency (CARPHA) is urging people in the region to remember that despite the coronavirus (COVID-19) pandemic, they must be mindful that other public health threats still...




sq

Square peg in an octagonal hole

Interview with Ari Nieh, with commentary from Yvonne Lai Like many of us, I began teaching online this Spring. Unlike many of us, I began doing so at the start of the semester. I am co-teaching a class at Michigan … Continue reading




sq

Memo: Prior COVID-19 diagnosis 'permanently disqualifying' for U.S. military service

Military Entrance Processing Stations won't process individuals who have had COVID-19 for military service, even if they've fully recovered from the virus, the Pentagon confirmed this week.




sq

David wins record sixth squash world title

Malaysian squash superstar Nicol David has won a record sixth women's World Open title, overtaking Australia's Sarah Fitz-Gerald.




sq

Squirrels and Stock Brokers, Or: Innovation Dilemmas, Robustness and Probability

Decisions are made in order to achieve desirable outcomes. An innovation dilemma arises when a seemingly more attractive option is also more uncertain than other options. In this essay we explore the relation between the innovation dilemma and the robustness of a decision, and the relation between robustness and probability. A decision is robust to uncertainty if it achieves required outcomes despite adverse surprises. A robust decision may differ from the seemingly best option. Furthermore, robust decisions are not based on knowledge of probabilities, but can still be the most likely to succeed.

Squirrels, Stock-Brokers and Their Dilemmas




Decision problems.
Imagine a squirrel nibbling acorns under an oak tree. They're pretty good acorns, though a bit dry. The good ones have already been taken. Over in the distance is a large stand of fine oaks. The acorns there are probably better. But then, other squirrels can also see those trees, and predators can too. The squirrel doesn't need to get fat, but a critical caloric intake is necessary before moving on to other activities. How long should the squirrel forage at this patch before moving to the more promising patch, if at all?

Imagine a hedge fund manager investing in South African diamonds, Australian Uranium, Norwegian Kroners and Singapore semi-conductors. The returns have been steady and good, but not very exciting. A new hi-tech start-up venture has just turned up. It looks promising, has solid backing, and could be very interesting. The manager doesn't need to earn boundless returns, but it is necessary to earn at least a tad more than the competition (who are also prowling around). How long should the manager hold the current portfolio before changing at least some of its components?

These are decision problems, and like many other examples, they share three traits: critical needs must be met; the current situation may or may not be adequate; other alternatives look much better but are much more uncertain. To change, or not to change? What strategy to use in making a decision? What choice is the best bet? Betting is a surprising concept, as we have seen before; can we bet without knowing probabilities?

Solution strategies.
The decision is easy in either of two extreme situations, and their analysis will reveal general conclusions.

One extreme is that the status quo is clearly insufficient. For the squirrel this means that these crinkled rotten acorns won't fill anybody's belly even if one nibbled here all day long. Survival requires trying the other patch regardless of the fact that there may be many other squirrels already there and predators just waiting to swoop down. Similarly, for the hedge fund manager, if other funds are making fantastic profits, then something has to change or the competition will attract all the business.

The other extreme is that the status quo is just fine, thank you. For the squirrel, just a little more nibbling and these acorns will get us through the night, so why run over to unfamiliar oak trees? For the hedge fund manager, profits are better than those of any credible competitor, so uncertain change is not called for.

From these two extremes we draw an important general conclusion: the right answer depends on what you need. To change, or not to change, depends on what is critical for survival. There is no universal answer, like, "Always try to improve" or "If it's working, don't fix it". This is a very general property of decisions under uncertainty, and we will call it preference reversal. The agent's preference between alternatives depends on what the agent needs in order to "survive".

The decision strategy that we have described is attuned to the needs of the agent. The strategy attempts to satisfy the agent's critical requirements. If the status quo would reliably do that, then stay put; if not, then move. Following the work of Nobel Laureate Herbert Simon, we will call this a satisficing decision strategy: one which satisfies a critical requirement.

"Prediction is always difficult, especially of the future." - Robert Storm Petersen

Now let's consider a different decision strategy that squirrels and hedge fund managers might be tempted to use. The agent has obtained information about the two alternatives by signals from the environment. (The squirrel sees grand verdant oaks in the distance, the fund manager hears of a new start up.) Given this information, a prediction can be made (though the squirrel may make this prediction based on instincts and without being aware of making it). Given the best available information, the agent predicts which alternative would yield the better outcome. Using this prediction, the decision strategy is to choose the alternative whose predicted outcome is best. We will call this decision strategy best-model optimization. Note that this decision strategy yields a single universal answer to the question facing the agent. This strategy uses the best information to find the choice that - if that information is correct - will yield the best outcome. Best-model optimization (usually) gives a single "best" decision, unlike the satisficing strategy that returns different answers depending on the agent's needs.

There is an attractive logic - and even perhaps a moral imperative - to use the best information to make the best choice. One should always try to do one's best. But the catch in the argument for best-model optimization is that the best information may actually be grievously wrong. Those fine oak trees might be swarming with insects who've devoured the acorns. Best-model optimization ignores the agent's central dilemma: stay with the relatively well known but modest alternative, or go for the more promising but more uncertain alternative.

"Tsk, tsk, tsk" says our hedge fund manager. "My information already accounts for the uncertainty. I have used a probabilistic asset pricing model to predict the likelihood that my profits will beat the competition for each of the two alternatives."

Probabilistic asset pricing models are good to have. And the squirrel similarly has evolved instincts that reflect likelihoods. But a best-probabilistic-model optimization is simply one type of best-model optimization, and is subject to the same vulnerability to error. The world is full of surprises. The probability functions that are used are quite likely wrong, especially in predicting the rare events that the manager is most concerned to avoid.

Robustness and Probability

Now we come to the truly amazing part of the story. The satisficing strategy does not use any probabilistic information. Nonetheless, in many situations, the satisficing strategy is actually a better bet (or at least not a worse bet), probabilistically speaking, than any other strategy, including best-probabilistic-model optimization. We have no probabilistic information in these situations, but we can still maximize the probability of success (though we won't know the value of this maximum).

When the satisficing decision strategy is the best bet, this is, in part, because it is more robust to uncertainty than another other strategy. A decision is robust to uncertainty if it achieves required outcomes even if adverse surprises occur. In many important situations (though not invariably), more robustness to uncertainty is equivalent to being more likely to succeed or survive. When this is true we say that robustness is a proxy for probability.

A thorough analysis of the proxy property is rather technical. However, we can understand the gist of the idea by considering a simple special case.

Let's continue with the squirrel and hedge fund examples. Suppose we are completely confident about the future value (in calories or dollars) of not making any change (staying put). In contrast, the future value of moving is apparently better though uncertain. If staying put would satisfy our critical requirement, then we are absolutely certain of survival if we do not change. Staying put is completely robust to surprises so the probability of success equals 1 if we stay put, regardless of what happens with the other option. Likewise, if staying put would not satisfy our critical requirement, then we are absolutely certain of failure if we do not change; the probability of success equals 0 if we stay, and moving cannot be worse. Regardless of what probability distribution describes future outcomes if we move, we can always choose the option whose likelihood of success is greater (or at least not worse). This is because staying put is either sure to succeed or sure to fail, and we know which.

This argument can be extended to the more realistic case where the outcome of staying put is uncertain and the outcome of moving, while seemingly better than staying, is much more uncertain. The agent can know which option is more robust to uncertainty, without having to know probability distributions. This implies, in many situations, that the agent can choose the option that is a better bet for survival.

Wrapping Up

The skillful decision maker not only knows a lot, but is also able to deal with conflicting information. We have discussed the innovation dilemma: When choosing between two alternatives, the seemingly better one is also more uncertain.

Animals, people, organizations and societies have developed mechanisms for dealing with the innovation dilemma. The response hinges on tuning the decision to the agent's needs, and robustifying the choice against uncertainty. This choice may or may not coincide with the putative best choice. But what seems best depends on the available - though uncertain - information.

The commendable tendency to do one's best - and to demand the same of others - can lead to putatively optimal decisions that may be more vulnerable to surprise than other decisions that would have been satisfactory. In contrast, the strategy of robustly satisfying critical needs can be a better bet for survival. Consider the design of critical infrastructure: flood protection, nuclear power, communication networks, and so on. The design of such systems is based on vast knowledge and understanding, but also confronts bewildering uncertainties and endless surprises. We must continue to improve our knowledge and understanding, while also improving our ability to manage the uncertainties resulting from the expanding horizon of our efforts. We must identify the critical goals and seek responses that are immune to surprise. 




sq

Coronavirus Squeezes Supply of Chromebooks, iPads, and Other Digital Learning Devices

School districts are competing against each other for purchases of digital devices as remote learning expands to schools across the country.




sq

A reproducible framework for 3D acoustic forward modelling of hard rock geological models with Madagascar / Andrew Squelch, Mahyar Madadi, Milovan Urosevic.

"A special challenge of hard rock exploration is to identify targets of interest within complex geological settings. Interpretation of the geology can be made from direct geological observations and knowledge of the area, and from 2D or 3D seismic surveys. These interpretations can be developed into 3D geological models that provide the basis for predictions as to likely targets for drilling and/or mining. To verify these predictions we need to simulate 3D seismic wave propagation in the proposed geological models and compare the simulation results to seismic survey data. To achieve this we convert geological surfaces created in an interpretation software package into discretised block models representing the different lithostratigraphic units, and segment these into discrete volumes to which appropriate density and seismic velocity values are assigned. This approach allows us to scale models appropriately for desired wave propagation parameters and to go from local to global geological models and vice versa. Then we use these digital models with forward modelling codes to undertake numerous 3D acoustic wave simulations. Simulations are performed with single shot and with exploding reflector (located on extracted geological surface) configurations" -- Summary.




sq

I'm Not a Squid!.




sq

Esquisse de nosographie vétérinaire / par J.-B. Huzard.

Paris : M. Huzard, 1820.




sq

Esquisse psychologique des peuples européens / par Alfred Fouillee.

Paris : Alcan, 1903.




sq

Grotesque ornament. Engravings by or after J. Androuet du Cerceau.

[Paris?] : [J. Androuet du Cerceau?], [1562?]




sq

O problema do abuso de drogas prevenção através investigação, pesquisa e educação / Murillo de Macedo Pereira, Vera Kühn de Macedo Pereira.

São Paulo : Governo do Estado de Sao Paulo, Secretaria da Segurança Pública, 1975.




sq

A pesquisa sobre o problema do abuso de drogas / Murillo de Macedo Pereira.

São Paulo : Serviço Grafíco da Secretaria da Segurança Pública, 1976.




sq

Monotone least squares and isotonic quantiles

Alexandre Mösching, Lutz Dümbgen.

Source: Electronic Journal of Statistics, Volume 14, Number 1, 24--49.

Abstract:
We consider bivariate observations $(X_{1},Y_{1}),ldots,(X_{n},Y_{n})$ such that, conditional on the $X_{i}$, the $Y_{i}$ are independent random variables. Precisely, the conditional distribution function of $Y_{i}$ equals $F_{X_{i}}$, where $(F_{x})_{x}$ is an unknown family of distribution functions. Under the sole assumption that $xmapsto F_{x}$ is isotonic with respect to stochastic order, one can estimate $(F_{x})_{x}$ in two ways: (i) For any fixed $y$ one estimates the antitonic function $xmapsto F_{x}(y)$ via nonparametric monotone least squares, replacing the responses $Y_{i}$ with the indicators $1_{[Y_{i}le y]}$. (ii) For any fixed $eta in (0,1)$ one estimates the isotonic quantile function $xmapsto F_{x}^{-1}(eta)$ via a nonparametric version of regression quantiles. We show that these two approaches are closely related, with (i) being more flexible than (ii). Then, under mild regularity conditions, we establish rates of convergence for the resulting estimators $hat{F}_{x}(y)$ and $hat{F}_{x}^{-1}(eta)$, uniformly over $(x,y)$ and $(x,eta)$ in certain rectangles as well as uniformly in $y$ or $eta$ for a fixed $x$.




sq

Estimation of a semiparametric transformation model: A novel approach based on least squares minimization

Benjamin Colling, Ingrid Van Keilegom.

Source: Electronic Journal of Statistics, Volume 14, Number 1, 769--800.

Abstract:
Consider the following semiparametric transformation model $Lambda_{ heta }(Y)=m(X)+varepsilon $, where $X$ is a $d$-dimensional covariate, $Y$ is a univariate response variable and $varepsilon $ is an error term with zero mean and independent of $X$. We assume that $m$ is an unknown regression function and that ${Lambda _{ heta }: heta inTheta }$ is a parametric family of strictly increasing functions. Our goal is to develop two new estimators of the transformation parameter $ heta $. The main idea of these two estimators is to minimize, with respect to $ heta $, the $L_{2}$-distance between the transformation $Lambda _{ heta }$ and one of its fully nonparametric estimators. We consider in particular the nonparametric estimator based on the least-absolute deviation loss constructed in Colling and Van Keilegom (2019). We establish the consistency and the asymptotic normality of the two proposed estimators of $ heta $. We also carry out a simulation study to illustrate and compare the performance of our new parametric estimators to that of the profile likelihood estimator constructed in Linton et al. (2008).




sq

Mosquito Control Program




sq

Requirements engineering : 26th International Working Conference, REFSQ 2020, Pisa, Italy, March 24-27, 2020, Proceedings

REFSQ (Conference) (26th : 2020 : Pisa, Italy)
9783030444297




sq

Mosquitoes, communities, and public health in Texas

9780128145463 (electronic bk.)




sq

Envelope-based sparse partial least squares

Guangyu Zhu, Zhihua Su.

Source: The Annals of Statistics, Volume 48, Number 1, 161--182.

Abstract:
Sparse partial least squares (SPLS) is widely used in applied sciences as a method that performs dimension reduction and variable selection simultaneously in linear regression. Several implementations of SPLS have been derived, among which the SPLS proposed in Chun and Keleş ( J. R. Stat. Soc. Ser. B. Stat. Methodol. 72 (2010) 3–25) is very popular and highly cited. However, for all of these implementations, the theoretical properties of SPLS are largely unknown. In this paper, we propose a new version of SPLS, called the envelope-based SPLS, using a connection between envelope models and partial least squares (PLS). We establish the consistency, oracle property and asymptotic normality of the envelope-based SPLS estimator. The large-sample scenario and high-dimensional scenario are both considered. We also develop the envelope-based SPLS estimators under the context of generalized linear models, and discuss its theoretical properties including consistency, oracle property and asymptotic distribution. Numerical experiments and examples show that the envelope-based SPLS estimator has better variable selection and prediction performance over the SPLS estimator ( J. R. Stat. Soc. Ser. B. Stat. Methodol. 72 (2010) 3–25).




sq

Convergence rates of least squares regression estimators with heavy-tailed errors

Qiyang Han, Jon A. Wellner.

Source: The Annals of Statistics, Volume 47, Number 4, 2286--2319.

Abstract:
We study the performance of the least squares estimator (LSE) in a general nonparametric regression model, when the errors are independent of the covariates but may only have a $p$th moment ($pgeq1$). In such a heavy-tailed regression setting, we show that if the model satisfies a standard “entropy condition” with exponent $alphain(0,2)$, then the $L_{2}$ loss of the LSE converges at a rate [mathcal{O}_{mathbf{P}}igl(n^{-frac{1}{2+alpha}}vee n^{-frac{1}{2}+frac{1}{2p}}igr).] Such a rate cannot be improved under the entropy condition alone. This rate quantifies both some positive and negative aspects of the LSE in a heavy-tailed regression setting. On the positive side, as long as the errors have $pgeq1+2/alpha$ moments, the $L_{2}$ loss of the LSE converges at the same rate as if the errors are Gaussian. On the negative side, if $p<1+2/alpha$, there are (many) hard models at any entropy level $alpha$ for which the $L_{2}$ loss of the LSE converges at a strictly slower rate than other robust estimators. The validity of the above rate relies crucially on the independence of the covariates and the errors. In fact, the $L_{2}$ loss of the LSE can converge arbitrarily slowly when the independence fails. The key technical ingredient is a new multiplier inequality that gives sharp bounds for the “multiplier empirical process” associated with the LSE. We further give an application to the sparse linear regression model with heavy-tailed covariates and errors to demonstrate the scope of this new inequality.




sq

Modifying the Chi-square and the CMH test for population genetic inference: Adapting to overdispersion

Kerstin Spitzer, Marta Pelizzola, Andreas Futschik.

Source: The Annals of Applied Statistics, Volume 14, Number 1, 202--220.

Abstract:
Evolve and resequence studies provide a popular approach to simulate evolution in the lab and explore its genetic basis. In this context, Pearson’s chi-square test, Fisher’s exact test as well as the Cochran–Mantel–Haenszel test are commonly used to infer genomic positions affected by selection from temporal changes in allele frequency. However, the null model associated with these tests does not match the null hypothesis of actual interest. Indeed, due to genetic drift and possibly other additional noise components such as pool sequencing, the null variance in the data can be substantially larger than accounted for by these common test statistics. This leads to $p$-values that are systematically too small and, therefore, a huge number of false positive results. Even, if the ranking rather than the actual $p$-values is of interest, a naive application of the mentioned tests will give misleading results, as the amount of overdispersion varies from locus to locus. We therefore propose adjusted statistics that take the overdispersion into account while keeping the formulas simple. This is particularly useful in genome-wide applications, where millions of SNPs can be handled with little computational effort. We then apply the adapted test statistics to real data from Drosophila and investigate how information from intermediate generations can be included when available. We also discuss further applications such as genome-wide association studies based on pool sequencing data and tests for local adaptation.




sq

Letter from J. H Bannatyne to Other Windsor Berry Esq. relating to the Myall Creek Massacre, 17 December 1838




sq

The 2019 Victoria&rsquo;s Secret Fashion Show Is Canceled After Facing Backlash for Lack of Body Diversity

The reaction on social media has been fierce.




sq

Editor&rsquo;s Pick: Gifts for Your Tech-Obsessed Friend

A guide to the tech gadgets even your hard-to-shop-for friends and family members will love.




sq

Taylor Swift, Hailey Bieber, and Tons of Other Celebs&rsquo; Favorite Leggings Are on Sale Ahead of Black Friday

Here’s where you can snag their Alo Yoga Moto leggings for less.




sq

Macy&rsquo;s Insane Cyber Monday Sale Ends in a Few Hours&mdash;Here Are the Best Deals

You've got exactly four hours left to take advantage of these heavily discounted prices.




sq

Katie Holmes&rsquo;s Affordable Sneakers Are the Star of Her Latest Outfit

Meghan Markle is also a fan of the comfy shoes.




sq

These Clark Booties Are Actually Comfortable Enough to Wear All Day&mdash;and They&rsquo;re on Sale

You can save 50% right now. 




sq

This is the Only Jacket I&rsquo;ll Be Living in This Winter

Canada Goose has long been a leader in the outdoor gear space.




sq

Of Course Katie Holmes Found This Year&rsquo;s Coziest Winter Boot

Keep your feet happy this winter.




sq

Questions fréquemment posées sur les exigences de fonds propres en regard du risque de marché

French translation of "Frequently asked questions on market risk capital requirements" by the Basel Committee, March 2018.




sq

Les banques centrales et la dette : des risques émergents pour l efficacité de la politique monétaire en Afrique

French translation of BIS Papers No 99 - Central banks and debt: emerging risks to the effectiveness of monetary policy in Africa?, October 2018.




sq

Les Big Tech dans la finance : opportunités et risques

French version of BIS Press Release - Big tech in finance: opportunities and risks, 23 June 2019




sq

Art Is Dead Bosque: Photographs of the Rio Grande




sq

200-Million-Year-Old Fossil Captures Squid Viciously Entangled With Its Prey

The specimen may be the earliest known example of a squid-like creature on the attack




sq

Comment on Squeekville, model train amusement park, on display at Children’s Museum Gala – Oak Ridger by modelsteamtrain

<span class="topsy_trackback_comment"><span class="topsy_twitter_username"><span class="topsy_trackback_content">Squeekville, model train amusement park, on display at Children's ...: Squeekville, model train amusement park, ... http://bit.ly/9x4oFS</span></span>




sq

Squarespace

Squarespace offers numerous useful tools for building attractive, functional sites for personal and small business use. Users will need to rebuild their sites if they want to upgrade to the latest version of the service, however.




sq

Unforgettable squeals of joy

Rex from the USA, volunteered for two months in the Baseball and Softball Programme alongside OMers Terry Lingenhoel and Suzanne Cole this spring.




sq

Opinion: Struan Stevenson: As Iraq's corrupt elite squabble, young protesters could sweep them away

IRAQ’S prime ministerial merry-go-round continues to spin apace. Spy chief Mustafa al-Kadhimi, director of the country’s National Intelligence Service, is now the third prime minister designate this year, following the withdrawal of the two previous prospective candidates.




sq

Women's Champions League Squad of the Season 2018/19

UEFA's technical observers have selected their all-star squad from the 2018/19 UEFA Women's Champions League.




sq

Crise au Burundi : un risque régional

Le 20 août, Pierre Nkurunziza a été investi pour la troisième fois. Son investiture, annoncée le matin même, a eu lieu presque en catimini et les ambassadeurs européens et américains accrédités à Bujumbura étaient visiblement absents tout comme l’Union africaine. La multiplication des assassinats en août a conduit la présidence à organiser l’investiture à la sauvette.




sq

Champions League Fantasy Matchday 7: The Scout squad

As the knockout stage kicks off this week, The Scout has put together a squad drawing on players from nine teams.




sq

Simple MySQLi database access wrapper

Package:
Summary:
Connect and query a MySQL database using MySQLi
Groups:
Author:
Description:
This class can Connect and query a MySQL database using the MySQLi extension...

Read more at https://www.phpclasses.org/package/11624-PHP-Connect-and-query-a-MySQL-database-using-MySQLi.html#2020-04-26-03:02:16




sq

LMSQL

Package:
Summary:
Connect and perform MySQL database queries
Groups:
Author:
Description:
This class can connect and perform MySQL database queries...

Read more at https://www.phpclasses.org/package/11608-PHP-Connect-and-perform-MySQL-database-queries.html#2020-04-30-01:41:49




sq

Champions League Fantasy Matchday 8: The Scout squad

Home advantage could be key with 13 of the 15 players in The Scout's squad playing second legs on their own ground.




sq

Debating Independence: Delaware’s John Dickinson Squares Off with Thomas Jefferson LIVE in Dover

On Sunday, Nov. 19, The Old State House will host an engaging historical dramatic production, John Dickinson and Thomas Jefferson Debate Independence: “We have called by different names brethren of the same principle,” presented by the American Historical Theatre of Philadelphia.




sq

Templeton Apologises To Market Regulator Sebi, Says CEO Was Misquoted

US-based Franklin Templeton on Friday issued an apology to capital market regulator Securities and Exchange Board of India (Sebi) for any misunderstanding over the closure of six of its schemes in the...