Posts Tagged ‘ measures ’

OLAP Cube Studio: Looking at PROC OLAP Code

March 5, 2012
By
OLAP Cube Studio: Looking at PROC OLAP Code

If you have never worked with OLAP code – then you might be curious how it works and what it looks like. Some developers use SAS OLAP Cube Studio to start their cube building process since it saves some of the typing required. Let’s review some of the code. [Adv Users: check out Steve's...
Read more »

Tags: , , , , , ,
Posted in SAS | Comments Off

Info Map: I want an Average not a Sum!

September 14, 2011
By

Warning: get_headers() [function.get-headers]: php_network_getaddresses: getaddrinfo failed: Name or service not known in /home/zeevgali/public_html/wp-content/themes/magazine-basic/functions.php on line 859

Warning: get_headers(http://www.sasbibooks.com/wp-content/uploads/2011/08/blog_imap_change-default-measure.jpg) [function.get-headers]: failed to open stream: php_network_getaddresses: getaddrinfo failed: Name or service not known in /home/zeevgali/public_html/wp-content/themes/magazine-basic/functions.php on line 859

In Information Map Studio, you can easily set the default measure for a data item in the Properties area. (1)  Use the Default aggregate function drop-down to select the default.  When you set this item to AVERAGE, the data item defaults to Average t...
Read more »

Tags: , ,
Posted in SAS | Comments Off

Info Map: Why does the data item show as scientific notation?

September 8, 2011
By

Warning: get_headers() [function.get-headers]: php_network_getaddresses: getaddrinfo failed: Name or service not known in /home/zeevgali/public_html/wp-content/themes/magazine-basic/functions.php on line 859

Warning: get_headers(http://www.sasbibooks.com/wp-content/uploads/2011/08/imap_gross_margin_scientific.jpg) [function.get-headers]: failed to open stream: php_network_getaddresses: getaddrinfo failed: Name or service not known in /home/zeevgali/public_html/wp-content/themes/magazine-basic/functions.php on line 859

When a data item is created in Information Map Studio, the defaults are assigned for classifications and aggregations.  If the data item is a percentage, this defaults may not make sense.  For instance, the following figure shows the Gross Margin in scientific notation instead of a percentage. When the data item was imported, the...
Read more »

Tags: , , , ,
Posted in SAS | Comments Off

Proc-x is looking for sponsors!

Dear readers, proc-x is looking for sponsors who would be willing to support the site in exchange for banner ads in the right sidebar of the site. If you are interested, please e-mail me at: [email protected]

Welcome!

SAS-X.com offers news and tutorials about the various SAS® software packages, contributed by bloggers. You are welcome to subscribe to e-mail updates, or add your SAS-blog to the site.

SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration.