how to use array or macro to rewrite the code

[KachiM]

I am datasp.

Whom do you ask this question? Before asking question, write the name of person who replied.

I pointed out much earlier in my post that you are comparing a substring of 3 characters with the value of either '09' or 'E8'. This comparison is wrong. Again I asked you not to use SUBSTR() function and showed it.

What you mean by "The value should be three but I typed wrong"?

Are you prepared to list your input variables once?

[Reeza]

<broken record> Change your data to a long format rather than a wide format </broken record>

[Bal23]

I do not understand. Can you provide an example with sas code? Thanks.

[Reeza]

Post sample data as a data step so I don't have to make it up.