I need to remove the first zero, some obs have values like 00234, 00a234, and i only need to remove the first zero
can anybody advice how to get rid of the first "o" but not all leading zeros? Thanks
v2= substr(v1,verify(v1,'0'));
You don't say if you want to remove 0 if there is only one leading zero. If that is the case then one way is
if index(v1,'0')=1 then v2= substr(v1,2);
if ony replace the first zero when you have 2 leading zeroes or more then
if index(v1,'00')=1 then v2= substr(v1,2);
You don't say if you want to remove 0 if there is only one leading zero. If that is the case then one way is
if index(v1,'0')=1 then v2= substr(v1,2);
if ony replace the first zero when you have 2 leading zeroes or more then
if index(v1,'00')=1 then v2= substr(v1,2);
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.