topic Get Year and Month together as Value not as format in SAS Programming

Get Year and Month together as Value not as format

rajat051984 — Thu, 26 Feb 2015 22:40:02 GMT

I have to select values from a table based on months. I have to select last 3 months data. Have already tried the following -

data _null_;

set a(obs=1);

prev_2_mon_dt = intnx('month',date(),-2,'beginning');

prev_2_mon = year(prev_2_mon_dt)*100 + month(prev_2_mon_dt);

call symput('pr2mn',prev_2_mon);

run;

data c;

set d;

if ordermth in (%eval(&pr2mn.),%eval(&pr2mn. + 1),%eval(&pr2mn. + 2));

run;

So it gives numebrs like - 201411,201412, 201413 etc..

Is there any other way to handle this issue ?

Re: Get Year and Month together as Value not as format

art297 — Thu, 26 Feb 2015 22:50:23 GMT

What do your ordermth values look like?

Re: Get Year and Month together as Value not as format

rajat051984 — Thu, 26 Feb 2015 23:04:51 GMT

They look like - 201410,201411, 201412,201501 etc..

They are calculated each time with the formula I used above. Year*100 + month.

It is calcualated from a timestamp but I don't have that timestamp information in the input file anymore..

Re: Get Year and Month together as Value not as format

art297 — Thu, 26 Feb 2015 23:11:44 GMT

Your formula would produce something like 20152 rather than 201502.

I'd use something like:

data _null_;

prev_2_mon_dt = intnx('month',date(),-2,'beginning');

call symput('pr2mn',put(prev_2_mon_dt,yymmn6.));

call symput('curmn',put(date(),yymmn6.));

run;

data d;

input ordermth;

cards;

201410

201411

201412

201501

201502

201503

201504

201505

201506

;

data c;

set d;

if &pr2mn. le ordermth le &curmn.;

run;

Re: Get Year and Month together as Value not as format

rajat051984 — Thu, 26 Feb 2015 23:19:29 GMT

Thanks!!