DATA Step, Macro, Functions and more

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

Accepted Solution Solved
Reply
Contributor
Posts: 42
Accepted Solution

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

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.


Accepted Solutions
Solution
‎03-16-2012 02:17 AM
Contributor
Posts: 42

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

Posted in reply to sambasiva_ravuri_tcs_com

Keith,

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

Regards,

S Ravuri.

View solution in original post


All Replies
Regular Contributor
Posts: 151

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

Posted in reply to sambasiva_ravuri_tcs_com

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

Contributor
Posts: 42

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

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.

Regular Contributor
Posts: 151

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

Posted in reply to sambasiva_ravuri_tcs_com

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;

Solution
‎03-16-2012 02:17 AM
Contributor
Posts: 42

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

Posted in reply to sambasiva_ravuri_tcs_com

Keith,

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

Regards,

S Ravuri.

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 208 views
  • 0 likes
  • 2 in conversation