Hi,

i want to restrict the contents of Hold file while printing it.
For ex.
Content of hold file.

Accurate WTD
Agree 71%
Disagree 29%
StrongAgree 0%

I want to display as
Accurate WTD
Agree 71%
Disagree 29%

please suggest me in this regard.

Couldn't you do this with just using IF or WHERE selections?

I have tried using WHERE but the desired result is not coming.
Can u suggest me a sample code Using IF.

Basava,
Could you post your code?

Here is my code...

TABLE FILE T_ACC_QUALITY
SUM
COMPUTE WTD/D4% = IF (ACCURATE EQ 'Agree') THEN ((&AGR/&ACC) * 100) ELSE IF (ACCURATE EQ 'Disagree') THEN ((&DAGR/&ACC)*100) ELSE 0 ;
BY ACCURATE
-*ACROSS ACCURATE
WHERE MO_WK_I EQ &WK
ON TABLE HOLD AS H1
END

TABLE FILE H1
PRINT *
WHERE ACCURATE EQ 'Agree' AND ACCURATE EQ 'StronglyAgree'
END
-EXIT

WHERE ACCURATE EQ 'Agree' AND ACCURATE EQ 'StronglyAgree'

Your where statement is asking for only records where the field ACCURATE equals both Agree and StronglyAgree (which isn't possible).

You need an OR:

WHERE ACCURATE EQ 'Agree' OR ACCURATE EQ 'StronglyAgree'

quote:

I have tried using WHERE but the desired result is not coming.
Can u suggest me a sample code Using IF

Well done for demonstrating how much you need training. Check out the training centre links on the forum front page.

T

Assuming you want to eliminate the 'StronglyAgree' give a WTD of zero values, look into using a WHERE TOTAL.

quote:

COMPUTE WTD/D4% = IF (ACCURATE EQ 'Agree') THEN ((&AGR/&ACC) * 100) ELSE IF (ACCURATE EQ 'Disagree') THEN ((&DAGR/&ACC)*100) ELSE 0 ;

According to this, your 'StronglyAgree' will be zero.