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)
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: