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 […]
Uncategorized
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…
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…