topic substring by delimiter? in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/substring-by-delimiter/m-p/11539#M1383 <HTML><HEAD></HEAD><BODY><P> varname = scan(varname, 1, '-');</P></BODY></HTML> Thu, 23 Feb 2012 17:47:48 GMT Astounding 2012-02-23T17:47:48Z substring by delimiter? https://communities.sas.com/t5/SAS-Procedures/substring-by-delimiter/m-p/11538#M1382 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a character field i'd like to clean up by using a delimiter.</P><P></P><P>for example my data has a bunch of codes that look like:</P><P>tmp435-abc</P><P>tmp902-cde</P><P>tp309-dmco</P><P>etc.</P><P></P><P>i'd like to clean up the variable to cut off at the '-' delimiter.</P><P></P><P>I'm not sure what the right function to use is.</P><P></P><P>Thanks for your help.</P></BODY></HTML> Thu, 23 Feb 2012 17:46:34 GMT https://communities.sas.com/t5/SAS-Procedures/substring-by-delimiter/m-p/11538#M1382 Danglytics 2012-02-23T17:46:34Z substring by delimiter? https://communities.sas.com/t5/SAS-Procedures/substring-by-delimiter/m-p/11539#M1383 <HTML><HEAD></HEAD><BODY><P> varname = scan(varname, 1, '-');</P></BODY></HTML> Thu, 23 Feb 2012 17:47:48 GMT https://communities.sas.com/t5/SAS-Procedures/substring-by-delimiter/m-p/11539#M1383 Astounding 2012-02-23T17:47:48Z substring by delimiter? https://communities.sas.com/t5/SAS-Procedures/substring-by-delimiter/m-p/11540#M1384 <HTML><HEAD></HEAD><BODY><P>thank you.</P></BODY></HTML> Thu, 23 Feb 2012 17:49:25 GMT https://communities.sas.com/t5/SAS-Procedures/substring-by-delimiter/m-p/11540#M1384 Danglytics 2012-02-23T17:49:25Z