Using Dates Functions find days in the month prior to current month

[sambasiva_ravuri_tcs_com]

Dear All,

I would like to write a SAS program to get the current date and determine number of days in the month prior to current month.

Find difference in days, months, and years between. Is it possible using SAS ?

Thanks a lot for help.

Regards,

S Ravuri.

[Keith]

This looks a very similar question to one I answered earlier today.  Check out my reply and the link I included, they should give you some ideas on how to do this.

http://communities.sas.com/message/119624#119624

[sambasiva_ravuri_tcs_com]

Thanks Keith for the reply.

Am getting the values for difference in days, months, and years in between.

Can you please help me how can we get the no.of days for prior month to the current month.

Thanks a lot in advance for help.

Regards,

S Ravuri.

[Keith]

Just use the INTNX function as below.  This will subtract the 1st of the previous month from the 1st of the current month.

data num_days;

a=today();

prev_month=intnx('month',a,0)-intnx('month',a,-1);

run;

[sambasiva_ravuri_tcs_com · Accepted solution]

Keith,

Code worked Well. Thanks a lot and appreciate for your great help.

Regards,

S Ravuri.