8月 032009
 
The Call for Papers has been open over 2 weeks now, and the response is good. We’ve heard from SAS users from over 35 companies from all over the world. The first submission was from the UK, but we’ve also had submissions from Singapore, Canada, Italy, and of course the US. SAS Global Forum is truly international: last year over 24% of the attendees were from outside of the US. So far, most submissions have been for the Statistics and Data Analysis section, followed by Application Development. As a reminder, there are over a dozen technology solutions sections and seven industry solutions sections that you can submit a paper for. If you have questions about any of these sections, simply contact the appropriate conference leader. You can also suggest a topic idea to an author by visiting the sasCommunity.org "Share Your Ideas" page.

7月 292009
 
With SAS analytics; many of you are breaking ground as you strive to deliver more value from textual data. Data mining has matured into an accepted practice for Customer Relationship Management teams in Telco, Finance and Marketing. I'd go as far to say that its become essential to survival for most large companies across the globe. Text Mining, as you readers are well aware, is not yet as popular, with many employers assigning just one or two of you with responsibility for text mining.

It can be a burden to struggle alone in a silo without anyone to bounce ideas or brainstorm with. To make it easier for you to connect with peers who share a passion for these technologies – we set up a discussion forum on the topic of SAS Enterprise Miner and SAS Text Miner, two months ago. While SAS employees may participate on these discussions, this forum is not meant to replace the SAS Technical Support help center.


Another excellent way for you to get feedback on your work is to respond to the SGF Call for presentations 2010 (Seattle).

Honestly, one of my favorite things about SAS is
- :-) You - ,
our innovative customer implementing software on your real world challenges.

Only a few text related topics have surfaced in the discussion forum to date, so I’m writing this blog to encourage more of you to join in and set up your profile. Please accept my invitation to post questions, experiences, and thoughts on best practices.
7月 132009
 
I have 2 exciting things to blog about: the opening of the Call for Papers, and the new SAS Global Forum Web site.

First, the Call for Papers is now officially open through Monday, October 26. Call for papers sections are classified under two primary categories - Technology Solutions and Industry Solutions. Papers themselves fall into three categories: Contributed Papers, Invited Papers, and SAS Papers. Learn more about the specific conference sections within each category and the types of papers being solicited. How (and when) are papers selected? Conference leaders review and select papers, and they will notify authors by Monday, Dec. 14, 2009 as to whether or not a submission has been accepted. It’s a tried and true system that works. For more details, refer to How to Submit a Paper... and other relevant questions.

Second, we have a great new look for the SGF Web site. The Web site not only has the new conference colors, it also has a simplified navigation system. By using the tabs at the top of the Home page, you can quickly access other parts of the site such as “Overview,” and “For Presenters.” There’s also a “Quick Links” area that include direct access to the very popular Online Proceedings as well as info about previous and future conferences. Take a tour, and let me know what you think. Of course the tabs and site will continue to change as we add content and move closer towards the conference.

PS: Looking for an idea to write about? Want to suggest a topic idea to an author? Visit the sas.Community.org "Share Your Ideas" page.
7月 112009
 
Contributed by Kirsten Hamstra, SAS Publishing

Changes are happening at SAS Publishing with several new features being rolled out this month. The first and largest new feature focuses on our authors.

Currently, most SAS Publishing titles have a corresponding companion page that features additional information about the book, including author background, recent updates and sample code. Our authors are subject matter experts, and many have published several titles with us. The author pages bring the attention back to them and their expertise. The pages feature several different areas for customers to interact and learn about SAS Publishing authors including links to their titles, news, events, podcasts and social media links to their pages on Twitter, Facebook or other channels.

To learn more about your favorite author, visit: Author Pages on support.sas.com.

Another new feature that works together with author pages allows customers to be notified when a new book is available. The Coming Soon page lists all upcoming SAS Publishing titles, anticipated publication date and gives visitors the option to receive an email when the book is available for purchase.

Finally, the SAS Publishing Bookstore has added a new section called Conversations. As SAS Publishing continues to participate in several social media channels, we want to inform our customers how and where they can find us online. There are currently links to our pages on Facebook and Twitter with more to be added soon!
7月 112009
 
My colleague Mark Chaves, product manager for SAS Customer Intelligence responded to my earlier post “Why customer intelligence will fail without text mining,” with some strong opinions of his own. And remember – he’s a marketing guy, too! Read on:
I agree with Manya’s comments and wanted to add that advertising as a medium through which marketers communicate is evolving, not diminishing.

When I hear comments like “we don't need online advertising”… it makes me laugh. Professors like Eric Clemons have the luxury of living in an academic world and being provocative gives them a chance to get their names out there (as KD Paine will tell you, universities are also tracking “mentions” and “quotes” in order to get name recognition for their professors).

Without having read Eric’s comments in full context, I would only add that evaluation of advertising or any marketing tactics has to be made in the context of a firm’s strategic goals and objectives. This is typically represented by scorecards and “funnel” diagrams that describe the “path” that consumers take when making purchasing decisions.

In the funnel to the right, we see that online advertising may have a positive effect on improving “Brand/Product Awareness” (top of the funnel) and then we may also notice that online peer recommendations may have a measurable effect on web traffic or store traffic, and ultimately sales. Conversely, a peer may recommend a new product to another peer (thereby driving awareness) and a price promotion may actually compel the consumer to make the purchase.

Two examples:
1) I see a banner advertisement for a new Weber grill from Lowe’s (increased brand awareness) but I may call up my friend Dan (a BBQ nut) or check BBQ blogs to see how it is rated.

