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

http://www.decisionstats.com/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

Disadvantages-

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.

Communication

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

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

Networking

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

Portals

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

Websites
www.feedburner.com

Site to create RSS feed for your site/blog
http://technorati.com/

Site to publicize your and read other blogs
www.google.com/adsense

Adsense is the leading site for putting online ads on your website to earn money
www.google.com/analytics/

Google Analytics helps you track traffic to your website with a great and free interface
www.digg.com

Site to help you surf the net, or popularize a web article by sharing with rest of the world
http://www.stumbleupon.com/

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 –
http://academic.brooklyn.cuny.edu/economic/friedman/Regressnxce.html

Optimization-
http://office.microsoft.com/en-us/help/HA011245951033.aspx

Free Tutorials from SAS

http://www.sas.com/apps/elearning/elearning_courses.jsp?cat=Free+Tutoria…

SAS certification

http://support.sas.com/certify/

SPSS tutorials

http://calcnet.mth.cmich.edu/org/spss/toc.htm

http://www.ats.ucla.edu/STAT/spss/webbooks/reg/default.htm

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

A Simple SAS Code to Automate Reports

Organizations use an increasing amount of reports. Countless hours are spent manipulating spreadsheets one after another, into and out of MS Access databases and finally emailing it to a select audience of people.

The following  tries to present a simple and integrated approach to report generation and presentation. This involves the use of Macros, for repeatability and flexibility.You can copy and paste the code directly to your SAS editor and make relevant changes.

Steps in preparing a report

  • Import data from data sources (spreadsheets, databases mostly .Here assuming BASE SAS ,only csv files are considered)
  • Manipulating data for analysis (in the case below the only data manipulation done is removal of duplicates. This section can be changed as needed by user for
    • Frequency counts using Proc Freq.
    • Mean, maximum and minimum counts using Proc Means.
    • Customized reports using Proc Report Procedure.)
  • Presenting and formatting data
  • Output data in the form of a report /spreadsheet.
  • Emailing internal customers of the report.

———————————————————————————————————

Using BASE SAS, the following can be coded as:

     /*PROGRAM TO AUTOMATE REPORTING */

    /*DECLARING THE PATH OF THE INPUT/OUTPUT FOLDER */

%let pathfile = ‘X:\Auto\AUG06-AUTOS\’ ;

     /*CREATING LIBRARY NAME */

libname auto &pathfile;

run;

   /*TO CONSERVE SPACE*/

options compress=yes;

   /*TO MAKE LOG READABLE */

options macrogen symbolgen;

/* STARTING MACRO FOR REPEATABLE EXECUTION OF REPORT*/

%macro impmth(mth,num,emailid);

 /*MANIPULATING VARIABLES TO REDUCE CHANGES */

data _null_ ;

call symput(‘filepath’,”‘”||&pathfile||&mth||’.csv’||”‘” );

call symput(‘unqpath’,”‘”||&pathfile||”unq”||&mth||’.csv’||”‘” );

call symput(‘unqxls’,”‘”||&pathfile||”unq”||&mth||’.xls’||”‘” );

run;

/*IMPORT*/

/*IMPORTING DATA FROM CSV FILES STORED IN FOLDER DECLARED ABOVE*/

PROC IMPORT OUT= auto.&num

DATAFILE= &filepath

DBMS=CSV REPLACE;

GETNAMES=YES;

DATAROW=2;

quit;

/*CREATING VARIABLE FOR DISTINGUISHING INPUT*/

data auto.#

set auto.#

&num =1;

run;

———————————————————————–

/*DATA MANIPULATION HERE REMOVING DUPLICATES*/

proc sort data=auto.&num nodupkey;

by REFAGREEMENTID;

run;

———————————————————————–

/*EXPORT*/

/*EXPORTING DATA TO A CSV FILE*/

PROC EXPORT DATA= AUTO.&num

OUTFILE= &unqpath

DBMS=CSV REPLACE;

RUN;

/*EXPORTING DATA TO A XLS FILE*/

ODS HTML FILE=&unqxls;

proc print data=auto.#

run;

ODS HTML CLOSE;

/*EMAILING THE RESULTS*/

filename outbox email &emailid;

data _null_ ;

file outbox

to=(&emailid)/* Overrides value in filename statement */

cc=(&emailid)

subject=’File from’

attach=(&unqxls)

;

put ‘Hi,’;

put ‘This is an integrated approach to automating reports’;

put ‘It works great!’;

run;

%mend;

/*CALLING THE MACRO*/

/*HERE ‘Ahmedabad’ IS THE INPUT FILE WHILE Ahd IS THE OUTPUT FILE*/

/*HERE ‘aohri@hotmail.com’ IS THE EMAIL ID TO BE MAILED THE REPORT*/

%impmth(‘Ahmedabad’,Ahd,’aohri@hotmail.com’);

Note- This was written on version 8 of SAS, so let me know any issues.

Ajay