Do the START and END values in a user defined format have to be text? I'm trying to use the format as a lookup table to optain the company division/region and area names for each cost center number, to do a report for my company. Currently, the cost center number column on our main reporting dataset is numeric. Will I have to convert it to text to perform the lookup, then convert it back to numeric when the report is output?
a format is used as a value is "put".
As such it provides text (often numeric text, but still text)
That seems just fine for output.
If your "output" is to be received in an environment where it is to be treated as numeric (like a database or excel) you'll be able to support the receiving environment with more information, like DBtype option (iirc) through SAS/Access, or tagattr strings through tagsets.excelXP
reading the OP question beyond the subjectline question[pre]> I'm trying to use the format as a
> lookup table to optain the company division/region
> and area names for each cost center number,
> Currently, the cost center
> number column on our main reporting dataset is
> numeric. Will I have to convert it to text to
> perform the lookup, [/pre]
I decided to answer the part that you had not already answered.
Chandler's program won't need to convert his cost center number to perform the look-up.(imho)
Would you agree?