topic Re: Rounding up month to two decimal place in New SAS User

Rounding up month to two decimal place

hjjijkkl — Tue, 20 Apr 2021 17:15:02 GMT

I have a variable "time_on_team" that has both year and month values and I want to format the variable and say the month is year/12 and I want to put around it to 2 decimal place. How do you around the year/12 to two decimal place?

length Yrson 8.;
if (time_on_Team)= 'year' then YrsOn= 'Year';
else if (time_on_team)='month' then YrsOn='year'/12;
drop time_on_team;
label YrsOnARV = 'Years on ARVs';

Re: Rounding up month to two decimal place

PaigeMiller — Tue, 20 Apr 2021 17:20:45 GMT

You can use the ROUND function.

However, your code can't possibly work, dividing a character string by 12. Get as much of the code to work before worrying about rounding.

Re: Rounding up month to two decimal place

Reeza — Tue, 20 Apr 2021 17:24:25 GMT

This answers your question

YrsOn = round(YrsOn, 0.01);
format YrsOn 8.2;

But I don't think this is correct: YRSON would now be a character variable, not numeric as you've assigned it the value "Year" and I would assume your ELSE line of code would generate an error. Are you trying to access a variable called year? If so, remove the quotes from around the name as that's a character string, not a variable name.

length Yrson 8.;
if (time_on_Team)= 'year'  then YrsOn= 'Year';
else if (time_on_team)='month' then YrsOn='year'/12;

If you have a variable year you could also refer to it as 'Year'n but if the n does not follow the quote then it will be interpreted as a character string, not a variable name. I don't think this is your issue however.

@hjjijkkl wrote:

I have a variable "time_on_team" that has both year and month values and I want to format the variable and say the month is year/12 and I want to put around it to 2 decimal place. How do you around the year/12 to two decimal place?

length Yrson 8.;
if (time_on_Team)= 'year' then YrsOn= 'Year';
else if (time_on_team)='month' then YrsOn='year'/12;
drop time_on_team;
label YrsOnARV = 'Years on ARVs';

Re: Rounding up month to two decimal place

hjjijkkl — Tue, 20 Apr 2021 17:26:09 GMT

How can i say year/12? I didnt know if it was going to work
else if (time_on_team)='month' then YrsOn='year'/12;

Re: Rounding up month to two decimal place

Tom — Tue, 20 Apr 2021 17:39:42 GMT

Please show an example of your data.

Does the variable TIME_ON_TEAM have the strings YEAR and MONTH? Or does it have a number?

If it has a number then how can you tell if the number is a number of months or number of years?

Re: Rounding up month to two decimal place

PaigeMiller — Tue, 20 Apr 2021 17:41:54 GMT

'year' is a character string, which cannot be divided by 12

year is (possibly, I don't know your data) a variable name, and if this variable is numeric, it can be divided by 12

Re: Rounding up month to two decimal place

hjjijkkl — Tue, 20 Apr 2021 17:54:27 GMT

the variable YearOn has values like ( 4 years, 8month, 6years etc..) and I want the month values to be divided by 12. How can i do that in the if/then statement?

Re: Rounding up month to two decimal place

PaigeMiller — Tue, 20 Apr 2021 18:05:46 GMT

As stated above by @Tom , please show us a portion of your data. Please follow these instructions and do not show us your data via any other method.

Re: Rounding up month to two decimal place

hjjijkkl — Tue, 20 Apr 2021 18:31:34 GMT

my data is very big but, this is how it looks like
ID Time_on_team
1 2years
2 6years
3 6month
4 10years
5 4month
6 8month
I am trying to find the range, mean, sd, IQR median for time_on_team

Re: Rounding up month to two decimal place

PaigeMiller — Tue, 20 Apr 2021 18:45:33 GMT

Showing a portion of the data is fine. However, the specific request was "Please follow these instructions and do not show us your data via any other method."

Re: Rounding up month to two decimal place

hjjijkkl — Tue, 20 Apr 2021 18:50:56 GMT

my data is very big but, this is how it looks like
ID Time_on_team
1 2years
2 6years
3 6month
4 10years
5 4month
6 8month
I am trying to find the range, mean, sd, IQR median for time_on_team

Re: Rounding up month to two decimal place

Tom — Tue, 20 Apr 2021 19:00:34 GMT

So you want to convert strings into numbers? How consistent are the strings? Are they as messy as your examples?

4 years
8month
6years

Can we assume there is always a space between the digits and the letters?

4 years
8 month
6 years

Re: Rounding up month to two decimal place

hjjijkkl — Tue, 20 Apr 2021 19:02:35 GMT

yes

Re: Rounding up month to two decimal place

hjjijkkl — Tue, 20 Apr 2021 19:04:22 GMT

I want to use an if then stament
like this below. but, the one i created doesnt work
length Yrson 8.;
if (time_on_Team)= 'year' then YrsOn= 'Year';
else if (time_on_team)='month' then YrsOn='year'/12;
drop time_on_team;
label YrsOn = 'Years on Team';

Re: Rounding up month to two decimal place

Tom — Tue, 20 Apr 2021 19:12:32 GMT

First parse the string into two parts. The digits and they units. Convert the digits into a number. Then based on whether the units indicate months divide the number by 12.

So assuming you have only the two forms and the values have a space it is really easy.

data have;
  id+1;
  input time_on_team $20.;
cards;
2 years
6 years
6 month
10 years
4 month
8 month
;

data want;
  set have;
  duration=input(scan(time_on_team,1,' '),32.);
  if index(time_on_team,'month') then duration=duration/12;
run;

Results:

             time_on_
Obs    id      team      duration

 1      1    2 years       2.0000
 2      2    6 years       6.0000
 3      3    6 month       0.5000
 4      4    10 years     10.0000
 5      5    4 month       0.3333
 6      6    8 month       0.6667