SAS Programming: Summarizing Categorical Data with “Proc Freq”

The freq procedure summarizes categorical data. Typically one wants to restrict the variables that appear in the proc freq to categorical data by using the “table” command. In addition to listing variables separately on can used a numbered range of variables to summarize data. In addition to single variable frequency tables SAS also generates two … More SAS Programming: Summarizing Categorical Data with “Proc Freq”

SAS Programming: Computing Statistics Using “Proc Means”

The “proc means” procedure can be used to generate summary statistics for numerical data.   Typing the following code generates the count, mean, standard deviation, minimum and maximum values for the diabetes data set. Note:  This dataset can be downloaded by clicking on “help” and selecting “learning sas programming” from the SAS dropdown menu. The following … More SAS Programming: Computing Statistics Using “Proc Means”

Programming Excel VBA: Event Triggered Programs

Excel VBA is capable of delivering event triggered programs.  There are many different events that a developer can specify that will trigger a program:  opening a workbook, activating a sheet, saving a workbook, closing a workbook, day of the week, etc.  Writing and using event triggered programs can save much time an energy.  The objective … More Programming Excel VBA: Event Triggered Programs

Quick PasteSpecial: Recording, Examining, and Testing VBA Macro Code

The objective of this post is to introduce the powerful programming language used in Microsoft application called VBA.  More specifically this post will introduce the “macro recorder” that can replay steps taken while the recorder is on.  The recorder is a great way to familiarize oneself with VBA code.  However, further post will build on … More Quick PasteSpecial: Recording, Examining, and Testing VBA Macro Code