topic Re: Question how do I add leading zero to numbers under 10? in SAS Procedures

Question how do I add leading zero to numbers under 10?

GregINGov — Fri, 31 Oct 2014 12:22:58 GMT

I need to add leading zero to any number under 10.

data lat;

set clovis_data;

latdeg1=int(latitude);

latdeg2=int((latitude-latdeg1)*60);

latdeg3=round((((latitude-latdeg1)*60)-latdeg2)*60);

run;

I need to add leading zero to any number under 10 for Latdeg2 and Latdeg3.

Re: Question how do I add leading zero to numbers under 10?

PaigeMiller — Fri, 31 Oct 2014 12:39:13 GMT

You can use the format Z2. to make the values appear with a leading zero (or some version of the Zw.d format)

Or you can turn them into character variables and concatenate a zero before the actual value if it is less than 10.

Of the two choices, I prefer the first in most cases, which leaves the number as a numeric variable

Re: Question how do I add leading zero to numbers under 10?

GregINGov — Fri, 31 Oct 2014 12:46:19 GMT

so in format Z2 I can make just the number under 10 with a leading zero?

Re: Question how do I add leading zero to numbers under 10?

Kurt_Bremser — Fri, 31 Oct 2014 12:54:44 GMT

That is the explicit purpose of the z2. format.

2 -> 02

9 -> 09

10 -> 10

100 and up will yield ** and generate a NOTE in the log that the format was too small.

Re: Question how do I add leading zero to numbers under 10?

RW9 — Fri, 31 Oct 2014 12:55:36 GMT

Well, if you have a 0 preceding a number like: 02, its not really a number as such. So the number there is 2. If you want to display that with a preceding 0 then you have two options - apply a format Z2. to that variable - or put the number into Z2 and store it in a character variable. There are plusses and minus to each approach.

Re: Question how do I add leading zero to numbers under 10?

jakarman — Fri, 31 Oct 2014 13:14:33 GMT

Then naming is giving the impression it is about geo.

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a003113162.htm

A nice paper http://support.sas.com/resources/papers/proceedings11/299-2011.pdf