Add leading zeros to numeric variable

BrahmanandaRao — Fri, 15 Mar 2019 07:32:44 GMT

how to add leading zeros

DATA DS4; INFILE DATALINES; INPUT NUMBER; FORMAT NUMBER Z10.; DATALINES; 1 11 111 1111 11111 111111 1111111 11111111 111111111 1111111111 ; RUN;

Re: Add leading zeros to numeric variable

Kurt_Bremser — Fri, 15 Mar 2019 07:39:40 GMT

You already achieved that:

data ds4;
infile datalines;
input number;
format number Z10.;
datalines;
1
11
111
1111
11111
111111
1111111
11111111
111111111
1111111111
;
run;

proc print data=ds4 noobs;
run;

Result:

A number does not have leading zeroes by definition, but it can be displayed with leading zeroes, and your format does that.

If you need to store leading zeroes (eg if your number is not a number for calculation, but identification), you have to store the value in a character variable.

@BrahmanandaRao wrote:

how to add leading zeros

DATA DS4; INFILE DATALINES; INPUT NUMBER; FORMAT NUMBER Z10.; DATALINES; 1 11 111 1111 11111 111111 1111111 11111111 111111111 1111111111 ; RUN;

topic Re: Add leading zeros to numeric variable in SAS Programming

Add leading zeros to numeric variable

Re: Add leading zeros to numeric variable