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…
A map of country code top-level domains (ccTLD)
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 countries started using the we…
Import password protected EXCEL into SAS
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…
Tabs -vs- Spaces: Which coders make more money?
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 we can use to determine whether […]
The post Tabs -vs- Spaces: Which coders make more money? appeared first on SAS Learning Post.
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 →
Designing Dashboards: Finding the Fantastic Five Colors
Color may have the most impact on your design. People react strongly to color either through culture values or personal choices. As with fonts, color is another element of style. And just like fonts, colors communicate meaning as well. [Read: Understan…