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…
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”