<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:gd="http://schemas.google.com/g/2005"><id>tag:blogger.com,1999:blog-7958828565254404797.post2379718042583027006..comments</id><updated>2024-12-13T03:11:35.450-08:00</updated><title type='text'>Comments on ListenData: SAS : INTNX Function with Examples</title><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='https://www.listendata.com/feeds/comments/default'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2017/01/sas-intnx.html'/><link rel="hub" href="http://pubsubhubbub.appspot.com/"/><author><name>Deepanshu Bhalla</name><uri>http://www.blogger.com/profile/09802839558125192674</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXm_iOrXFR9Ls-mjtOci4qd1m1V1TXkkWJINuMy84-Axo5pNS6CG7oKwR7hfHHI3tB1yuz8W_qo9HK2Cw5fHfe_4cL_2DCf_LyoK9LMLicZojbNYgypIP-RXNsw1GsVhk/s100/pic.jpg'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>23</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-5327433656375184508</id><published>2023-06-19T04:10:01.570-07:00</published><updated>2023-06-19T04:10:01.570-07:00</updated><title type='text'>2023-06
2023
2023-04
2023-08-12
2023-0
2023-09
.
I...</title><content type='html'>2023-06<br />2023<br />2023-04<br />2023-08-12<br />2023-0<br />2023-09<br />.<br />If the month is=/GT than 6 date should be 31, if the month is LT 5 date should be first of the month, if date is &#39;.&#39; the it should be 2022-12-31, how can we get the answer by using intnx function</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/5327433656375184508'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/5327433656375184508'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2017/01/sas-intnx.html?showComment=1687173001570#c5327433656375184508' title=''/><author><name>Miheeka</name><uri>https://www.blogger.com/profile/13513849928063130203</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2017/01/sas-intnx.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2379718042583027006' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2379718042583027006' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1706580864"/><gd:extendedProperty name="blogger.displayTime" value="June 19, 2023 at 4:10 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-7283498543353854522</id><published>2021-07-08T19:08:02.570-07:00</published><updated>2021-07-08T19:08:02.570-07:00</updated><title type='text'>Hi Himanshu,

