04-18-2017 03:30 AM
Have: '89', '240', 'E9C10'. (original strings)
Need: 'cc00089', 'cc00240', 'ccE9C10'. (new strings)
Basically, new strings (7 characters)= 'cc' + '0's + original strings.
Previously achieved in Excel using macros, not sure how to do in SAS?
04-18-2017 03:42 AM
You can use the LENGTH and REPEAT functions to get what you need, see sample below.
data want; length orig $ 7; length want $ 7; do orig = '89', '240', 'E9C10', '1'; l_orig = length(orig); want = cats("cc", repeat("0", 5 - 1 - length(orig)) , orig); l_want = length(want); output; end; run;
Need further help from the community? Please ask a new question.