Improving Analysis

Our ICE Investigators have provided the following documents that highlight useful resources and/or links regarding statistical analysis of data.

If you have a resource you would like to share with your ICE affiliates, please forward it to Darla Steinmann (dsteinma@healthy.uwaterloo.ca)

• References and links for Statistics and Analysis of Survey Data

•List of topics currently being analyzed using WSPP3 data

SAS Add-In for Microsoft Office

SAS offers an Add-In for Microsoft Office that “enables users to transparently leverage the power of SAS data access… from Microsoft Office through integrated menus and toolbars.” [Hertel, 2004]. By using a mechanism referred to as “stored processes”, the user can execute SAS programs from within Excel, thus achieving the statistical power of SAS with a much more familiar and accessible user interface. As well, the user can make use of sixty common analyses, referred to as “Tasks”, in order to analyze data quickly and easily via SAS from within Word or Excel. An added benefit of using the Add-In is that it gets around Excel’s 65,536 row limitation, mentioned in the previous section [Hertel, 2004].