topic Re: Get Complete Month list in SAS Programming

Get Complete Month list

sivastat08 — Wed, 17 Apr 2019 13:12:03 GMT

Hi Sir,

I need Complete Current month days list,whenever its running it should list only Current month Complete days.

i tried this code but i'm not getting

%LET DATE=%SYSFUNC(TODAY(),DATE9.);
%PUT &DATE;

%LET BugnMon = %SYSFUNC(INTNX(MONTH,%SYSFUNC(TODAY()),0,B),Date9.);
%PUT &BugnMon;
%LET EndMon = %SYSFUNC(INTNX(MONTH,%SYSFUNC(TODAY()),0,E),Date9.);
%PUT &EndMon;

%LET start_date=(intnx('month',today(),0,'B'),DATE9.);
%PUT &start_date;
%LET end_date=(intnx('month',today(),0,'E'),DATE9.);
%PUT &end_date;

%let start_date= &start_date;

%let end_date=&end_date;

Like Current month is APR and Today is 17APR2019 .Output should list from 1APR2019 to 30APR2019

Can any one help on this.

Thanks,

Siva

Re: Get Complete Month list

novinosrin — Wed, 17 Apr 2019 13:14:44 GMT

HI @sivastat08

Your

%LET start_date=(intnx('month',today(),0,'B'),DATE9.);
%PUT &start_date;
%LET end_date=(intnx('month',today(),0,'E'),DATE9.);
%PUT &end_date;

%let start_date= &start_date;

%let end_date=&end_date;

is very neat. Are you looking to loop from start_date to end_date?

Re: Get Complete Month list

PeterClemmensen — Wed, 17 Apr 2019 13:16:33 GMT

Use data step logic like below and work from there.

data test(keep=date);
   firstday=intnx('month', today(), 0, 'b');
   lastday=intnx('month', today(), 0, 'e');

   do date=firstday to lastday;
      output;
   end;

   format date date9.;
run;

Re: Get Complete Month list

sivastat08 — Wed, 17 Apr 2019 13:17:08 GMT

Yes Sir,Output Should list Current month days

Re: Get Complete Month list

novinosrin — Wed, 17 Apr 2019 13:18:01 GMT

Do you want a list to be written to log or an output as a sas dataset?

Re: Get Complete Month list

sivastat08 — Wed, 17 Apr 2019 13:19:27 GMT

OUTPUT SIR.

Re: Get Complete Month list

sivastat08 — Wed, 17 Apr 2019 13:21:12 GMT

Thanks For The Answer Sir

Re: Get Complete Month list

novinosrin — Wed, 17 Apr 2019 13:22:25 GMT

Ok Now I understand from the accepted solution that you basically wanted a dataset output. I was confused whether you wanted an output as a list file or an output written to the log. Never mind, it's all good

Re: Get Complete Month list

sivastat08 — Wed, 17 Apr 2019 13:24:04 GMT

Thank you very much Sir