4月 232009
For a rather long time I have been talking of the convergence of text-related technologies such as search, text mining, text analytics, machine learning, voice analysis, video mining, enterprise content management (ECM), business intelligence (BI) and business analytics (BA) etc. The industry continues to change with the merger of three text analytics companies into one this week.

To me, this merger serves to validate SAS' direction in the unstructured space where our strategy is to take unstructured data right across the platform so organizations can have access to the full depth and breadth of SAS capabilities with a complete range of tools, products and solutions.

Some day users will not consider text to be any different from standard structured database fields. Analytic applications will automatically roll up text and other unstructured information.

IT departments and Business Reporting users no longer need be restricted to partial views on limited data. Data sources in the future can be gathered from Tweets, emails, dynamic web 2.0 sources and then integrated with the traditional IT data warehouses before they are cleansed and analyzed rigorously -- resulting in better decisions and greater impacts. SAS is ready to assist you in this exciting journey – and we applaud those who see the necessity of integration across the IT Storage, Analytics , reporting and line of business users.

4月 162009
1. Open the execution plan by the _method option.

proc sql _method;
select adsmsg.*
left join
on adsmsg.msgid=afmsg.msgid

2. Select any row number by monotonic() function in PROC SQL, since _n_ cannot be used in PROC SQL.

proc sql;
select monotonic() as rowno, *
from sashelp.cars
where monotonic() between 10 and 20

3. Check the resource for each statement in PROC SQL

proc sql;
reset stimer;

4. Created a serial of macro variables.

proc sql;
select name into :name01-name19 from sashelp.class;
4月 152009
The Proceedings from SUGI 24 forward are available on support.sas.com. You can browse the table of contents for the Proceedings or search the Proceedings collection by visiting the SAS Global Forum site at support.sas.com/events/sasglobalforum/previous/online.html.

However, you can search all of the papers that are available on support.sas.com, including the Proceedings, from one spot. Try this.

  1. Go to support.sas.com
  2. Type your term or phrase in the search entry field in the top right corner of the page.
  3. Select the down arrow for the drop list, then select Papers.
  4. Select the Search button or hit your Enter key.
The search results include appropriate entries from the Proceedings, all TS Docs, and all technical papers that are available on support.sas.com.

Note: You can also browse our technical papers by visiting support.sas.com/resources/papers and selecting a topic category.

What do you think; is the papers search a useful tool for locating information?
4月 102009
Elisa Priest, a doctoral student in epidemiology at the University of North Texas, was selected as one of nine SAS Student Ambassadors for 2009.

She also won the "Best Contributed Paper" in the Statistics Section.

Her presentation, Easier Exploratory Analysis for Epidemiology: A Grad Student How-To Paper, was very well received. She even made folks laugh several times during her talk!

Priest sited Art Carpenter's macro book in her presentation, and recommended it as a reference. She was thrilled to later have the opportunity to meet Art, and get a photo with Art and Ron Cody!

Originally from Brazil, Priest is a doctoral student in epidemiology, with a focus in chronic diseases and clinical trial design and processes, at the University of North Texas. She completed her bachelor’s degree in molecular and cell biology at Texas A&M University.

Eight years ago, Priest first used SAS while completing her master’s in community health at the University of Texas. She is most familiar with Base SAS® and SAS/STAT® software and is a SAS Certified Professional in SAS Base Programming. Priest has presented at several South Central SAS Users Group (SCSUG) conferences and epidemiology conferences.

She authored a book chapter on obesity and inflammation and has published several articles in epidemiology and chronic disease journals, including Contemporary Clinical Trials and Arteriosclerosis Thrombosis and Vascular Biology.
She plans to continue supporting clinical trials and teaching efficient clinical trials design and methods after graduation. During SAS Global Forum 2009, Priest learned many SAS tips and tricks that she’ll take back to her fellow students.
4月 022009
Maura Stokes works in the Statistical Applications Department in Advanced Analytics at SAS. Maura is also a member of the review board for support.sas.com. She works hard to provide you the information that you want as well as the statistical features that you need in our products. Let me introduce you to Maura.