In 5th point adjustment of interval ...</title><content type='html'>Hi Himanshu,<br /><br />In 5th point adjustment of interval isn&#39;t it intnx function, it&#39;s updated as intck function.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/7283498543353854522'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/7283498543353854522'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2017/01/sas-intnx.html?showComment=1625796482570#c7283498543353854522' title=''/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2017/01/sas-intnx.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2379718042583027006' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2379718042583027006' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="July 8, 2021 at 7:08 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-1648567727181020231</id><published>2021-01-02T12:58:59.512-08:00</published><updated>2021-01-02T12:58:59.512-08:00</updated><title type='text'>Obs Date Scd_dep arr_ti...</title><content type='html'>Obs Date Scd_dep arr_time delay<br /><br />6210 12/03/2013 8:35:00 PM 8:53:00 PM 18 <br />6211 11/11/2013 2:59:00 PM 2:56:00 PM -3 <br />6212 12/19/2013 8:27:00 PM 8:22:00 PM -5 <br />6213 11/12/2013 8:30:00 AM 10:06:00 AM 96 <br />6214 12/21/2013 2:59:00 PM 3:27:00 PM 28 <br />6215 12/10/2013 8:35:00 PM 8:31:00 PM -4 <br />6216 02/15/2013 3:05:00 PM 3:03:00 PM -2 <br />6217 12/05/2013 8:35:00 PM 12:27:00 AM -1208 ( incorrect)<br /><br />how to get correct answer for obs no. 6217 ( i am using intck) .How to calculate date if time changes from 23:59 to 00:40 ( next day ).<br /></content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/1648567727181020231'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/1648567727181020231'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2017/01/sas-intnx.html?showComment=1609621139512#c1648567727181020231' title=''/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2017/01/sas-intnx.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2379718042583027006' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2379718042583027006' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="January 2, 2021 at 12:58 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-5891764424949176604</id><published>2020-10-15T23:57:17.287-07:00</published><updated>2020-10-15T23:57:17.287-07:00</updated><title type='text'>Hlo,u can use the function intck.then the output ...</title><content type='html'>Hlo,u can use the function intck.then the output comes wrong.<br />u can use intnx function then perfectly u got the o/p.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/5891764424949176604'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/5891764424949176604'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2017/01/sas-intnx.html?showComment=1602831437287#c5891764424949176604' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/8022724310375507211'/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/16054552801247046671</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2017/01/sas-intnx.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2379718042583027006' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2379718042583027006' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1151765666"/><gd:extendedProperty name="blogger.displayTime" value="October 15, 2020 at 11:57 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-1880090469889581227</id><published>2020-03-20T11:40:23.292-07:00</published><updated>2020-03-20T11:40:23.292-07:00</updated><title type='text'>I want more logics in sas</title><content type='html'>I want more logics in sas</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/1880090469889581227'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/1880090469889581227'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2017/01/sas-intnx.html?showComment=1584729623292#c1880090469889581227' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/04032513076340763510</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2017/01/sas-intnx.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2379718042583027006' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2379718042583027006' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-124940641"/><gd:extendedProperty name="blogger.displayTime" value="March 20, 2020 at 11:40 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-708296136299858048</id><published>2020-03-20T11:39:46.374-07:00</published><updated>2020-03-20T11:39:46.374-07:00</updated><title type='text'>Sas</title><content type='html'>Sas</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/708296136299858048'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/708296136299858048'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2017/01/sas-intnx.html?showComment=1584729586374#c708296136299858048' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/7416322941801828324'/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/04032513076340763510</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2017/01/sas-intnx.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2379718042583027006' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2379718042583027006' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-124940641"/><gd:extendedProperty name="blogger.displayTime" value="March 20, 2020 at 11:39 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-7416322941801828324</id><published>2020-03-20T11:39:26.662-07:00</published><updated>2020-03-20T11:39:26.662-07:00</updated><title type='text'>I want more logics in sad </title><content type='html'>I want more logics in sad </content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/7416322941801828324'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/7416322941801828324'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2017/01/sas-intnx.html?showComment=1584729566662#c7416322941801828324' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/04032513076340763510</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2017/01/sas-intnx.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2379718042583027006' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2379718042583027006' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-124940641"/><gd:extendedProperty name="blogger.displayTime" value="March 20, 2020 at 11:39 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-6723034702000148402</id><published>2019-06-10T14:23:44.900-07:00</published><updated>2019-06-10T14:23:44.900-07:00</updated><title type='text'>You can use below code

Data temp;

