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


data name;
    input name $ 1-25;
张 三
李 四

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

proc print data=mono;
    var name encrypt decrypt;

 Posted by at 11:45 上午
7月 032009


而下面这个代码就是解决这个问题,可以直接把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;
proc printto;
options linesize=max;
data _null_;
infile out truncover;

 Posted by at 11:41 上午
7月 032009


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


odbcserv              5061/tcp 


 Posted by at 11:37 上午