What do you do:

I’m the development product manager for SAS/STAT® software, and I also coordinate some division-wide activities such as our documentation process.  Since SAS/STAT now includes 75 procedures and requires nearly 8,000 pages of documentation, obviously it takes several people to manage it. I keep current with statistical methodology being developed and adopted, obtain feedback from customers, and help to decide on priorities for future development. My role also includes outreach, and I give talks to both SAS user groups and statistical groups about our statistical software.  I also represent the analytical interests in SAS Global Forum planning and coordination, as well as support.sas.com, where I manage the Statistics and Operations Research focus area on support.sas.com.  I’m also the lead author of the SAS Press book Categorical Data Analysis Using the SAS System.

What’s the most interesting part of your job?

Learning new statistical methodology is still probably the most fun for me.  We occasionally bring in area experts for seminars to jump-start us in new areas, and that’s always invigorating.   

Continue reading "Meet Maura Stokes of the Advanced Analytics Department at SAS"
4月 022009
Once again, Alan Hoffler and Brendan Bailey trolled the halls of SAS Global Forum with a camera and microphone. They interviewed everyone from the SAS Student Scholarship Winner to John Sall, Jim Davis, Dr. Goodnight, and even yours truly.

You can view the videos on the SAS Global Forum blog at blogs.sas.com/sgf without having to visit YouTube. This feature gives those of you who cannot visit YouTube access to the videos. Have no fear YouTube fans, the videos are also available on the SAS YouTube channel.

Update: To view the videos without visiting YouTube, visit the SAS Global Forum blog and look for links that look like this:

Tip: If you are preparing for SAS Global Forum 2010, you may want to watch the video on Submitting a Paper to SAS Global Forum.
4月 022009
If you aren’t familiar with SAS-L, now’s a good time to take a look at it. It’s another information channel where SAS users go to ask and post answers. At SAS Global Forum 2009, SAS-Lers continued its tradition of honoring those who’ve contributed most significantly during the past year.

“There are many ways in the SAS community to ask questions and get help,” said Rhoads. “SAS-L is probably the oldest, but I think it continues to be a very valuable source of interaction and technical discussion. SAS-L: The original social network.

The presentation of SAS-L awards was held during the SAS Global Forum SAS-L BOF Monday, March 23. This year’s MVS (Most Valuable SAS-Ler) winner, data null, was the SAS Global Forum 2008 MVS winner. In accordance with SAS-L rules, data null’s 2009 award was upgraded to SAS-L Hall of Fame. The SASLROY (SAS-L Rookie of the Year) award went to Joe Matise.

For a complete description of the awards, please visit the SAS-L BOF Wiki page.

“We have an online nomination and voting process,” said Mike Rhoads, a SAS-Ler and member of the voluntary planning committee. “Anyone who has contributed to SAS-L throughout the year can go online and vote for the MSV and SAS-L Rookie of the Year. We’d like if they left also some comments in support of their nominee.”

According to Rhoads, he, Larry Hoyle and other SAS-L volunteers manage the voting process, host the SAS-L BOF and post the results online.

Although there are four categories for which a SAS-L member can be nominated, nominations were made to only two categories for SAS Global Forum 2009: MVS and SASLROY.

MVS nominees:
Robin High
Mary Howard
Daniel Nordlund
Michael Raithel
Arthur Tabachneck
Nat Wooding

SASLROY nominees:
Scott Bucher
Joe Matise
Akshaya Nathilvar
Ajay Ohri
Karma Tarap
4月 012009

That's a wrap! Alan Hoffler provides a takes a last look back at SAS Global Forum 2009. We hope to see you next year at SAS Global Forum 2010 in Seattle. Find out more at http://www.sas.com/sasglobalforum/2010.

Web Links: