This is running incorrectly. For example for the first variable in the 1st run of the loop &&prefix&i._pol_vac_tpremn resolves to prefix1_pol_vac_tpremn. I wanted it to resolve to fur_pol_vac_tpremn. Additionally since this referencing isn't being resolved, I can't check if these twenty variable character to numeric changes will be in work.newv66 (or will the second 5 overwrite the first 5, third 5 overwrite the second 5, etc.) Can someone help me remedy this or offer a more efficient solution? Thanks.
I rewrote the program with the extra . as you mentioned. However, I moved the DO statement inside the data step to prevent work.newv66 from being re-written after each iteration. However, this causes an error that indicates that the LENGTH statement is used out of proper order. Any idea why this is happening?
You can't change the length of a variable once it has been created on the PDV. It sounds like at least one of the variables referenced in one of your LENGTH statements already exists in NEWV55. Try moving your LENGTH statements before the SET statement in your DATA step.