topic Using Dates Functions find days in the month prior to current month in SAS Programming

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

sambasiva_ravuri_tcs_com — Thu, 15 Mar 2012 14:00:01 GMT

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.

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

Keith — Thu, 15 Mar 2012 14:10:55 GMT

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

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

sambasiva_ravuri_tcs_com — Thu, 15 Mar 2012 14:22:38 GMT

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.

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

Keith — Thu, 15 Mar 2012 14:31:42 GMT

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;

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

sambasiva_ravuri_tcs_com — Fri, 16 Mar 2012 06:17:55 GMT

Keith,

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

Regards,

S Ravuri.