SAS Learning Post
Technical tips and tricks from SAS instructors, authors and other SAS experts.
In a little more than two weeks, I will be in one of my favorite places, San Diego, California, recruiting potential SAS Press authors at the JMP Discovery Summit, which will be held at the beautiful Paradise Point Resort and Spa from 14 September to 17 September 2015. I’m especially
This post is the second in a series that illustrates three different solutions to "flattening" hierarchical data. Solution 1, from my previous post, created one observation per header record, summarizing the detail data with a COUNT variable, like this: Summary Approach: One observation per header record Obs Family Count
A family and its members represent a simple hierarchy. For example, the Jones family has four members: A text file might represent this hierarchy with family records followed by family members' records, like this: The PROC FORMAT step below defines the codes in Column 1: proc format; value $type