Use SAS Enterprise Guide to quickly understand a new data set
Social Network Analysis – SAS on the CrimeWatch
Check out my post on AllAnalytis.Com about how SAS is using analytics to fight fraudsters. Looks out crooks! Plus there was an e-chat yesterday with Angela and Dennis Toomey. [Hint: Read from the bottom.] Lots of cool information about the techno…
Stop recreating the wheel, save those common joins into a permanent view
When you are constantly taking the data tables and completing joins to begin working on your reports or analysis it might be time to consider creating permanent views. Then you can just add the view to the Enterprise Guide project rather than dealing w…
New SAS BI Book: a good read for Platform Administrators too
I’ve just added a link to the new Building Business Intelligence Using SAS: Content Development Examples book by Tricia Aanderud and Angela Hall to my reading list of information resources I find useful for SAS® platform administration. Thei…
Make a frequency function in SAS/IML
Aggregation is probably the most popular operation in the data world. R comes with a handy table() function. Usually in SAS, the FREQ procedure would deal with this job. It will be great if SAS/IML has an equivalent function. I just created a user-def…
How many observations were processed by that last step?
A well-formed WHERE statement or subsetting IF can narrow down the output of your SAS DATA step. The SAS log does a good job of telling you how many records were processed by the action. For example, let’s look at this simple DATA step with my “poor man’s random sample”, […]