How to remove leading zeros from character varibale and convert to numeric

[chennupriya]

Hi,

I Have a character variable with comes with leading zeroes and my desired result should be numeric with removal of leading zeros

and substr the values from 3rd position  BID= Substr(AID,3,3)

AID
 00000

 000001

 000011

000100

I20800

my desired result:
BID
 0
 1

11

100

800

Can anyone pls help

[Reeza]

Input ignoring the leading zeroes issue. SAS will remove them automatically. 

[chennupriya]

But what function should i need to use to get BID from AID

[ChrisNZ · Accepted solution]

BID= input(substr(AID,3,3) ,32.);

[Tom]

The INPUT() function can convert a character string to a new value by applying the INFORMAT that you choose.

But you will need to explain why you want to convert the last string into the number 800. Why did you ignore the letter 'I' at the beginning of the string?  Why not 20,800 instead of 800?

data have ;
  input AID $char12. ;
cards;
 00000
 000001
 000011
000100
I20800
;

data want ;
 set have ;
 bid = input(aid,12.);
run;

[PGStats]

With regular expression processing:

length BID $8;
BID = prxchange("s/..0*(\S+)/\1/o", 1, AID);

[Kurt_Bremser]

You should really use the {i} symbol to post data, as this uses a fixed-width font and preserves correct spacing. As it is, your example data does not match your stated requirements.

Per your requirements,

data want;
set have;
bid = input(substr(aid,4,3),3.);
run;

should do the trick.

(getting the last 3 characters from a 6-character string requires starting at position 4)