How to change "001234" to "1234" in all rows of a column?

[Sandra94]

How to change "001234" to "1234" in all rows of a column?

In one of my columns in the dataset I have customerIDs with "00" added before. I want to delete it at all rows.

Is this possible?

Kind regards,

Sandra

[PeterClemmensen]

Try this

data have;
   CustomerID = "001234";
run;

data want;
   set have;
   id = substr(CustomerID, verify(CustomerID,'0'));
run;

[Phil_NZ]

data want;
   set have;
       y=substr(x,1,2)
       If y="00" then x1=substr(x,3,4);
      else x1=x;
run;

---

@Sandra94 wrote:

In one of my columns in the dataset I have customerIDs with "00" added before. I want to delete it at all rows.

Is this possible?

Kind regards,

Sandra

---

data want;
  set have;
     if substr(customerIDs,1,2) ="00" then delete;
run;

[Shmuel]

I understand that the variable CustomerID is char type and its length is 6.

Alternative ways to those already posted:

1) customeID = put(input(customeID ,6.),6.);

2) Change the type of the variable to numeric:

data want;
 set have(rename=(customeID =CID));
       customeID = input(CID,6.);
       format customeID 6.;
run;