topic How to get leading zero to decimal number for numeric variable? in SAS Programming

How to get leading zero to decimal number for numeric variable?

Saikiran_Mamidi — Tue, 24 Dec 2019 07:01:53 GMT

Ex: A= 123.22
B = 44.21
Need output like
A= 0000123.22
B= 0000044.21

Re: How to get leading zero to decimal number for numeric variable?

Kalind_Patel — Tue, 24 Dec 2019 07:25:14 GMT

You can use zw.d format to get your desired results,

Try this code:

data want;
 value=123.22;
 format value z10.2;
run;

Re: How to get leading zero to decimal number for numeric variable?

ed_sas_member — Fri, 27 Dec 2019 12:40:02 GMT

Hi @Saikiran_Mamidi

you can also use a PROC FORMAT with the PICTURE statement:

data have;
	input A B;
	datalines;
123.22 44.21
;
run;

proc format;
	picture myformat low-high = 9999999.99;
run;

data want;
	set have;
	format A B myformat.;
run;