I’m responsible for a SAS program that runs nightly in batch on a Linux server here at SAS. I am also a road warrior, and routine status checking via a remote connection is often tricky, and sometimes impossible due to unstable hotel internet connec…
Category: SAS
How to read next record while working on the current record (Opposite to LAG function);
Even though no function is available in SAS to do exactly the opposite work (ex: read the next record while working on the current one) of the LAG function, there are few things you can do to do exactly that.
Here are few simple techniques which ar…
Documenting Information Maps
If you have ever wanted to pull a quick document out showing what is contained in a Information Map, then this post by Chris from last year will show you how. It refers to the following tech support note Sample 39539: Creating a PDF that documents the contents of a SAS® Information Map. Chris’s post also includes […]
SAS Macro to put SAS data into Multiple Excel Work sheets
I believe most of us have encountered this situation…
I have a sas dataset with more than 70k records…How can I provide this information in an Excel file to the business user….
If one is using previous versions of MS Excel ie. < Excel 2007 th…
JDBC Connection Strings
Different JDBC drivers requires different connection URL formats. A quick summary of various connection URL formats is provided here as a comparison and a reference: Driver Name: Apache Derby Network Client JDBC Driver Driver JAR File: derbyclient.jar Connection URL Formats: jdbc:derby://host/database Connection URL Examples: jdbc:derby://localhost/TestDB Driver Name: JDBC-ODBC Bridge Driver JAR File: None (included in […]
Self-matching and its applications
Programming is all about data structure and algorithm. For example, value comparison needs to find right data structure and iteration method. To fulfill this purpose, the first thing is to load the variable with a key-value like data structure, follow…
Rock stars
“They are a group of SAS rock stars and I’m darn proud of them!”
Continue reading “Rock stars”
New Goodies for SAS Programmers: View it now
Millions of Americans will be gathering around the television this Sunday to watch Super Bowl XLV. They’ll gather in bars and private homes, prepare billions of calories worth of snacks, and root for their favorite teams.
But if you’re looking f…