Comparing Base SAS and SPSS

Comparing Base SAS and SPSS is an age old question between analytics professionals as both of these are one of the longest running statistical softwares in the world.

While Base SAS is on version 9 + and has greatly improved it’s visual appeal to counter SPSS’s click and get results interface, SPSS has moved beyond version 15.0 + and started adding modules like SAS has done.

Here I will be comparing specific SAS and SPSS components like SAS ETS with SPSS Trends, and SAS Base /Stat with SPSS Base.

Base SAS is almost 1.75 times as expensive in upfront cost for a single installation than SPSS.

SAS ETS is better than SPSS Trends for time series analysis for bad data, but SPSS Trends can easily make huge numbers of time series analysis than SAS ETS.

SAS is more tougher to learn than the point and click interface of SPSS.

SPSS Documentation is much better and give better clarity on algorithms used for statistical procedures.

Base SAS is much more powerful for crunching huge numbers of data (like sorting or splicing data),

for data that is smaller than say 100 mb, the difference is not much between SAS and SPSS.

SPSS is a perpetual license, while SAS has year on year license. This eventually makes it 2-3 times more expensive.

Modeling is easier done in SPSS but SAS can provide more control thanks to command line interface/advanced editor coding.The SAS Enterprise is not as good a visual interface as the SPSS.

For a startup analytics body, the best installation for both SAS and SPSS is network licenses preferably over a Linux network. You should ideally have a mix of both SAS and SPSS to optimize both costs and analytical flexibility.

Other Comparisons with Base SAS (a SAS Institute Copyrighted Product ) can be found at http://www.ats.ucla.edu/stat/technicalreports/

or by searching packages at http://finzi.psych.upenn.edu/search.html


A new free way for Company Analysis

Interactive Data:
Putting Technology to Work for American Investors

What is Interactive Data? (From SEC site)

Put simply, interactive data means using technology to provide investors with quicker access to the information they want, in a format they can most easily use. Today, publishers of financial information offer a wealth of data about stocks, bonds and mutual funds. Unfortunately, investors seeking financial information direct from the source must often attempt to read lengthy corporate annual reports or mutual fund prospectuses. Even if these documents are online, they are often digital blobs with limited search capability.xbrlinfy.PNG

From Zdnet story

The Financial Explorer site uses interactive charts and diagrams, including
“atomic models,” to represent data such as current assets, long-term
investments, and goodwill.

The SEC’s new Financial Explorer site is a tool that enables users to
manipulate raw data derived from XBRL, or extensible business reporting
language.

Users can also compare earnings, expenses, cash flows, assets, and
liabilities for companies in the same industry.

“XBRL is fast becoming the universal language for the exchange of business
information and it is the future of financial reporting,” said SEC Chairman
Christopher Cox
in a statement. “With Financial Explorer or another XBRL
viewer, investors will be able to quickly make sense of financial
statements.”

And after all that knowledge , here is a cool site to analyze companies.

Viva La Americanos

From a NY Times story on a rock that was in the middle of riven on border of states of Kentucky  and Ohio

Now, because of one man’s obsessive good intention, the fabled rock sits on old tires in the municipal garage of this river city, awaiting the outcome of a border dispute that goes something like this:

Some Ohioans say the rock is an important piece of Portsmouth history and should be put on display. Some Kentuckians say the rock is an important piece of Kentucky, period, and should be returned. And some in both states say: I’ve been distracted by war, recession and a presidential campaign, so forgive me. But are we fighting over a rock?

Last month the Kentucky House of Representatives passed a resolution demanding the rock’s return to its watery bed, with one of its members suggesting that a raiding party to Portsmouth might be in order. Not to be outdone, the Ohio House of Representatives is considering a resolution that asserts the rock’s significance to Ohio, and its speaker has said he is ready to guard the boulder with his muzzle-loading shotgun.

Ah , the passion . Viva La Americans.

The CEO

Once there was a CEO.

Pretty good chap, but couldnt bear to hear NO.

Liked to work quite hard and nice

Had office affairs many, His only VICE

Treated his team to lavish offsites,

Where he could sleep with office wives

Then got caught with his pants down.

Yesterday’s genius became today’s clown.

Fired by the Board, the CEO thought again,

started up a company ,with a new brand name,

Couldnt really help it,

He was addicted to playing the game.

O CEO, close yet so far.

Listen to our advice ,O Noble Czar.

Quit fooling around and be decent again.

Lest your ventures go again in vain.

Rules of RIO Carnival

Samba group Beija Flor was declared Brazil’s carnival champion for the fifth time in six years, wowing judges with gold-encrusted, winged dancers and green jungle display floats.

art.rio.jpg

Beija Flor’s lavishly decorated float scooped the top prize at the Rio carnival.

While Beija Flor’s dancers were topless, the judges drew the line at going bottomless, penalizing the rival Sao Clemente group for breaking a rule against display of genitalia during its 80-minute parade.

 

 

They didn’t name the offender, but she was widely believed to be samba queen Viviane Castro, who danced wearing only a 1.6-inch patch, believed to be the smallest in Rio parade history.

Ps. CNN now has a sub section called funny news .http://edition.cnn.com/funnynews/ This report wasnt taken from it, but from www.cnn.com itself.

10 SAS Procs:Learning SAS Easily

when-i-was-beginning-in-analytics-and-learning-sas.doc

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