So if I want to still convert it this way as I was mentioning before, this is my progress on the code data want1; set have; test= substr(ICD10,1,3); /* eg. A00 */ test1= scan(ICD10,1,'-'); test1_1 = SCAN( test1, 2, '.') ; /* eg., 0 */ test2 = scan(ICD10 ,2,'-'); test2_1 = SCAN( test2, 2, '.') ; /* eg., 9 */ run; data want2; set want1; do i = test1_1 to test2_1; testvar = catt(test, ".", i ); output; end; run; What am I doing wrong here? If I just manually substitute Test1_1 = 1 and test2_1 with 9 and rerun the want2 datastep, then I get some resutls (which is obviously not right for all codes but converts correctly for first row in original file). I need some tips on what I may be doing wrong in this code instead of suggestions on alternate solutions.
... View more