2) A blog or a tweet or a friend directly introduces me to the Flip Camcorder (increased awareness, consideration) but I may be compelled to purchase said camera if a Best Buy banner ad tells me there is a sales on Camcorders
Coming back to my comment about marketers beware, tying promotions to the right kind of consumer reviews could be extremely valuable. Text mining can analyze consumer reviews to help identify the appropriate comments and segment(s) to go after.
7月 102009
 
I'm doing my weekly round-up of text mining/unstructured data/information management news. Having lived in numerous continents around the world, I like to make sure my information hunting is equally intercontinental. Different cultures have different slants on topics.

This morning's search led me to an article posted by the New Zealand Herald entitled "How Can YouTube Survive?" A section of the article mentioned insider's technology blog, TechCrunch, and a guest blog post entitled "Why Advertising Is Failing On The Internet" written by Eric Clemons, Professor of Operations and Information Management at the University of Pennsylvania. A very interesting read, and also a very provocative one (validated by many comments to the blog post).

According to this excerpt from the NZ Herald article, Clemons "argued that the way that we're using the Internet has shattered the whole concept of advertising. We need no encouragement to share our opinions online regarding products and services and offer them star ratings; as a result, we're much more likely to look for personal recommendations from other customers than wait for a gaudy advert to beckon us wildly in the direction of a company website or online store. He claims we don't trust online advertising, we don't need online advertising, but above all we don't want online advertising."

Based on my personal Internet shopping habits, I agree! I'd much rather see personal testimony about a product in addition to (or instead of) marketing collateral. This personal testimony has becoming a new form of marketing. It would serve marketing professionals well to pay attention.

Understanding individuals' commentaries about products helps marketers better understand consumer reaction to the four P's of the marketing mix: product, price, placement and promotion.

This evolution of marketing influencers is exactly what makes text mining a pivotal technology for this generation. It provides the ability to gauge those huge volumes of Web-based consumer reactions in an automated, consistent manner. And then you can actually do something about it -- or with it!
7月 082009
 
SAS customers often ask me "How do you use SAS?" My use of SAS is very limited these days, but my co-workers do some amazing things every day. We at SAS use SAS software to accomplish all sorts of business tasks and some purely entertaining ones too. (I'm sure you've seen the blackjack and Sudoku programs at SAS Global Forum.) No matter what programs and tools we create using SAS software, we are encouraged to share our feedback with developers and testers.

I have decided to highlight some our uses for you. You will find them under the SAS Using SAS category at the right. My first interview was with Emily Wallace, Senior Director of the SAS Knowledge Management Center. I asked Emily if she could tell me what kinds of applications her organization writes using SAS software. The answer: "We use SAS for everything!" Lucky for this blog post, she offered some great details. She provided so much interesting information that I have struggled to find things to cut! The following is what I kept from our interview for this post.

Reports are delivered to internal portals
The Knowledge Management Center manages three internal reporting portals that provide information of varying details to different levels of management and staff. Each morning after the corporate warehouse data is refreshed, batch jobs run and construct all the reports in each portal. These programs run on a variety of platforms (Microsoft Windows desktop, Windows server, UNIX, Linux, and z/OS) and use tried-and-true SAS elements and procedures, such as DATA steps, PROC SQL, PROC GCHART, PROC SORT and others. The generated reports are used daily to manage and influence sales and business decisions.
Continue reading "SAS Using SAS for Reporting"
7月 032009
 

一个有意思的简单的SAS加密算法,希望对大家喜欢

data name;
    input name $ 1-25;
    string=collate(0,255); 
    high4=reverse(string);
    cards;
JOHN DOE
张 三
李 四
;
run;

data mono;
    set name;
    encrypt=translate(name,high4,string); /*加密*/
    decrypt=translate(encrypt,string,high4); /*解密*/
run;

proc print data=mono;
    var name encrypt decrypt;
run;

 Posted by at 11:45 上午
7月 032009
 

我们知道,如果在SAS里定义一个视图,而视图的源代码太多时,你通过describe语句把源代码输出到日志的时候
会发现输出信息会自动给你换行,这样导致你从日志里复制出来的源代码必须经过修改才能用

而下面这个代码就是解决这个问题,可以直接把SAS SQL视图的源代码直接输出到文件,输出的SQL语句可以直接复制出运行而不会给你乱换行


%let viewname=你的视图名字;
%let outfile=d:\1.sas;
options linesize=80;
filename out temp;
proc printto log=out new;
proc sql;
describe view &viewname;
quit;
proc printto;
run;
options linesize=max;
data _null_;
infile out truncover;

 Posted by at 11:41 上午
7月 032009
 

好久没有写blog了,都有点生疏了

下面这文章主要是讲如何利用java来调用本地SAS数据,这样你只需要买了SAS BASE就可以通过JAVA来访问SAS数据

欢迎大家随意转载



1.改动C:\WINDOWS\system32\drivers\etc\services文件,加入如下行:
odbcserv              5061/tcp 
(服务和端口号可以随意取)
2.在控制面板上建立ODBC
在选择驱动程序时选择[SAS]
ODBC数据源配置/服务器配置栏:服务器名称输入odbcservr,然后在单击配置按钮时请确认配置框提供的SAS.exe文件的正确性
ODBC数据源配置/逻辑库配置栏:输入你想要预先分配的库名和路径
3.使用[附录1-java代码]通过jdbcodbc访问
4.其他注意事项参考[附录2-注意事项]

附录1-java代码
import

 Posted by at 11:37 上午