topic Re: Converting from weeks to days in SAS Programming

Converting from weeks to days

JessSun — Thu, 02 May 2013 12:59:00 GMT

Hi everyone,

I have a variable called "Weeks_Days" which is in weeks with the decimal part indicating number of days (e.g. 20.3 = 20 weeks and three days = 20*7+3 = 143 days)

Is that a way to convert those data in days?

10 ==> 70

20.3 ==> 143

38.6 ==> 272

Cheers,

Jess

Re: Converting from weeks to days

JasonDiVirgilio — Thu, 02 May 2013 13:59:23 GMT

data test;
   week_days=38.6;
   days=10*(week_days-floor(week_days));
   weeks=floor(week_days);
   num_days=(weeks*7)+days;
run;

Re: Converting from weeks to days

Peter_C — Thu, 02 May 2013 14:14:46 GMT

Sounds like a goid reason to learn about compiling user-defined functions with PROC FCMP

Unless there is a base-7 counting solution like for octal and binary

peterC

Re: Converting from weeks to days

RickAster — Thu, 02 May 2013 14:18:36 GMT

I would suggest:

days =

7*int(weeks_days)

+ int(10*mod(weeks_days, 1));

Re: Converting from weeks to days

Ksharp — Thu, 02 May 2013 14:20:36 GMT

data _null_;
a=10; aa=int(a)*7 + mod(a*10,10);
put a= aa=;
a=20.3; aa=int(a)*7 + mod(a*10,10);
put a= aa=;
a=38.6; aa=int(a)*7 + mod(a*10,10);
put a= aa=;
run;

Ksharp

Re: Converting from weeks to days

P_Marty — Thu, 02 May 2013 15:50:36 GMT

NumOfDays = (7*int(Week_Days)) + (10*(Week_Days - int(Week_Days)));