Solved: How take data according to date less than 3 months - SAS Support Communities

🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

Obsidian | Level 7

Obsidian | Level 7

How take data according to date less than 3 months

Posted 02-01-2017 12:50 AM (1695 views)

I having data , where variable name datenew where condition is " less than 3 months " . So i need on data which has less than 3 months.

1 ACCEPTED SOLUTION

Accepted Solutions

Super User

Super User

Re: How take data according to date less than 3 months

Posted 02-01-2017 01:35 AM (2010 views) | In reply to Badshaah

Look at INTCK and INTNX functions.

If INTCK (....) < 3;

View solution in original post

2 REPLIES 2

PROC Star

Re: How take data according to date less than 3 months

Posted 02-01-2017 01:12 AM (1689 views) | In reply to Badshaah

Example data set please. Example output also.

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------

Super User

Super User

Re: How take data according to date less than 3 months

Posted 02-01-2017 01:35 AM (2011 views) | In reply to Badshaah

Look at INTCK and INTNX functions.

If INTCK (....) < 3;

April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!