Jedi SAS Tricks – FedSQL Dictionary Tables

June 23, 2017
By

Dictionary tables are one of the things I love most about SQL! What a useful thing it is to be able to programmatically determine what your data looks like so you can write self-modifying and data-driven programs. While PROC SQL has a great set of dict...
Read more »

A map of country code top-level domains (ccTLD)

June 22, 2017
By

Here in the US, we typically use top level domains such as .com, .gov, and .org. I guess we were one of the first countries to start using web domains in a big way, and therefore we kind of got squatter's rights. As other...
Read more »

Import password protected EXCEL into SAS

June 21, 2017
By

Click Here%macro readpass(xlsfile1,xlsfile2,passwd,outfile,sheetname,getnames);options macrogen symbolgen mprint nocaps; options noxwait noxsync;%* we start excel here using this routine here *;filename cmds dde 'excel|system';data _null_; length fi...
Read more »

The jackknife method to estimate standard errors in SAS

June 21, 2017
By
The jackknife method to estimate standard errors in SAS

One way to assess the precision of a statistic (a point estimate) is to compute the standard error, which is the standard deviation of the statistic's sampling distribution. A relatively large standard error indicates that the point estimate should be viewed with skepticism, either...
Read more »

Tabs -vs- Spaces: Which coders make more money?

June 20, 2017
By

There have been several polarizing topics throughout history, such as religion & political affiliation. And for software developers there's one more biggie ... tabs -vs- spaces! Which group is right? Perhaps the opinion of the better programmers should have more weight(?) Is there a metric...
Read more »

Data Science Tool Market Share Leading Indicator: Scholarly Articles

June 19, 2017
By
Data Science Tool Market Share Leading Indicator: Scholarly Articles

Below is the latest update to The Popularity of Data Science Software. It contains an analysis of the tools used in the most recent complete year of scholarly articles. The section is also integrated into the main paper itself. New … Continue reading...
Read more »

Creating a Web Analytics Report in SAS Visual Analytics 8.1

June 19, 2017
By

Recently I was asked to create a Web Analytics dashboard on spec. I decided to use the latest version SAS Visual Analytics 8.1 so I could review the new features. When we wrote the Introduction to SAS Visual Analytics book, we were using beta...
Read more »

How to find a feasible point for a constrained optimization in SAS

June 19, 2017
By
How to find a feasible point for a constrained optimization in SAS

Most numerical optimization routines require that the user provide an initial guess for the solution. I have previously described a method for choosing an initial guess for an optimization, which works well for low-dimensional optimization problems. Recently a SAS programmer asked how to find...
Read more »

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.

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
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.