Comments on snippet: 'Show all possible values in table regardless of whether or not the value exists' Snipplr comments feed https://snipplr.com/ Wed, 22 Apr 2026 23:10:16 +0000 webonomic said on 25/Aug/2009 https://snipplr.com/view/18831/show-all-possible-values-in-table-regardless-of-whether-or-not-the-value-exists <p>Solution #2 is not CPU efficient. It works fine the small TEST dataset, but if you have many vars or observations, consider creating a macro do loop just like in solution #1. When I ran the solution #2 against a dataset with 10 vars and 200 observations, it took about 8 minutes to run and created a dataset of around 6.8 million records! Ouch!</p> Tue, 25 Aug 2009 13:23:45 UTC https://snipplr.com/view/18831/show-all-possible-values-in-table-regardless-of-whether-or-not-the-value-exists