Hello Tom.  I appreciate the information and advice you've shared. People here are so helpful and I've learned a lot from you guys just on this one simple/basic problem, which is very encouraging for me as a beginner.    ... View more

Hello. Yes, I found out about it just a minute ago... Such a rookie mistake @_@. Thanks very much! ... View more

Nah. No luck with your solution. But you did give me the idea of what's wrong. I realized the leading tab I entered before the data caused the problem... So the position of those digits shifted in the output.  Forgive me of this stupid mistake (facepalm)  And thanks for your help!  ... View more

Hello. Please refer to my reply to @novinosrin  Thank you!  ... View more

Data Example; Input abc $12.; Datalines; 083154564684 783480645621 384563604852 ; Run; data test; set example; num = SUBSTR(abc,2,5); run;   Output: abc num 08315456468 08315 78348064562 78348 38456360485 38456   Log: 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 Data Example; 74 Input abc $12.; 75 Datalines;   NOTE: The data set WORK.EXAMPLE has 3 observations and 1 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds     79 ; 80 Run; 81 82 data test; 83 set example; 84 num = SUBSTR(abc,2,5); 85 run;   NOTE: There were 3 observations read from the data set WORK.EXAMPLE. NOTE: The data set WORK.TEST has 3 observations and 2 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.00 seconds     86 87 proc print noobs; 88 run;   NOTE: There were 3 observations read from the data set WORK.TEST. NOTE: PROCEDURE PRINT used (Total process time): real time 0.02 seconds cpu time 0.03 seconds ... View more

Thank you for your reply 😄 Mine gave me the result like the following -  08315456468 --> 08315  78348064562 --> 78348  38456360485 --> 38456 I just tried and set the second parameter as 3 instead of 2, this way could get the correct output...(???) ... View more