topic Re: How to confine number of digits of a number in SAS in SAS Programming

How to confine number of digits of a number in SAS

cindyforest7 — Wed, 09 Oct 2013 19:31:17 GMT

Hello all,

I have a list of numbers under variable A:

4567

234

Now I want to get

00000001

00000003

00000045

00000005

00004567

00000234

00000033

Each number now will have 8 digits.

How to do it in SAS?

Thanks so much!

Cindy

Re: How to confine number of digits of a number in SAS

ballardw — Wed, 09 Oct 2013 19:35:51 GMT

Is A numeric or character?

If numeric do you actually need a new variable or for it just to appear with leading zeroes? In this case you can just assign a format to display with zeroes: Format a z8. ;

If A is character there's a number of ways but

A = put(input(a, best8.),z8.) ; might work.

Re: How to confine number of digits of a number in SAS

cindyforest7 — Wed, 09 Oct 2013 20:18:53 GMT

Thanks!'

It is numeric, and I don't want to create a new variable.

If I want to merge two tables based on A (one table displays with zero, one table does not ), will changing formating work?

Re: How to confine number of digits of a number in SAS

CTorres — Wed, 09 Oct 2013 20:30:10 GMT

If A is numeric in both SAS tables you should be able to merge the tables without changing anything.
The internal representation of A (numeric variable) is the same in both tables. The diference in the display should be because of the format in the table: Z8. (with leading zeroes) v.s. 8. or best8. or none (without leading zeroes)