topic Re: format max dec when creating new variable in SAS Programming

format max dec when creating new variable

jenim514 — Fri, 10 Nov 2017 18:15:58 GMT

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 — Fri, 10 Nov 2017 18:32:40 GMT

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 — Fri, 10 Nov 2017 18:54:09 GMT

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

Use the ROUND() function.

Percent_Miss=round(nmiss/Study_Population, 0.01);