format max dec when creating new variable

[jenim514]

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!!

[Reeza]

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.

[Tom · Accepted solution]

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

Use the ROUND() function.

Percent_Miss=round(nmiss/Study_Population, 0.01);