SAS Programming

DATA Step, Macro, Functions and more
BookmarkSubscribeRSS Feed
VinnyR
Calcite | Level 5

I have optained a mix of whole numbers(eg. 1, 2, 3) and non whole numbers (something like 0.12345678, 9.123456) by using proc means. Now in my dataset, I tried using round function, but that rounds only the non whole number (eg 0.1 or 9.1) nut whole numbers stay the same eg.(1, 2, 3).

 

What I want is :

1.0

2.0

3.0

0.1

9.1

 

My code: variable_new= strip(round(variable_old,0.1));

 

ANy help is greatly appreciated.

2 REPLIES 2
Shmuel
Garnet | Level 18

Have you used round as:

    var = round(var,0.1);

and assign:  format var 5.1;   /* one decimal digit. addapt the length */

 

If you still have issues, post your code.

WarrenKuhfeld
Ammonite | Level 13

The round function works correctly.  An integer rounded to 0.1 is that integer.  I suspect that you do not want to round at all.  Rather, use a format like 5.1 (or w.1 for a larger width w) to keep the original precision but display one decimal place.

sas-innovate-white.png

Special offer for SAS Communities members

Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.

 

View the full agenda.

Register now!

How to Concatenate Values

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.

SAS Training: Just a Click Away

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

Browse our catalog!

Discussion stats
  • 2 replies
  • 1066 views
  • 3 likes
  • 3 in conversation