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…
Category: SAS
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”, […]
Get SAS certified at SAS Global Forum 2012
SAS Global Forum 2012 is fast approaching and attendees want to make sure they make the most of their time away from their job. In addition to the opportunity to network with thousands of SAS professionals, attend hands-on workshops and demonstrations …
Why code when %_eg_WhereParam does the work for you?
After unwittingly getting involved recently in a code vs GUI discussion another pro GUI vote came in yesterday when presenting to a customer’s internal user group. When creating and using prompts in SAS Enterprise Guide, it is a no-brainer to recommend…
SAS Global Forum 2012: Will I See You There?
Check out the results of my SAS Enterprise Guide code – 41 days til SAS Global Forum 2012 in Orlando, Florida! I’m excited – I can’t wait to meet some of my Web friends face-to-face finally! Oh and also catch up with some of my old buddies! Why Should I Attend SAS Global Forum? Here’s the reasons I like to attend: Like Minded PeopleWorking in smaller organizations, I was sometimes was one of a handful of data geeks running loose in the halls. It’s great to meet 3,000+ others who actually know what “code or let SAS EG do it?” means. The SAS users are one of the things that make this a great product to use. There are several meetups planned (think it use to be called Birds of a Feather) – I want to check out the joint SAS-L, SASCommunity, and SAS Discussion meetup. Plus after you arrive there are others – for instance, new SAS users, SAS BI users, etc. Oh and the .. Kick Back Party … you know you want to show off all your groovy dance moves! Don’t worry I’ll have my camera! Exchange of IdeasEach time I attend – I come away with […]
Resume Motivation
The other day I blogged about my new SAS-Resources site and some of my motivations for creating it. But I left one motivation out of that introductory post. Not because it is less important, actually it’s one of the most important. So important that…