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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.