topic Re: Creating numeric months for multiple years. in SAS Visual Analytics

Creating numeric months for multiple years.

ASHISH2525 — Mon, 06 May 2019 05:00:19 GMT

Hi All,

I have created numeric months for reporting so that using rank i will fixed desired output.

But problem is that treat as function only create 12 months for two year 2018 & 2019. means Dec-18 is 12 and Dec-19 is also 12. i wanted to have it like Dec 18 should be Jan 19 should be 13 and so on.

Let me know is there workaround for this.

Regards,

Ashish

Re: Creating numeric months for multiple years.

Jagadishkatam — Mon, 06 May 2019 07:56:43 GMT

data have;
input years$;
date=input(cats('01-',years),anydtdte.);
yr=year(input(cats('01-',years),anydtdte.));
month=month(input(cats('01-',years),anydtdte.));
lagmonth=lag(month);
cards;
Aug-18
Sep-18
Oct-18
Nov-18
Dec-18
Jan-19
Feb-19
Mar-19
Apr-19
May-19
Jun-19
Jul-19
Aug-19
Sep-19
Oct-19
Nov-19
Dec-19
;

proc sort data=have;
by yr date ;
run;

data want;
set have;
by yr date;
retain count;
if first.yr then count=lagmonth;
month2=coalesce(count+month,month);
drop month yr count lagmonth date;
run;

Re: Creating numeric months for multiple years.

ASHISH2525 — Mon, 06 May 2019 08:19:23 GMT

Thank you Jag ! I was looking for the same.

Regards,

Ashish

Re: Creating numeric months for multiple years.

novinosrin — Mon, 06 May 2019 10:33:10 GMT

Hi @ASHISH2525 Since you wrote that you have continuous data and the starting month value that you have already created.

if _n_=1 then continuous_month=month;
else continuous_month+1

is all you need.

Re: Creating numeric months for multiple years.

ccaulkins9 — Tue, 07 May 2019 21:22:27 GMT

if _n_=1 then continuous_month=month;
else continuous_month+1

Help! I'm being overtaken by hackers, copycat hacker no less -