topic How to remove leading zeros from character varibale and convert to numeric in SAS Programming

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

chennupriya — Tue, 26 Jul 2016 01:33:10 GMT

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

100

800

Can anyone pls help

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

Reeza — Tue, 26 Jul 2016 02:02:19 GMT

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

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

chennupriya — Tue, 26 Jul 2016 02:14:18 GMT

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

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

Tom — Tue, 26 Jul 2016 02:20:56 GMT

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;

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

PGStats — Tue, 26 Jul 2016 02:59:07 GMT

With regular expression processing:

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

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

ChrisNZ — Tue, 26 Jul 2016 04:49:21 GMT

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

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

Kurt_Bremser — Tue, 26 Jul 2016 07:56:43 GMT

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)