Coverting variable months to years

Reply
anonymous_user
Posts: 0

Coverting variable months to years

Hi,

I have a variable 'Remaining months' but I want this in a year format within proc sql but unsure on how to do this, any ideas please?

example -

Remaining months 60

I want to display 5 years

Super User
Super User
Posts: 9,599

Re: Coverting variable months to years

Posted in reply to anonymous_user

Hi,

Simply divide by 12.

data have;

     remaining_months=60; output;

run;

proc sql;

     create table WANT as

     select     REMAINING_MONTHS,

                    strip(put(REMAINING_MONTHS / 12,best.))||" years" as YEARS

     from       HAVE;

quit;

anonymous_user
Posts: 0

Re: Coverting variable months to years

Posted in reply to anonymous_user

Thanks,

How do I round it to display 2 years instead of  2.1666666667 years

Super User
Super User
Posts: 9,599

Re: Coverting variable months to years

Posted in reply to anonymous_user

With the round function?  Alternatively the floor (probably the best one for your scenario) or ceil functions depending on scenario.

To add, any SAS function can be used in a proc sql as long as you are not using pass-through (i.e. sending the sql to a database) as the DB wouldn't know about the SAS functions).  In general though there are several of the functions which are present in both SAS and native SQL, round being one of them, though slightly different syntax.

http://www.w3schools.com/sql/sql_func_round.asp

SQL Functions

Trusted Advisor
Posts: 3,215

Re: Coverting variable months to years

Posted in reply to anonymous_user

Using a 5.2 format for years instead of best.   - The best in this case is not your best. The best is showing as much as possible could make sense. 

---->-- ja karman --<-----
Regular Contributor
Posts: 233

Re: Coverting variable months to years

Posted in reply to anonymous_user

DATA HAVE;
REMAINING_MONTHS=62;
OUTPUT;
RUN;

PROC SQL;
CREATE TABLE WANT AS
  SELECT     REMAINING_MONTHS,CATS((REMAINING_MONTHS / 12), "YEARS") AS YEARS FROM HAVE;
QUIT;

PROC PRINT;
RUN;

Capture.JPG

Ask a Question
Discussion stats
  • 5 replies
  • 245 views
  • 0 likes
  • 4 in conversation