BookmarkSubscribeRSS Feed
venkatesh
Calcite | Level 5
Hi.,

want to reduce the salary variable after two decimal points in DI studio

for example salary---------2500.0025314
required salary----------2500.00

it has to be in DI studio only....
Thanks a lot
2 REPLIES 2
Cynthia_sas
SAS Super FREQ
Hi:
You either need to use the ROUND function when you create the salary variable (or in your table loading program code):
salary = round(xxx,.01);

or
you can apply a format to reduce the DISPLAYED decimal places to 2 places.
format salary 10.2;

The format method means that the number would still be stored with more than 2 decimal places. The users would never see more than 2 as long as the format was permanently assigned and they did not change it.

cynthia
venkatesh
Calcite | Level 5
It works fine....

thanks cynthia...

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 572 views
  • 0 likes
  • 2 in conversation