SAS procedure SUMMARY is a quick method of converting your detail table to a fully summarized one.
Included is a sample. The key option to set is the NWAY – this generates the lowest level of summary for use in the OLAP cube.
Essentially – the class s…
In the computer software industry, 35 years is like an eon.
I mean, 35 years ago, the computing power that I carry around within my mobile phone didn’t even exist all in one place; but if it did, it would have filled an entire building.
That’s w…
SAS procedure SUMMARY is a quick method of converting your detail table to a fully summarized one. Included is a sample. The key option to set is the NWAY – this generates the lowest level of summary for use in the OLAP cube. Essentially – the class st…
I have trouble waking up early everyday. And the days when i forget to set alarm in my mobile, I might wake up two days later!!I’ve overcome this problem after i discovered this the sound function in SAS. This function produces a beep sound for the spe…
look to the master, follow the master, walk with the master, see through the master, become the master.
The SAS Global Forum 2011 (Apr 4-7, Las Vegas) papers are now available on line:
http://support.sas.com/resources/papers/proceedings11/TOC.html
There […]
I know it was high time I did it… Hope this is more viewable…Watch out for more posts in this space…
Array is probably the only number-indexed data type in SAS. SAS programmers adopt it mainly for multiple-variable batch-processing. For example, longitudinal summation can be achieved by specifying a one-dimensional array and then adding all array elem…
In the past couple months, this scenario has occurred twice. So thought I’d share a quick remedy ~ and save for my future reference when this occurs again :).
In Star Schemas, there are sometimes occasions where the data quality isn’t exactly perfec…