topic Re: Creating percentages from decimals in New SAS User

Creating percentages from decimals

Aleksandar — Tue, 14 May 2019 11:03:43 GMT

Hello everyone,

I have created certain variables that are expressed in the decimals. However, I would like to express them as percentages (for example instead of 0.1 I would like to express it as 10%).

What is the function that I should use?

These are the variables that I have created expressed in decimals:

IR_200006m_I
IR_20000_1year_I
IR_20000_2years_I
IR_20000_5years_I
IR_20000_10years_I.

Which code to use to express them in percentages?

Thank you in advance,

Aleksandar

Re: Creating percentages from decimals

PeterClemmensen — Tue, 14 May 2019 11:12:57 GMT

Use the Percent. Format

data have;
 num=0.1;
 format num percent.;
run;

Re: Creating percentages from decimals

Kurt_Bremser — Tue, 14 May 2019 12:00:21 GMT

@Aleksandar wrote:

Hello everyone,

I have created certain variables that are expressed in the decimals. However, I would like to express them as percentages (for example instead of 0.1 I would like to express it as 10%).

What is the function that I should use?

These are the variables that I have created expressed in decimals:

IR_200006m_I
IR_20000_1year_I
IR_20000_2years_I
IR_20000_5years_I
IR_20000_10years_I.

Which code to use to express them in percentages?

Thank you in advance,

Aleksandar

And what are the contents of these variables?

Re: Creating percentages from decimals

Aleksandar — Tue, 14 May 2019 12:44:41 GMT

Thank you for your reply. However, since I have many variables and many observations, it will be hard to compute every number and then to place it in the code. Isn't it possible to just select the variables and then to include function format percent.;?

Re: Creating percentages from decimals

PeterClemmensen — Tue, 14 May 2019 12:48:20 GMT

First of all. It is not a function. It is a format 🙂

Secondly, you can apply the Percent. Format to all variables starting with IR: like this

format IR_: percent.;

Re: Creating percentages from decimals

Kurt_Bremser — Tue, 14 May 2019 12:48:46 GMT

@Aleksandar wrote:

Thank you for your reply. However, since I have many variables and many observations, it will be hard to compute every number and then to place it in the code. Isn't it possible to just select the variables and then to include function format percent.;?

You don't need to re-compute anything. Just assign the format to the variables in question with the FORMAT Statement when you create them.