Hi All,
I am very new to SAS and still learning so apologies if my question is simple.
I have a numeric column (this has to stay numeric) and in that column I have for example:
2
5
7
2.1
3
4
The issue is since I have placed the 2.1 into the mix the list now reads as follows:
2.0
5.0
7.0
2.1
3.0
4.0
Is there anyway to remove the 0s!
Thanks very much in advance
Dan
Use a 2. format. When you tell SAS to display decimals (by using a format with a number after the dot), it will do so.
If you use the 2. format, you will lose a piece: 2.1 will print as 2 instead.
Worth a try: the best3. format. For example:
format varname best3.;
I can't test it right now, but if this doesn't work I think the solution becomes more complex.
Is there some good reason that you don't want to see the zeros?
Just use best. format
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.