Sometimes I feel curious about how running a simple VBA macro in Excel could beat my 8-core desktop to indefinite waiting time with 100% CPU usage. On those occasions, I wish SAS could be a rescue, since I am more familiar and confident with SAS. The g…
Credit default swap pricing by Proc FCMP
Sometimes I feel curious about how running a simple VBA macro in Excel could beat my 8-core desktop to indefinite waiting time with 100% CPU usage. On those occasions, I wish SAS could be a rescue, since I am more familiar and confident with SAS. The g…
What SAS administrators should know about libraries, metadata, and SAS Enterprise Guide
We sometimes take it for granted, but the concept of the “SAS library” is just about one of the most awesome aspects of The SAS System.
You can give your library a name (a library reference, or libref), tell the system how to get to your data (…
Is something missing or is it a ZERO?
As far as numbers go, the number zero is rather mysterious for data. Is it something or is it nothing? What happens when you have missing data but enter 0? This topic triggered an intriguing discussion in my recent Programming 2: Data Manipulation Tech…
What SAS administrators should know about libraries, metadata, and SAS Enterprise Guide
We sometimes take it for granted, but the concept of the “SAS library” is just about one of the most awesome aspects of The SAS System. You can give your library a name (a library reference, or libref), tell the system how to get to your data (options …
Numerical variables profiling in very large data set
Profiling numerical variables is an integral part of data analytics, which generally consists of obtaining standard descriptive statistics such as quantiles, first central moments as well as missing ratio.
It is easily obtainable by using PROC MEANS…