topic Re: Drop first character when it is an underscore in SAS Programming

Drop first character when it is an underscore

MChan — Fri, 04 Dec 2020 15:12:48 GMT

I have a role column similar to below:

Manager

_Tester_Team

_Research_Team

Supervisor

_Helper_Team

How do I drop only the the first character if it begins with an underscore "_" ?

Final output:

Manager

Tester_Team

Research_Team

Supervisor

Helper_Team

Kurt_Bremser — Fri, 04 Dec 2020 15:21:03 GMT

if char(string,1) = "_" then string = substr(string,2);

ballardw — Fri, 04 Dec 2020 15:21:17 GMT

if variablename =: '_' then variablename = substr(variablename,2);

data_null__ — Fri, 04 Dec 2020 15:47:30 GMT

Did those underscores come from import from EXCEL. If so I would fix in EXCEL.