removing leading zeros of a character variable

[Ksharp]

HaiKuo,

That means parsing Perl Regular Expression only once. If remov it , every data step iteration will parse PRX . Using it just for the sake of the speed.

Ksharp

[Michele_E76]

This is perfect! Many of the other solutions I have tried were removing the leading zeros, the trailing zeros, all zeros, or a combination. I need something that removes only the leading zeros in a padded account number text field and then I was able to make that a numeric varialbe. The data was migrated poorly from a mainframe system to a SQL DB, so this helps a ton! Thanks so much!