BookmarkSubscribeRSS Feed
Dancreed
Calcite | Level 5

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

3 REPLIES 3
Astounding
PROC Star

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?

MINX
Obsidian | Level 7

Just use best. format

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

What is Bayesian Analysis?

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 3885 views
  • 0 likes
  • 4 in conversation