BookmarkSubscribeRSS Feed
mmohotsi
Quartz | Level 8

Good day

 

I need to round off numbers to the Next 100.

 

The data is as follows:

 

data Enumerate;
input Resources;
datalines;
925
147
;

 

I need the  number 925 to be 1000;

I need the 147 to be 200

 

I know that with the round statement, the two numbers will be 900 and 100 respectively

 

Please assist

2 REPLIES 2
quickbluefish
Barite | Level 11
You could potentially just use:
num=CEIL(Resources/100)*100;
PaigeMiller
Diamond | Level 26

Use the round function with 2nd argument equal to 100 (which gives you answers 900 and 100) and then add 100.

 

 

--
Paige Miller

Catch up on SAS Innovate 2026

Dive into keynotes, announcements and breakthroughs on demand.

Explore 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
  • 518 views
  • 2 likes
  • 3 in conversation