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?
<broken record> Change your data to a long format rather than a wide format </broken record>
I do not understand. Can you provide an example with sas code? Thanks.
Post sample data as a data step so I don't have to make it up.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.