Hi,

Can anyboby tell me how to join two hold files. As i am getting parsing error if i use "JOIN".
i want to display as the format mentioned below.

Accurate WTD MTD
Agree 35% 56%
Disagree 65% 44%

But i am getting in this format

Accurate WTD
Agree 35%
Disagree 65%
Accurate MTD
Agree 56%
Disagree 44%

Please find the code below.

SET ASNAMES=ON
-SET &ECHO=ALL
SET LINES = 9999
-*SET HOLDLIST = PRINTONLY
-******************************************************************************************
-DEFAULT &WK = 5
-DEFAULT &M = 8
-DEFAULT &Y = 2005
TABLE FILE T_ACC_QUALITY
SUM
CNT.ACCURATE
CNT.FAST
CNT.FRIENDLY
WHERE MO_WK_I EQ &WK
ON TABLE HOLD AS HOLD1
END
-RUN
TABLE FILE HOLD1
PRINT *
ON TABLE SAVE AS SAVE1
END
-RUN
-READ SAVE1 &ACC.I5. &FAST.I5. &FRIEND.I5.
TABLE FILE T_ACC_QUALITY
SUM
CNT.ACCURATE
CNT.FAST
CNT.FRIENDLY
WHERE MO_I EQ &M
ON TABLE HOLD AS HOLD2
END
-RUN
TABLE FILE HOLD2
PRINT *
ON TABLE SAVE AS SAVE2
END
-RUN
-READ SAVE2 &ACCM.I5. &FASTM.I5. &FRIENDM.I5.
-* *****************************************************FOR ACCURATE CATEGORY START
TABLE FILE T_ACC_QUALITY
SUM
COMPUTE WTD/D4% = IF (ACCURATE IN ('Agree' , 'StronglyAgree')) THEN ((CNT.ACCURATE/&ACC) * 100) ELSE IF (ACCURATE EQ 'Disagree') THEN ((CNT.ACCURATE/&ACC)*100) ELSE 0 ;
BY ACCURATE
WHERE MO_WK_I EQ &WK
END
-RUN

TABLE FILE T_ACC_QUALITY
SUM
COMPUTE MTD/D4% = IF ACCURATE IN ('Agree' , 'StronglyAgree') THEN ((CNT.ACCURATE/&ACCM) * 100) ELSE IF ACCURATE EQ 'Disagree' THEN ((CNT.ACCURATE/&ACCM)*100) ELSE 0 ;
BY ACCURATE
WHERE MO_I EQ &M
END
-RUN
-********************************************************FOR ACCURATE CATEGORY END

-EXIT

This message has been edited. Last edited by: basava,

Basava,
What do you want to JOIN?

Hi,

I repeat the question Danny:What do you want to join.
Generally, if you want to join 2 hold files you have to hold each of them with an index.
Then you will used these 2 indexes in your join.

Majid.

HI,
Sorry i have hove not inculed the command in the code for creating index, because i was getting the parsing error.
please check the main code below.

TABLE FILE T_ACC_QUALITY
SUM
COMPUTE WTD/D4% = IF (ACCURATE IN ('Agree' , 'StronglyAgree')) THEN ((CNT.ACCURATE/&ACC) * 100) ELSE IF (ACCURATE EQ 'Disagree') THEN ((CNT.ACCURATE/&ACC)*100) ELSE 0 ;
BY ACCURATE
WHERE MO_WK_I EQ &WK
ON TABLE HOLD AS HWA1 FORMAT FOCUS INDEX ACCURATE
END
-RUN

TABLE FILE T_ACC_QUALITY
SUM
COMPUTE MTD/D4% = IF ACCURATE IN ('Agree' , 'StronglyAgree') THEN ((CNT.ACCURATE/&ACCM) * 100) ELSE IF ACCURATE EQ 'Disagree' THEN ((CNT.ACCURATE/&ACCM)*100) ELSE 0 ;
BY ACCURATE
WHERE MO_I EQ &M
ON TABLE HOLD AS HMA1 FORMAT FOCUS INDEX ACCURATE
END
-RUN

Here i want to join HWA1 & HMA1 hold files.

Basava,

Wouldn't

  
JOIN ACCURATE IN HMA1 
TO ACCURATE IN HWAI 
AS X
END

do the job?

hi danny,

thank's alot....

i got it.

Also, FYI, the parent or host of the join does not have to be a FOCUS file with an index. A simple hold file will suffice.