QUESTION: I want to put the actual name of the location where the employee works on individual retirement letters. The data for each participant has a numeric field called LocCode. It has several values:

 

LocCode	Location
1	Fort Wayne
2	Houston
3	Colorado Springs
etc.	etc.

 

ANSWER: Define an unlinked character field in the data dictionary, e.g., LOCATION. In the Data Defaults of the Census Specifications, default it as many times as there are locations using the numeric code (LocCode). Two examples:

 

Field: LOCATION

Default value or expression:

"Fort Wayne"

For records selected by:

LocCode = 1

Field: LOCATION

Default value or expression:

"Houston"

For records selected by:

LocCode = 2