In Windows 10, when I was trying to generate an EOF for a Java program, the CTRL+Z did not work. After doing some research (and help from forum members), it was determined that there is a new option in the cmd prompt in Windows 10:Check that, relaunch …
Category: SAS
8 new summer reads for SAS users
Summer is here, which means vacations and time at the pool with a good book. If expanding your knowledge is a goal of yours this summer, SAS has a shelf full of new titles becoming available over the next few months. From new editions of classics – such as SAS® for Forecasting […]
The post 8 new summer reads for SAS users appeared first on SAS Learning Post.
How to perform an operation on all numeric or all character variables in a SAS data set
In a previous blog, I demonstrated a program and macro that could identify all numeric variables set to a specific value, such as 999. This blog discusses an immensely useful technique that allows you to perform an operation on all numeric or all chara…
Keeping your data set clean: Integrity constraints
When I teach my Data Cleaning course, the last topic I cover in the two-day course is SAS Integrity Constraints. I find that most of the students, who are usually quite advanced programmers, have never heard of Integrity Constraints (abbreviated ICs). I decided a short discussion on this topic would […]
The post Keeping your data set clean: Integrity constraints appeared first on SAS Learning Post.
Jedi SAS Tricks – FedSQL Dictionary Tables
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.