One week after the Health User Group and I’m FINALLY able to pass on some great stories from the meeting! Boy oh boy, this backlog of blog posts has bothered me beyond belief. I’ll be very pleased when I’ve caught up completely after this entry… I wa…
To INDEX or not to INDEX…
Recently, a certification candidate asked me about indexes and how SAS decides whether to use one or not. I don’t work with supper-large data sets and therefore haven’t been overly concerned with efficient coding techniques and consequen…
Calculating the UTC offset in your SAS session
Update 25Nov2010: I’ve updated this example to correct the code so that it works correctly for positive UTC offsets. Thanks to Bruno Müller, my colleague at SAS, for finding my mistakes.
One of my SAS colleagues was recently working on a p…
Booooom!!! proc explode!!!
I came across an interesting procedure today.. Its called as proc explode!This procedure enables the user to blow up the text in nice formatting and display it on the output screen (I think only in listing).This reminds me of the ‘banner’ command in th…
Password encryption
Many a times we come across a situation where we may need to encrypt the password which we use in the SAS programs (Example: Using a password to access a database like db2). This can be acheived by the pwencode procedure. See the example below:filename…
Define delimiter in PROC IMPORT
DSD DLM=”|” TRUNCOVER LRECL=4096 proc import datafile=”…” dbms=dlm out=… replace;      delimiter=’|’;      getnames=yes;run;