Instructions for sampling and assigning test and

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: to have a Requirements Document and within that document should be a section specifying criteria for which customers to include or exclude from the population. Essentially, the inclusion/exclusion rules define the profile of the targeted customer base. Instructions for sampling and assigning test and control cases are in separate sections. The selection criteria can quickly get complicated and custom coding can take a long time what with keying the code, testing, and debugging. Fat-fingering happens. Code generators dramatically speed up the process and reduce risk of miss-keying constraining values. In this section we look at a SAS code generator that uses on W ord and Excel. The Requirements Document is stored as a W ord template and contains one general information table and three tables with specific selection criteria written in phrases the business users will understand—not pseudo-code. Each table is bookmarked, and each item in a table has a unique ID number composed of a table identifier and the row number. To make comprehension and completion easier, one table presents rules written as Inclusion Criteria and two tables present rules for Exclusion Criteria. The user simply marks a ‘Y’ for the items to apply to their campaign and, if appropriate, a value that constrains application of the rule . In the examples below, Exclusion Criteria as broken into one table for yes or no answers and another table that requires constraining values. The three tables offer about 120 unique criteria, each referencing a specific target field in a Base Audience Table. 4 SAS Global Forum 2013 Foundations and Fundamentals Display 4. Inclusion and Exclusion Criteria Tables in a Word Document 5 SAS Global Forum 2013 Foundations and Fundamentals Using the template a campaign-specific Requirements Document is produced, reviewed, and approved. W hen it’s time to generate the query to pull the population, SAS reads the document and creates a data set for each bookmarked table. Here is th...
View Full Document

This test prep was uploaded on 03/30/2014 for the course CGS 1000 at Hillsborough.

Ask a homework question - tutors are online