I’m almost done moving this site from Google Sites to WordPress. This post describes some of the some things I’ve learned about WordPress.com. By default, WordPress.com makes your site look like a blog. I preferred it look like a web … Continue reading →
Blogging is Awesome: CDISC Bloggers
I remember when blogging was cool. Before the specializing and monetizing and Twitter-izing. —Peter Dewolf Well I think blogging is still cool (and awesome and awesome …). The most appealing personal reason is, blog posts are Google searchable and suitable for archive while Tweets NOT. Admittedly I hold some sort of Existentialism 2.0: if […]
Stored Processes: 3 Ways to Edit a Stored Process
Some may not realize that you can edit a SAS Stored Process in multiple ways (depending on your permissions). Today I show you three different ways to reach the stored process code. By the way, I’m using SAS Enterprise Guide 4.3 and SAS Management Console 9.3 – so your windows may look different. Method 1: SAS Enterprise Guide Many of you are aware of this method already. Just for review – here’s how you open a stored process and then change it with SAS Enterprise Guide. You have to be connected to the metadata server to reach the stored process. From the SAS Folders pane, select the SAS Folders icon. Navigate to the stored process location. Right-click the stored process and select Add to Project. The stored process appears in the Process Flow and Project Tree areas. From the Process Tree or the Project Flow area, right-click the stored process name and select Modify <stored process name>. The Stored Process Manager window appears and you can make changes to your code. I use this method most often because I like the help I get from SAS Enterprise Guide. Method 2: SAS Management Console If you have access to the […]
Top 10 tips and tricks about PROC SQL
Interestingly, I just found that the most searched keyword is PROC SQL, through the traffic analysis of my tiny blog. The reason possibly is: nowadays everybody knows SQL, more or less; then someone can do some parts of the SAS job by PROC SQL wit…
Jedi SAS Tricks – Roll Your Own Function
A SAS user (who lives in the the US) emailed me a question about SAS functions. He was read UTC (Coordinated Universal Time) datetime values from server logs, and to make future calculations and comparisons easier, he wanted to transform the value to …
ESTIMATE Statements – the final installment
FINALLY…the simplest ESTIMATE statements to write are for continuous variables not involved in interactions or higher order terms. Consider a data set containing the 2004 SAT scores for each of the 50 states. The file includes the combined math and v…