Originally from Brantford, Ontario - University of Waterloo grad, settled in the Toronto area - spent three years in Saudi Arabia (hot, hot, hot)
In my spare time, I love to golf in the summer and curl in the winter.
SAS BI Suite - SAS Enterprise Guide and SAS Web Report Studio, SAS Information Map Studio
Health Care data - I'm responsible for the care and feeding of a large clinical data warehouse
On second thought, the stored process would need to be different for each query. The beauty of information maps is that they are dynamic and allow an endless variety of queries (selects and where clauses). The stored process will effectively tie our hands to a particular predefined set of parameters that may not suit all uses.
... View more
Thanks for your reply. We will try a stored process and then wrap that inside an information map. We have plenty of infomaps - so that might be a tedious exercise. The improved performance would be worth it. In the meantime, I'll keep bothering SAS to tell me why the Access engine does not support passing count distinct down to the database.
... View more
We use SAS 9.2, Oracle 11g and WRS 4.3. The SAS access engine will not pass any sql with count(distinct) down to Oracle. I've been wondering for years why not. I don't see why I need to prove this behaviour - it is common knowledge.
... View more
I wish the SAS optimizer in WRS would not tamper with SQL (submitted to a third-party database) that contains a count(distinct). Reading all the rows back to SAS and then doing the distinct count in SAS is so expensive in terms of I/O. Why can't it just send the SQL as-is?
... View more
I guess the user would be able to craft some "if then else" logic to define the values for the new item based on an existing data source column.
... View more
Hi,
Our users would really like to be able to derive new data items in WRS. Consider, a categorical item with 5,000 unique values. We can predefine several groupers in the Information Map but we will never cover all the possible combinations that users might want. If there was a CASE statement or some way of writing expressions, WRS would cover a lot more ground.
One answer is to use EG rather than WRS but we're really keen on the web tool rather than the desktop tool. WRS is much easier to use for the bulk of our user community.
Ian
... View more
Hi Everyone,
We'd like a way to force the use of a particular predefined filter as soon as the user selects an item for reporting. For example, I am selecting an item called "age group" which always requires selection of one of 20 or so predefined age groupings.
In other words, the background join from age to age grouping is dependent on the selection of one of the many possible groupings (i.e. part of the where clause).
When the user selects "age group" we want to ensure that the prompted filter is used at report run time rather than assuming that the user will always turn the prompted filter on.
We have about 50 maps where we'd like to use this functionality.Any thoughts?
Ian
p.s. We're still using 9.1
... View more