topic Numeric variables and trailing zeroes in SAS Procedures

Numeric variables and trailing zeroes

Dancreed — Mon, 04 Sep 2017 16:20:44 GMT

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.1

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

Kurt_Bremser — Mon, 04 Sep 2017 22:16:51 GMT

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.

Astounding — Mon, 04 Sep 2017 23:08:02 GMT

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 — Fri, 08 Sep 2017 17:43:49 GMT

Just use best. format