Hello all,
I have a list of numbers under variable A:
A
1
3
45
5
4567
234
33
Now I want to get
A
00000001
00000003
00000045
00000005
00004567
00000234
00000033
Each number now will have 8 digits.
How to do it in SAS?
Thanks so much!
Cindy
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.
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?
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)
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.