Ever had the need to update table metadata by submitting SAS code? If so, you can use PROC METALIB to do so. This may be useful if you want to automate an ETL process, which loads tables and registers in metadata at the same time. Update Existing…
NOTE: Metadata-Bound Libraries in Action
Following my recent post about the excellent new metadata-bound libraries in V9.3 M2, I noticed Paul Homes publish a blog article with the results of his testing of this new capability. Paul shows some code samples and associated log output. Take a loo…
Getting SAS Software running on CrunchBang Linux 64-bit
This is a follow-up to my prior post on Getting SAS® Software running on Arch Linux 64-bit. In my quest for a new Linux distro the next stop was CrunchBang Linux. I like the look of CrunchBang because it’s lightweight, based on Debian, and u…
NOTE: Present Thinking
Christmas approaches, I’ve opened 18 windows in the SAS Professionals advent calendar (without winning anything, yet), written most of my Christmas cards, and my mind is firmly focused on the remaining Christmas shopping. However, I’ve allowed my min…
Using SAS to access data stored on Dropbox
I used “Dropbox” in the title for this post, but these techniques can be used for other cloud-based file sharing services, such as GitHub and Google Drive. Using PROC HTTP, you can easily access any “cloud-based” file as long as you have a public link to reach it. I’m a […]
SAS Stored Process: Debugging from the URL
Here’s an excerpt from “The 50 Keys to Learning SAS Stored Processes” book, which is 20% off until Dec 31. When Bad Things Happen to Good Stored Processes When the stored process fails, a standard error message appears with a button…