Currently the only way to output SAS datasets as a multi-sheet EXCEL workbook for reporting is to use ExcelXP ODS tagset. I like this method a lot, because it can generate stylish multiple EXCEL sheets and is highly customizable. However, in practice i…
Stored Process: Need to filter based on a prompt?
For this example – I am creating a report where I want the user to only have the certain values available. If the user selects Mexico as the country then I only want states within Mexico to be available. This pictures shows you how I have the…
A man called Bloom and my take on him
Wondering about Bloom and what he has to do with SAS programming. For any learner, he is someone to respect. For anyone wishing to learn more about the levels of the learning process, this is the master. Bloom classified cognitive, a big word for thi…
Jumping into Windows 7 Jump Lists
Filed under “Little changes that you probably didn’t notice”. When Microsoft introduced Windows 7 to the desktop, one of the many usability features that they added were “Jump Lists”. Jump Lists serve as a sort of shortcut to not just open an application, but “jump right in” to a particular […]
Stored Process: How do I get to the Library? Libname Errors!
Eeeeek!!! Your stored process failed. It worked when in EG – how could this disaster have happened? If you check the log, you may see an error similar to the following about the Libname not being assigned. The library where you stored the data, in this case, MYLIB was either available to SAS EG but not widely known to the SAS BI system or maybe it has a different name in the metadata. To move forward, you need to add a LIBNAME statement that describes where the metadata is located to the stored process. So you would add the following to the code: LIBNAME name meta liburi=”SASLIBRARY?@name=’metadata_name‘ “; You have seen LIBNAME statements before – but wow this one has some extra goodies. My Enchanted Mouse Tricks You may be wondering how I knew what to assign the values – clearly it must be some kind of BI white magic. Yes, using my enchanted mouse in EG, I pointed-and-clicked my way to the answer. In the Server List, I located the dataset being used (SALES_CANDY_HISTORY) and noted the library name, which is Candy. If you review the Candy library properties, you can see some information about the library, where it is stored […]
Example 9.7: New stuff in SAS 9.3– Frailty models
Shared frailty models are a way of allowing correlated observations into proportional hazards models. Briefly, instead of l_i(t) = l_0(t)e^(x_iB), we allow l_ij(t) = l_0(t)e^(x_ijB + g_i), where observations j are in clusters i, g_i is typically norma…