DATA STEP text file tricks

June 8, 2015
By

When reading a text file (common extensions: TXT, DAT; or, for the adventurous: HTML) with the DATA STEP, you should always view several lines from the text file, and compare to the record layout, before completing the INPUT statement.  There are many ways to view a text file.  I use

The post Read more »

Sending Email from within SAS and other options…

June 8, 2015
By
Sending Email from within SAS and other options…

Sending Email from within SAS and other options...

FILENAME Statement EMAIL (SMTP) Access Method allows you to send electronic mail programmatically from SAS using the SMTP (Simple Mail Transfer Protocol) e-mail interface available at your site.

But before you process the email code below check the values for the system options using Proc options for EMAILAUTHPROTOCOL,...
Read more »

9.4, What’s New – Becoming Newer Month-by-Month

June 8, 2015
By

If you're attending SAS Forum UK in London this week (or Manchester later this month), you might not be expecting to use it as a means to find out what's new in V9.4, after all V9.4 was released in summer 2013, so we can't really call it "new" any...
Read more »

Fit a circle to data

June 8, 2015
By
Fit a circle to data

I still remember the first time I was asked to "consult" on a statistical problem. A former physics professor had some students who had gathered data that should lie along an arc of a theoretical circle. The professor asked if there was a regression technique that could find the center

The post Read more »

What’s the most popular surname in your country?

June 5, 2015
By

My previous blog was about popular first names ... now for a blog about popular surnames (ie, last/family names)! But before we get started, here's a little pop-quiz - what country is my friend Mr. Foley's surname from? I recently saw the following interesting map on dadaviz.com. It shows the most

The post Read more »

Weird PROC FREQ trick

June 4, 2015
By

Default PROC FREQ output looks like this: Suppose you don't want the two cumulative statistic columns above.  No problem.  Those can be suppressed with the NOCUM option on the TABLE statement, like this: proc freq data=sashelp.shoes; table product / nocum; run; Now your output looks like this, but you lose

The post Read more »

saslib: a simple Python tool to lookup SAS metadata

June 3, 2015
By

saslib is an HTML report generator to lookup the metadata (or the head information) like PROC CONTENTS in SAS.
  • It reads the sas7bdat files directly and quickly, and does not need SAS installed.
  • Emulate PROC CONTENTS by jQuery and DataTables.
  • Extract the meta data from all SAS7bdat files under the specified directory.
  • Support IE(>=10), firefox, chrome and any other...
    Read more »

What’s the most popular baby name in your state?

June 3, 2015
By

A couple of years ago, I blogged about the most popular baby names in the US over the past 100 years. This time, I focus on the most recent year, and take it to the state level! But before we get started, here's a picture of my friend Jennifer's daughter,

The post Read more »

The mystery of the density curve that was too short

June 3, 2015
By
The mystery of the density curve that was too short

I was reading a statistics book when I encountered a histogram that caught my eye. The histogram looked similar to the one at the left. It contained a normal density estimate overlaid on a histogram, but the height of the density curve seemed too short when compared to the heights

The post Read more »

Proc-x is looking for sponsors!

Dear readers, proc-x is looking for sponsors who would be willing to support the site in exchange for banner ads in the right sidebar of the site. If you are interested, please e-mail me at: tal.galili@gmail.com

Welcome!

SAS-X.com offers news and tutorials about the various SAS® software packages, contributed by bloggers. You are welcome to subscribe to e-mail updates, or add your SAS-blog to the site.

SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration.