Originally posted by njsden:
Bob, 2 things:
1) If your FACF hold is to contain a list of values you will probe against CHANNEL.CAMP, the the HOLD file should only contain the values for one field ... but I can see in your TABLE FILE BRIEF statement that you are saving values for 2 fields: CAMP and COMM into the HOLD file. This may impact the results later when you try to WHERE CAMP EQ (FACF) ... only one field should be in the HOLD file.
2) The 000010 seems to be the length of 'NA0009MC01'. Is BRIEF.CAMP an AnV field? That's the way they behave. If you want 'NA0009MC01' only you will have to convert it to a "regular" An field before saving it to the HOLD file.
TABLE FILE BRIEF
COMPUTE A_CAMP/A30 = CAMP;
BY CAMP NOPRINT
ON TABLE HOLD AS FACF FORMAT ALPHA
and then test if your WHERE .. (FACF) in the coming statements work now.