topic Re: How to change "001234" to "1234" in all rows of a column? in SAS Programming

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

Sandra94 — Wed, 03 Feb 2021 08:37:25 GMT

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

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

PeterClemmensen — Wed, 03 Feb 2021 08:41:11 GMT

Try this

data have;
   CustomerID = "001234";
run;

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

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

Phil_NZ — Wed, 03 Feb 2021 08:48:41 GMT

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;

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

Shmuel — Wed, 03 Feb 2021 09:17:03 GMT

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;