SAS Learning Post
Technical tips and tricks from SAS instructors, authors and other SAS experts.Growing up in Michigan, I, like all state residents, learned early on that the lower peninsula of Michigan is shaped like a mitten. This piece of information has served me well all my life; whenever I meet a stranger who wants to know where in Michigan I grew up, I
SAS procedure SUMMARY is a quick method of converting your detail table to a fully summarized one. Included is a sample. The key option to set is the NWAY - this generates the lowest level of summary for use in the OLAP cube. Essentially - the class statement contains all
In the past couple months, this scenario has occurred twice. So thought I'd share a quick remedy ~ and save for my future reference when this occurs again :). In Star Schemas, there are sometimes occasions where the data quality isn't exactly perfect. And sometimes, for some users/companies, this is
OLAP Calculated Members need to be tested to ensure that the numbers are correct in various tools. What we recently found was that the member tested properly in the OLAP Studio View Cube but then in Web Report Studio, the measure wasn't correct. Essentially, it was calculating the custom measurement
Contributed by Gert Laursen--author, head of customer intelligence at Maersk Line, and business intelligence thought leader in Denmark Dear reader, In my new book, Business Analytics for Sales and Marketing Managers: How to Compete in the Information Age, you can learn how you can use analytics to reach your sales
When I began my job at SAS in 1999 (I was only 14 years old at the time), one of my responsibilities was taking over the production of a listserv called NEWDOCNEWS. The listserv consisted of all the new titles from Books By Users (now SAS Press) and SAS Documentation