Help using Base SAS procedures

Numeric variables and trailing zeroes

Reply
Occasional Learner
Posts: 1

Numeric variables and trailing zeroes

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

Super User
Posts: 7,110

Re: Numeric variables and trailing zeroes

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Super User
Posts: 5,258

Re: Numeric variables and trailing zeroes

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?

Contributor
Posts: 20

Re: Numeric variables and trailing zeroes

Just use best. format

Ask a Question
Discussion stats
  • 3 replies
  • 179 views
  • 0 likes
  • 4 in conversation