## format max dec when creating new variable

Solved
Regular Contributor
Posts: 187

# format max dec when creating new variable

Hi all!

If I write this to calculate a percentage in a data step,  where do I write the maxdec=2  so that percent_miss is only 2 decimals?

data gaq_4 (drop=_TYPE_ _FREQ_);
set gaq_1 (rename=(_FREQ_=Study_Population));
Percent_Miss=nmiss/Study_Population;

run;

Thank you!!

Accepted Solutions
Solution
‎11-10-2017 02:27 PM
Super User
Posts: 8,279

## Re: format max dec when creating new variable

Are you asking how to round your results to 2 decimal places?

Use the ROUND() function.

``Percent_Miss=round(nmiss/Study_Population, 0.01);``

All Replies
Super User
Posts: 24,012

## Re: format max dec when creating new variable

MAXDEC is only an option in PROC MEANS.

You use a FORMAT or ROUND in a data step or SQL to limit the decimal places.

Solution
‎11-10-2017 02:27 PM
Super User
Posts: 8,279

## Re: format max dec when creating new variable

Are you asking how to round your results to 2 decimal places?

Use the ROUND() function.

``Percent_Miss=round(nmiss/Study_Population, 0.01);``
☑ This topic is solved.