Remove first and last 3 characters of a string
in [SAS]
|
Prev: remove last 3 characters from a string
Next: any unix sas users here, help with filesystem quota over limit
From: Sri on 14 May 2010 17:30 Hi, What are the possible ways of removing first character and last 3 characters from a string. eg. variable values: A876479003, A675846003, A6842003. I am expecting the following values: 876479, 675846, 6842 Thanks, Sri
From: Kenneth M. Lin on 16 May 2010 03:10
You can use LENGTH() function to determine how long the string is then use SUBSTR() function to capture the range of the characters you want to keep. "Sri" <sriseepana(a)gmail.com> wrote in message news:f4fc456a-d283-4240-ab2b-c5117ace4b50(a)s4g2000prh.googlegroups.com... > Hi, > > > What are the possible ways of removing first character and last 3 > characters from a string. > eg. variable values: A876479003, A675846003, A6842003. > I am expecting the following values: 876479, 675846, 6842 > > Thanks, > Sri |