10 SAS Procs:Learning SAS Easily


When I was beginning in analytics and learning SAS, one of my team members pulled me aside and said man-just learn 10 types of procs and you have learnt it.You can download actual cut and paste code from the link above. 

 Proc Freq  ,Proc Datasets  

Proc Means, Proc Print

  Proc Contents, Proc Univariate

Proc Summary   ,Proc Sort

  Additional – Merging data pulled from multiple locations

Sort all datasets by the key (here var1) before merging  


Proc Rank Proc Tabulate  

 p.s It proved to be more complex but learning different  kinds of procs is  an easy way for a SAS beginner to  learn SAS faster and clear SAS skills interviews

The Ultimate Rejection Letter

Herbert A. Millington Chair -
Search Committee
412A Clarkson Hall,
Whitson University College Hill,
 MA  34109
  Dear Professor Millington,  Thank you for your letter of March 16.
After careful consideration,
 I regret to inform you that I am unable to accept your refusal
to offer me an assistant professor position in your department.
  This year I have been particularly fortunate in receiving an
unusually large number of rejection letters.  With such a varied
and promising field of candidates, it is impossible for me to
accept all refusals.   Despite Whitson's outstanding qualifications
 and previous experience in rejecting applicants, I find that your
rejection does not meet my needs at this time.
 Therefore, I will assume the position of assistant professor
in your department this August.
I look forward to seeing you then.
Best of luck in rejecting future applicants.
Sincerely, Chris L. Jensen

Microsoft Office Live

Thought for today: The World’s biggest Online compmay www.google.com is actually a one page frontend …

1) http://Officelive.com

It is a good and inexpensive starting point for online entrepreneurship.

 It helps you create websites, company branded email and without going to any other site, writing code or spending any money.

It helps give you basic level of familiarity of website making with both pure online businesses and online-offline businesses.

Here is an interesting book from Office Live, Microsoft’s initiative in the SME market. http://officeliveoffers.com/11steps/default.htm?cid=D74E0D06-3732-4DA3-8D0C-8E7E4A5879D1

Content Management Systems (CMS)

The two main content management systems are Drupalhttp://www.decisionstats.com/drupal/

and Joomla


These are two pages as test examples for the two different CMS’s.

Advantages of them are –

Easier to manage a lot of content


Difficult to configure as compared to wordpress

Less Attractive Themes or Plugins.

I preferred drupal precisely because it gives some added flexibilty in themes and editing content.

Web 2.0 sites

This is a list of Web 2.0 sites that add to your online experience , whether personally or professionally. This will be followed by a detailed note on each site, but as of now this is a list of most of the Web 2.0 that you would need.


www.Skype.com Chat using VOIP from your computer
www.counterpath.com/xlitedownload.html Chat using VOIP from your computer
www.Fring.com Chat using VOIP from your mobile
www.nimbuzz.com Chat using VOIP from your mobile

Content Creation

www.Drupal.org Create content management system
www.Wordpress.org Create blogs or sites
http://collectivex.com/ Create group sites

http://www.flickr.com/ Share Photos by yahoo
http://picasa.google.com/ Share Photos by google


www.Linkedin.com Professional Networking
www.Twitter.com Status updates to “What are you doing”
www.Facebook.com Personal Networking , Fastest growing social site.
www.plaxo.com Organize most of your your online addressbooks and activitiesby integrating most Web 2.0 sites.
www.shelfari.com Share your favourite books


http://my.yahoo.com Customized home page for Yahoo users -recently revamped
http://www.google.co.in/ig?hl=en Customized home page for Google users


Site to create RSS feed for your site/blog

Site to publicize your and read other blogs

Adsense is the leading site for putting online ads on your website to earn money

Google Analytics helps you track traffic to your website with a great and free interface

Site to help you surf the net, or popularize a web article by sharing with rest of the world

Site to help you surf the net, or popularize a web article by sharing with rest of the world

Analytics Training Websites

This post deals with books , certifications and tutorial for data miners and analysts from beginners to intermediate level.Excel Modeling

Regression –


Free Tutorials from SAS


SAS certification


SPSS tutorials



Using Batch Files to Automate

Batch files may be old fashioned but can save you a lot of time in repeated tasks.Here is an example of a batch file that has

1) Some Global variables (Inputs)

set SALES_GRP=s1
set ID=f2
set SALES_DATE=nov0107

#BATCH FILE COMMENT using hash order_date format is monddyy

2) Used notepad to open a file for making changes

call c:\software\Notepad.exe C:\folder1\input1.sas
call c:\software\Notepad.exe C:\folder2\input2.sas

3)Created a directory to store results

call mkdir C:\folder2\%SALES_GRP%\%ID%\%SALES_DATE%

4) Executed another batch file or code using relevant software (eg SAS.exe for SAS Code)

call C:\software\sas8.exe C:\folder1\input1.sas

call C:\software\sas8.exe C:\folder2\input2.sas

5) Changes active folder

call cd C:\folder1

This can particularly help you schedule SAS code running at specific times using Windows Scheduler