Mydate=&quot;&...</title><content type='html'>You can use below code<br /><br />Data temp;<br /><br />Mydate=&quot;&amp;SYSDATE&quot;d;<br />Nxt2ndstdy=intnx(&#39;week.7&#39;,intnx(&#39;month&#39;,Mydate,1),2);<br /><br />Format Mydate Nxt2ndstdy date9.;<br /><br />Proc print data = temp;<br /><br />Run;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/6723034702000148402'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/6723034702000148402'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2017/01/sas-intnx.html?showComment=1560201824900#c6723034702000148402' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/5640179973357822449'/><author><name>Rajendra</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2017/01/sas-intnx.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2379718042583027006' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2379718042583027006' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="June 10, 2019 at 2:23 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-406222042008718655</id><published>2019-06-10T11:47:57.645-07:00</published><updated>2019-06-10T11:47:57.645-07:00</updated><title type='text'>u mistakenly used intck here.</title><content type='html'>u mistakenly used intck here.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/406222042008718655'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/406222042008718655'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2017/01/sas-intnx.html?showComment=1560192477645#c406222042008718655' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/8022724310375507211'/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/13126892196350959377</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2017/01/sas-intnx.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2379718042583027006' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2379718042583027006' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-167028150"/><gd:extendedProperty name="blogger.displayTime" value="June 10, 2019 at 11:47 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-5640179973357822449</id><published>2019-02-09T23:47:54.709-08:00</published><updated>2019-02-09T23:47:54.709-08:00</updated><title type='text'>Hi
How to find out next month second Saturday usin...</title><content type='html'>Hi<br />How to find out next month second Saturday using today&#39;s date in SAS<br /></content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/5640179973357822449'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/5640179973357822449'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2017/01/sas-intnx.html?showComment=1549784874709#c5640179973357822449' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/12106451732270875849</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2017/01/sas-intnx.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2379718042583027006' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2379718042583027006' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1833712107"/><gd:extendedProperty name="blogger.displayTime" value="February 9, 2019 at 11:47 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-8022724310375507211</id><published>2019-02-05T08:22:43.230-08:00</published><updated>2019-02-05T08:22:43.230-08:00</updated><title type='text'>HEY: when i m running the code its showing like th...</title><content type='html'>HEY: when i m running the code its showing like this.<br />code:date temp;<br />mydate=&#39;05feb2018&#39;d;<br />nextsunday=intck(&#39;week&#39;,mydate,1)<br />format mydate nextsunday date9.;<br />run;<br /><br />output:18sep1951.<br /><br />this is the output coming please help me out.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/8022724310375507211'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/8022724310375507211'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2017/01/sas-intnx.html?showComment=1549383763230#c8022724310375507211' title=''/><author><name>Shivangi</name><uri>https://www.blogger.com/profile/06982284823277741012</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='24' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg3gjH2Pod_kRGYoIfU0lhWFY_ykmXkj4L_pQdKhv8TceucGyr8zvwy6eQeZQOjd1ic_d93B7lDDJgbYwsNTrhOxXFSajFzTR4p-Ggn3y9A3tkgv4mK853g7u0WgXmiYQ/s113/IMG-20180126-WA0043.jpg'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2017/01/sas-intnx.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2379718042583027006' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2379718042583027006' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-674116943"/><gd:extendedProperty name="blogger.displayTime" value="February 5, 2019 at 8:22 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-8203699586386591278</id><published>2019-02-02T23:05:27.088-08:00</published><updated>2019-02-02T23:05:27.088-08:00</updated><title type='text'>5. Adjustment within the Interval

This program ex...</title><content type='html'>5. Adjustment within the Interval<br /><br />This program explains how INTCK function adjusts / align dates within the interval specified.<br /><br />in that we are using intnx ...you have wrote intck thats the mistake ....<br />website is really fantastic ...</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/8203699586386591278'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/8203699586386591278'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2017/01/sas-intnx.html?showComment=1549177527088#c8203699586386591278' title=''/><author><name>Sharath reddy</name><uri>https://www.blogger.com/profile/15483254502864267286</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2017/01/sas-intnx.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2379718042583027006' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2379718042583027006' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-550378969"/><gd:extendedProperty name="blogger.displayTime" value="February 2, 2019 at 11:05 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-8322765678515965676</id><published>2018-11-09T23:43:37.968-08:00</published><updated>2018-11-09T23:43:37.968-08:00</updated><title type='text'>Thank you for stopping by my blog and answering qu...</title><content type='html'>Thank you for stopping by my blog and answering questions. Cheers! </content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/8322765678515965676'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/8322765678515965676'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2017/01/sas-intnx.html?showComment=1541835817968#c8322765678515965676' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/6802238684104951938'/><author><name>Deepanshu Bhalla</name><uri>https://www.blogger.com/profile/09802839558125192674</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXm_iOrXFR9Ls-mjtOci4qd1m1V1TXkkWJINuMy84-Axo5pNS6CG7oKwR7hfHHI3tB1yuz8W_qo9HK2Cw5fHfe_4cL_2DCf_LyoK9LMLicZojbNYgypIP-RXNsw1GsVhk/s100/pic.jpg'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2017/01/sas-intnx.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2379718042583027006' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2379718042583027006' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-966036103"/><gd:extendedProperty name="blogger.displayTime" value="November 9, 2018 at 11:43 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-6802238684104951938</id><published>2018-11-09T08:43:16.960-08:00</published><updated>2018-11-09T08:43:16.960-08:00</updated><title type='text'>This is a fantastic tutorial. Thank you for provid...</title><content type='html'>This is a fantastic tutorial. Thank you for providing it! I am troubleshooting another developer&#39;s code that contains this function, and this information has been very helpful. Hope it&#39;s OK I answered a couple of questions above! I couldn&#39;t resist distracting myself from my current work to try out this function. :-)</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/6802238684104951938'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/6802238684104951938'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2017/01/sas-intnx.html?showComment=1541781796960#c6802238684104951938' title=''/><author><name>Kate</name><uri>https://www.blogger.com/profile/05961465728584782293</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2017/01/sas-intnx.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2379718042583027006' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2379718042583027006' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-843042715"/><gd:extendedProperty name="blogger.displayTime" value="November 9, 2018 at 8:43 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-4322667078972987824</id><published>2018-11-09T08:39:50.367-08:00</published><updated>2018-11-09T08:39:50.367-08:00</updated><title type='text'>This will do it:

data test;
sunday = &#39;18MAR20...</title><content type='html'>This will do it:<br /><br />data test;<br />sunday = &#39;18MAR2018&#39;d;<br />tues = intnx(&#39;week.3&#39;,sunday,1);<br />format sunday tues date9.;<br />proc print data=test; run;<br /><br />Your current code finds the beginning of the week 2 weeks from now. The code I suggest gives you the beginning of the week 1 week from now, where each week begins on a Tuesday (day 3).</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/4322667078972987824'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/4322667078972987824'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2017/01/sas-intnx.html?showComment=1541781590367#c4322667078972987824' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/615507869599107884'/><author><name>Kate</name><uri>https://www.blogger.com/profile/05961465728584782293</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2017/01/sas-intnx.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2379718042583027006' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2379718042583027006' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-843042715"/><gd:extendedProperty name="blogger.displayTime" value="November 9, 2018 at 8:39 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-8323465540846687014</id><published>2018-11-09T08:34:16.692-08:00</published><updated>2018-11-09T08:34:16.692-08:00</updated><title type='text'>Adding &#39;s&#39; as the 4th parameter will accom...</title><content type='html'>Adding &#39;s&#39; as the 4th parameter will accomplish this.<br /><br />data test;<br />datetime = &#39;29JAN2017:08:34:00&#39;dt;<br />plus1hour = intnx(&#39;hour&#39;,datetime,1,&#39;s&#39;);<br />format datetime plus1hour datetime20.;<br />proc print data=test; run;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/8323465540846687014'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/8323465540846687014'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2017/01/sas-intnx.html?showComment=1541781256692#c8323465540846687014' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/5418889938218349735'/><author><name>Kate</name><uri>https://www.blogger.com/profile/05961465728584782293</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2017/01/sas-intnx.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2379718042583027006' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2379718042583027006' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-843042715"/><gd:extendedProperty name="blogger.displayTime" value="November 9, 2018 at 8:34 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-615507869599107884</id><published>2018-05-22T23:12:12.768-07:00</published><updated>2018-05-22T23:12:12.768-07:00</updated><title type='text'>Hi deepanshu,
Thanks a lot for this info.However i...</title><content type='html'>Hi deepanshu,<br />Thanks a lot for this info.However i have a question , i am trying to run a code that gives me next tuesday ,For 18Mar 2018 is sunday and i want to get 20 March as my answer.I am using tues = intnx (&#39;week&#39;,sunday,2); and i am getting 1 April as answer . Any Advise </content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/615507869599107884'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/615507869599107884'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2017/01/sas-intnx.html?showComment=1527055932768#c615507869599107884' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/07001155667207010651</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2017/01/sas-intnx.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2379718042583027006' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2379718042583027006' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1737653052"/><gd:extendedProperty name="blogger.displayTime" value="May 22, 2018 at 11:12 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-7729379187542762781</id><published>2017-07-26T02:28:53.817-07:00</published><updated>2017-07-26T02:28:53.817-07:00</updated><title type='text'>Thank you for this high quality introduction to th...</title><content type='html'>Thank you for this high quality introduction to the INTNX function with great examples that are nicely explained and very readable :o) </content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/7729379187542762781'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/7729379187542762781'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2017/01/sas-intnx.html?showComment=1501061333817#c7729379187542762781' title=''/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2017/01/sas-intnx.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2379718042583027006' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2379718042583027006' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="July 26, 2017 at 2:28 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-5418889938218349735</id><published>2017-06-07T18:43:25.558-07:00</published><updated>2017-06-07T18:43:25.558-07:00</updated><title type='text'>Hi Deepanshu,
Under &quot;Datetime Formats&quot; h...</title><content type='html'>Hi Deepanshu,<br />Under &quot;Datetime Formats&quot; heading , when we add hour to the time , it should have been 9:34:00.ideally. How do we achieve this ?</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/5418889938218349735'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/5418889938218349735'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2017/01/sas-intnx.html?showComment=1496886205558#c5418889938218349735' title=''/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2017/01/sas-intnx.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2379718042583027006' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2379718042583027006' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="June 7, 2017 at 6:43 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-4627794774278373982</id><published>2017-06-02T02:22:38.305-07:00</published><updated>2017-06-02T02:22:38.305-07:00</updated><title type='text'>how to extract last 15 days transaction date wise ...</title><content type='html'>how to extract last 15 days transaction date wise using this.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/4627794774278373982'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/4627794774278373982'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2017/01/sas-intnx.html?showComment=1496395358305#c4627794774278373982' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/12571346063006058230</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2017/01/sas-intnx.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2379718042583027006' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2379718042583027006' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-261276292"/><gd:extendedProperty name="blogger.displayTime" value="June 2, 2017 at 2:22 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-5300275274496403762</id><published>2017-03-26T01:40:01.149-07:00</published><updated>2017-03-26T01:40:01.149-07:00</updated><title type='text'>It works fine for &#39;09JAN2017&#39; which is mon...</title><content type='html'>It works fine for &#39;09JAN2017&#39; which is monday. I guess you meant to say &#39;10JAN2017&#39;. I updated the code. Thanks for pointing it out. Cheers!</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/5300275274496403762'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/5300275274496403762'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2017/01/sas-intnx.html?showComment=1490517601149#c5300275274496403762' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/7294285893273319381'/><author><name>Deepanshu Bhalla</name><uri>https://www.blogger.com/profile/09802839558125192674</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXm_iOrXFR9Ls-mjtOci4qd1m1V1TXkkWJINuMy84-Axo5pNS6CG7oKwR7hfHHI3tB1yuz8W_qo9HK2Cw5fHfe_4cL_2DCf_LyoK9LMLicZojbNYgypIP-RXNsw1GsVhk/s100/pic.jpg'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2017/01/sas-intnx.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2379718042583027006' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2379718042583027006' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-966036103"/><gd:extendedProperty name="blogger.displayTime" value="March 26, 2017 at 1:40 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-7294285893273319381</id><published>2017-03-25T14:40:46.365-07:00</published><updated>2017-03-25T14:40:46.365-07:00</updated><title type='text'>Don&#39;t you think that &quot;4. When was Last Tu...</title><content type='html'>Don&#39;t you think that &quot;4. When was Last Tuesday?&quot; will give the current week&#39;s Tuesday instead of &quot;Last Tuesday&quot;, if you give &quot;09JAN2017&quot; in mydate</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/7294285893273319381'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/7294285893273319381'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2017/01/sas-intnx.html?showComment=1490478046365#c7294285893273319381' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/06377626589861778887</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2017/01/sas-intnx.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2379718042583027006' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2379718042583027006' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1752764298"/><gd:extendedProperty name="blogger.displayTime" value="March 25, 2017 at 2:40 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-7930007532093015378</id><published>2017-02-03T11:42:35.683-08:00</published><updated>2017-02-03T11:42:35.683-08:00</updated><title type='text'>the only issue with intnx and intck is that its ha...</title><content type='html'>the only issue with intnx and intck is that its hard to distinguish to make a short form as other function in sas can be remembered easily. </content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/7930007532093015378'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/2379718042583027006/comments/default/7930007532093015378'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2017/01/sas-intnx.html?showComment=1486150955683#c7930007532093015378' title=''/><author><name>Arun</name><uri>https://www.blogger.com/profile/01957551518340210738</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2017/01/sas-intnx.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-2379718042583027006' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/2379718042583027006' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1194763757"/><gd:extendedProperty name="blogger.displayTime" value="February 3, 2017 at 11:42 AM"/></entry></feed>