The SAS Dummy
A SAS® blog for the rest of us
JSON is a popular format for data exchange between APIs and some modern databases. It's also used as a way to archive audit logs in many systems. Because JSON can represent hierarchical relationships of data fields, many people consider it to be superior to the CSV format -- although it's
I've collected accelerometer data with a third-party app. I've used some SAS tricks to import all of my data readings in a single step. Now I'm ready to create a report of these data in SAS Visual Analytics.
The SAS INFILE statement can read multiple text files in a single DATA step. Use file name wildcards (like * and ?) and a special FILENAME= option to keep track of which records come from which files.
To succeed in any data-focused hackathon, you need a robust set of tools and skills – as well as a can-do attitude. Here's what you can expect from any hackathon: Messy data. It might come from a variety of sources, and won't necessarily be organized for analytics or reporting. That's
Using relative file paths in your SAS programs? Use the new DLGCDIR function to manage your SAS working directory -- even in SAS Enterprise Guide or SAS Studio -- to ensure your programs are working the way they ought to.
"Code golf" is a fun programming pastime that challenges you to solve a problem with the least amount of code possible. Like regular golf, the goal is to use fewest code "strokes" to hit the mark. Here's a recent challenge that was posted to me via Twitter. @cjdinger @SASJedi got