Posts Tagged ‘ formats ’

Numbers great and small: the problem of Big Datum

March 1, 2012
By
Numbers great and small: the problem of Big Datum

About once a month, a customer approaches SAS and asks a question of significance. By "significance", I don't necessarily mean "of great importance", but instead I mean "of how SAS handles large numbers, or floating-point values with many significant digits". In response, we always first ask why they asked. This
Read more »

Tags: , , ,
Posted in SAS | Comments Off

Just-in-time data prep in SAS Enterprise Guide

November 30, 2011
By
Just-in-time data prep in SAS Enterprise Guide

On this blog, I've delivered a few tips about using SAS formats to stratify your data values "in place" without having to actually change your data. The most recent example addressed date and datetime variables. My previous examples included simple SAS programs that you can run in SAS display manager
Read more »

Tags: , , ,
Posted in SAS | Comments Off

SAS Info Map: Need leading zeros on the account number?

November 23, 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/09/Imap_006_format-Z.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 creating new variables, the SAS Information Map Studio opens the entire SAS format library to you.  These formats can be key to creating lots of new data items.  SAS format control the way data items appear.  In past articles I showed you how to create new data item using SAS functions and date...
Read more »

Tags: , ,
Posted in SAS | Comments Off

Do you mind if we dance with your DATEs (or DATETIMEs)?

November 15, 2011
By
Do you mind if we dance with your DATEs (or DATETIMEs)?

I've been working with date-time data on a recent project, and I've come across a few SAS programs that have "opportunity for improvement" when it comes time to create reports. (Or maybe I haven't, and I contrived this entire blog post so that I could reference one of my favorite
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

NOTE: Whither the WEEK Format?

November 30, 2010
By

My friend Eli recently wrote to tell me of a very successful 9.1 to 9.2 upgrade that was marred by just one issue. His colleague Sarah discovered that the WEEK format disappeared between 9.1 and 9.2. Sarah had been using the WEEK format to produce week...
Read more »

Tags: , ,
Posted in SAS | Comments Off

Calculating the UTC offset in your SAS session

November 24, 2010
By

Update 25Nov2010: I've updated this example to correct the code so that it works correctly for positive UTC offsets. Thanks to Bruno Müller, my colleague at SAS, for finding my mistakes. One of my SAS colleagues was recently working on a p...
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.