topic Re: How to remove leading zeroes from character variable in SAS Procedures

How to remove leading zeroes from character variable

ren2010 — Fri, 16 Jul 2010 19:00:12 GMT

Hi,

I Have a character variable with comes with leading zeroes.

ID
0111
0222
0333

my desired result:
ID
111
222
333

Please help

Re: How to remove leading zeroes from character variable

sbb — Fri, 16 Jul 2010 19:44:21 GMT

DATA step, assignment statement using the INPUT function to convert your character variable to a SAS numeric variable, then use the desired SAS output format for the numeric variable (or take the SAS-default assigned).

Scott Barry
SBBWorks, Inc.

Suggested Google advanced search argument, this topic / post:

convert character numeric variable input function site:sas.com

Re: How to remove leading zeroes from character variable

Cynthia_sas — Thu, 22 Sep 2016 15:41:59 GMT

Editor's note: The INPUT ifunction is the easist solution first mentioned by @sbb. Cynthia goes into a little more detail below on the solution.

Hi:
Remember that there may be a reason that an ID number has a leading zero. It could be that the ID will be invalid without the leading zero.

It would be useful to know whether you want to create a new numeric variable without leading zeroes (easily done with the INPUT function); or whether you want to create a new character variable (still possible, but needs to use both the PUT and INPUT functions).

In the conversion of a character string using the INPUT function, leading zeroes automatically "go away". Once you have a new numeric variable, you might be satisfied with that value as a number. On the other hand, if you really just want a new character variable, then you can take the results of the INPUT function and use the PUT function to turn the new number back into a character string. If you want the value "left-justified", then either the COMPRESS function or the LEFT function would get rid of leading spaces in the new character string. In my example below, I use the LEFT function with the PUT function. (I added some test cases to the data to show that the 2 methods will work for a broader range of data scenarios.)

cynthia

data charval;
 infile datalines;
 input ID $;
 ** create a numeric variable which will not contain a leading 0;
 ** the INPUT function turns a character string into a number value;
 newnum = input(ID,4.);

 ** The INPUT and PUT function together would correctly make a;
 ** new character variable without leading zeroes;
 newchar_fromPUT = left(put(newnum,$4.));

 return;
 datalines;
 0111
 0222
 0333
 0404
 5348
 0044
 ;
 

options nodate nonumber;
 proc print data=charval;
   var ID newnum newchar_fromPUT;
   title 'Get Rid of -ONLY- the Leading Zero in ID Char String';
   title2 'INPUT method makes a numeric variable';
   title3 'PUT with INPUT makes a character variable';
 run;

Re: How to remove leading zeroes from character variable

ArtC — Sat, 17 Jul 2010 22:54:40 GMT

Assuming that you do want a character variable without leading zeros, an alternative to the PUT INPUT functions could be the use of the VERIFY and SUBSTR functions. Not because they are better but VERIFY does not get used too much and here is its chance to shine.

[pre]
data val;
x='000asd1234';output;
x='123'; output;
x='0009876'; output;
run;
data nozero;
set val;
y = substr(x,verify(x,'0'));
run;
[/pre]

Re: How to remove leading zeroes from character variable

sbb — Sun, 18 Jul 2010 14:36:43 GMT

Use the INPUT function to ensure an accurate result (based on the original data sample posted). No question that VERIFY has its purpose but definitely not here - considering an embedded zero character in the character variable string.

Scott Barry
SBBWorks, Inc.

Re: How to remove leading zeroes from character variable

data_null__ — Sun, 18 Jul 2010 14:44:10 GMT

VERIFY returns position of first character NOT in the second argument. Embedded zero is not a problem.

Re: How to remove leading zeroes from character variable

sbb — Sun, 18 Jul 2010 15:00:15 GMT

I stand corrected - nice application, ArtC.

Scott

Re: How to remove leading zeroes from character variable

sas_ — Mon, 19 Jul 2010 09:34:50 GMT

do

id1=id*1
then if u wnat use the id1 or u can convert id1 again in to character.
id1=put(id1,char4.);

Re: How to remove leading zeroes from character variable

ren2010 — Mon, 19 Jul 2010 16:51:19 GMT

A big THANK YOU to all of you for your suggestions,appreciate it.

How to remove leading zeroes from character variable

lordlnyc — Tue, 06 Mar 2012 17:37:29 GMT

I was doing a google search to find the answer to my SAS problem, and found this question and answer.

I know this posting is more than 1.5 years old, but I just wanted to say tha your answer is exactly what I needed and I thank you. My data is a character string of mixed numbers and letters almost like your first example, and I needed to drop the leading zeros.

Oh I also want to thank ren2010 for posting the question in the first place.

-Larry-

How to remove leading zeroes from character variable

Ksharp — Wed, 07 Mar 2012 03:03:33 GMT

There are always a couple of ways to solve a problem in SAS.

data val;
x='000asd1234';output;
x='123'; output;
x='0009876'; output;
run;

data nozero;
   set val;
   y =prxchange('s/^0+//o',-1,x);
   run;

Ksharp

Re: How to remove leading zeroes from character variable

WilliamD_ — Wed, 02 Jul 2014 17:49:36 GMT

Just wanted to shout out to Art C. I hadn't used the verify function before, but I applied it much the way you did in your example to achieve exactly what I needed. Also, love your book on Innovative SAS Techniques!

Re: How to remove leading zeroes from character variable

osvaldoberg — Tue, 15 Sep 2015 15:24:48 GMT

I do it that way.

DATA FINAL;
	SET ORIGEM;

	TEST = COMPRESS(PUT(INPUT(VARIABLE_WITH_ZERO,8.),8.));

RUN;

8. is the size of the variable.

Compress is for remove blank spaces.

Re: How to remove leading zeroes from character variable

MikeZdeb — Tue, 15 Sep 2015 23:15:48 GMT

Hi, try this ...

data x;
input id :$6. @@;
datalines;
0111 0222 0333 000012 0099 88
;

data xplus;
set x;
id = cat(input(id,6.));
run;

data set XPLUS

Obs id

1 111
2 222
3 333
4 12
5 99
6 88

Re: How to remove leading zeroes from character variable

SGK — Wed, 16 Sep 2015 14:52:21 GMT

Brilliant!