cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BookmarkSubscribeRSS Feed
Fox_3
Calcite | Level 5 Fox_3
Calcite | Level 5

Date Issue

Posted 12-08-2014 07:40 AM (2458 views)

Friends i need to show the Business Calendre for example March1st-5th April as March month.

Regards

Pradeep Kandpal

0 Likes
Reply
3 REPLIES 3
DBailey
Lapis Lazuli | Level 10 DBailey
Lapis Lazuli | Level 10

Re: Date Issue

Posted 12-08-2014 09:21 AM (2348 views)  |   In reply to Fox_3

What's the rule that sets the business month?

0 Likes
Reply
LinusH
Tourmaline | Level 20 LinusH
Tourmaline | Level 20

Re: Date Issue

Posted 12-08-2014 09:22 AM (2348 views)  |   In reply to Fox_3

Is this a one time requirement or do you need a permanent solution?

Temporary: just test with if/case logic

Permanent: get hold of/create a calendar file/table which maps dates to business month.

Data never sleeps
0 Likes
Reply
TomKari
Onyx | Level 15 TomKari
Onyx | Level 15

Re: Date Issue

Posted 12-08-2014 01:47 PM (2348 views)  |   In reply to LinusH

The INTNX / INTCK subroutines are also fantastic for this kind of calculation of dates...they saved my butt in my current project.

Tom

0 Likes
Reply

CFC_SAS_Communities_400x225.jpg

Call for content now open!

It's your turn to help shape SAS Innovate 2027. Share your expertise and inspire the SAS community.

Submit your proposal →

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

Watch Creating Custom Steps in SAS Studio on YouTube

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • ‎12-08-2014 07:40 AM
  • 2459 views
  • 0 likes
  • 4 in conversation