<?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.post3593224246943694340..comments</id><updated>2024-12-13T03:11:35.450-08:00</updated><title type='text'>Comments on ListenData: How to Convert Numeric to Date Variables in SAS</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/3593224246943694340/comments/default'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2016/07/sas-converting-number-format-to-date.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>11</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-2680316173083243224</id><published>2022-01-26T14:44:25.080-08:00</published><updated>2022-01-26T14:44:25.080-08:00</updated><title type='text'>HI, I think we can&#39;t read data in sas with mis...</title><content type='html'>HI, I think we can&#39;t read data in sas with missing of month and date values. Please let me know if we can read data like this &quot;2019/un/un&quot; in sas.<br /><br />But if we have mmddyy then we can use year() function to pull the year value. </content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/3593224246943694340/comments/default/2680316173083243224'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/3593224246943694340/comments/default/2680316173083243224'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2016/07/sas-converting-number-format-to-date.html?showComment=1643237065080#c2680316173083243224' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/3593224246943694340/comments/default/5443726473610992743'/><author><name>ravi</name><uri>https://www.blogger.com/profile/12051180291065695712</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/AVvXsEitkb3x-_iayRoHpGT6QM7UByzjnXhmAnx318yG2AI4U2GSO9J8Kq6XZ4APG1fqKtpjmeOkFLgIegLMqSWoP6pdn_tmVLP0d9AFvLPl47twUhrgDpNtxUx3GdQcSxKSzFw/s220/me.jpg'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2016/07/sas-converting-number-format-to-date.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-3593224246943694340' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/3593224246943694340' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-2100201656"/><gd:extendedProperty name="blogger.displayTime" value="January 26, 2022 at 2:44 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-5443726473610992743</id><published>2021-02-23T03:14:39.710-08:00</published><updated>2021-02-23T03:14:39.710-08:00</updated><title type='text'>Hi if date is in 2019/un/un this format.how to get...</title><content type='html'>Hi if date is in 2019/un/un this format.how to get 2019 asoutput</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/3593224246943694340/comments/default/5443726473610992743'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/3593224246943694340/comments/default/5443726473610992743'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2016/07/sas-converting-number-format-to-date.html?showComment=1614078879710#c5443726473610992743' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/05971111034610996337</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/2016/07/sas-converting-number-format-to-date.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-3593224246943694340' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/3593224246943694340' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-429030178"/><gd:extendedProperty name="blogger.displayTime" value="February 23, 2021 at 3:14 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-3691311180746861309</id><published>2021-02-22T04:40:49.750-08:00</published><updated>2021-02-22T04:40:49.750-08:00</updated><title type='text'>ANYDTDTEw. informat is more flexible (and latest o...</title><content type='html'>ANYDTDTEw. informat is more flexible (and latest one) than older informat datew. so your way is better than mine :-) We convert number format to date to make it more readable as input value is date not a numeric value.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/3593224246943694340/comments/default/3691311180746861309'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/3593224246943694340/comments/default/3691311180746861309'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2016/07/sas-converting-number-format-to-date.html?showComment=1613997649750#c3691311180746861309' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/3593224246943694340/comments/default/6958080756201742018'/><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/2016/07/sas-converting-number-format-to-date.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-3593224246943694340' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/3593224246943694340' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-966036103"/><gd:extendedProperty name="blogger.displayTime" value="February 22, 2021 at 4:40 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-6958080756201742018</id><published>2021-02-22T03:00:42.387-08:00</published><updated>2021-02-22T03:00:42.387-08:00</updated><title type='text'>Thank you for your help in this topic :)
In your ...</title><content type='html'>Thank you for your help in this topic :)<br />In your example i use ANYDTDTE. informat for reading data.<br />My way has pitfalls? Or why did you choose to convert data?<br />I am new and want to know all secrets :)<br /><br /><br />data temp;<br />input date: anydtdte.;<br />format date yymmdd10.;<br />cards;<br />20160514<br />19990505<br />20131104<br />20110724<br />;<br />run;<br /></content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/3593224246943694340/comments/default/6958080756201742018'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/3593224246943694340/comments/default/6958080756201742018'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2016/07/sas-converting-number-format-to-date.html?showComment=1613991642387#c6958080756201742018' title=''/><author><name>kate</name><uri>https://www.blogger.com/profile/14234847808779710242</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/AVvXsEh7KnGn9QLsMfim2frdOfC3cY_5Zqo_Gm7xOSQB4jfYwNXq7Xfto2G3tdZweX98LgGt4rWRj4XRm7nHLgNi1zUV4Knw155D32BmVZntzgd0gnPE_KE1cWlz_eu8mWb-7jM/s220/IMG_8573.JPG'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2016/07/sas-converting-number-format-to-date.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-3593224246943694340' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/3593224246943694340' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-2070290085"/><gd:extendedProperty name="blogger.displayTime" value="February 22, 2021 at 3:00 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-7313051274062051254</id><published>2020-10-20T00:52:41.424-07:00</published><updated>2020-10-20T00:52:41.424-07:00</updated><title type='text'>Hi,

 

Here is some data, where I need to fetch y...</title><content type='html'>Hi,<br /><br /> <br /><br />Here is some data, where I need to fetch yymmdd10. format data (e.g. 2020-06-08).<br /><br />which includes all Jan-Dec or January to December data with (- or / ) seperates.<br /><br /><br />data xyz;<br />date1= &quot;08-June-2020&quot;;output;<br />date1= &quot;31-Oct-2020&quot;;output;<br />date1= &quot;13/August/2020&quot;; output;<br />date1= &quot;02/Jan/2020&quot; ;output;<br /><br />run;<br /><br /> <br /><br />Thank you in advance for your help and take care.<br /><br /> <br /><br />Regards<br /><br />Priya</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/3593224246943694340/comments/default/7313051274062051254'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/3593224246943694340/comments/default/7313051274062051254'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2016/07/sas-converting-number-format-to-date.html?showComment=1603180361424#c7313051274062051254' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/01381626662505837294</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/2016/07/sas-converting-number-format-to-date.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-3593224246943694340' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/3593224246943694340' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1504887185"/><gd:extendedProperty name="blogger.displayTime" value="October 20, 2020 at 12:52 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-700339944573095893</id><published>2020-08-20T23:43:16.497-07:00</published><updated>2020-08-20T23:43:16.497-07:00</updated><title type='text'> Can you please explain this using data and set st...</title><content type='html'> Can you please explain this using data and set statement. My one date is in $5. And I want to change it to date9. How to do that. Name of the original variable is date_1 and new variable I want to create is date_2<br /></content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/3593224246943694340/comments/default/700339944573095893'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/3593224246943694340/comments/default/700339944573095893'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2016/07/sas-converting-number-format-to-date.html?showComment=1597992196497#c700339944573095893' title=''/><author><name>sushrut</name><uri>https://www.blogger.com/profile/04887324620100667074</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/2016/07/sas-converting-number-format-to-date.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-3593224246943694340' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/3593224246943694340' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1555376846"/><gd:extendedProperty name="blogger.displayTime" value="August 20, 2020 at 11:43 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-6180104020258832945</id><published>2020-07-20T11:05:13.325-07:00</published><updated>2020-07-20T11:05:13.325-07:00</updated><title type='text'>use 
dt = put(input(date,mmddyy10.),date9.);
forma...</title><content type='html'>use <br />dt = put(input(date,mmddyy10.),date9.);<br />format dt date9.;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/3593224246943694340/comments/default/6180104020258832945'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/3593224246943694340/comments/default/6180104020258832945'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2016/07/sas-converting-number-format-to-date.html?showComment=1595268313325#c6180104020258832945' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/3593224246943694340/comments/default/7569947252692156894'/><author><name>Ashish Gupta</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/2016/07/sas-converting-number-format-to-date.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-3593224246943694340' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/3593224246943694340' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="July 20, 2020 at 11:05 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-7569947252692156894</id><published>2020-07-01T01:31:33.145-07:00</published><updated>2020-07-01T01:31:33.145-07:00</updated><title type='text'>How to convert character date &quot;10/13/2019&quo...</title><content type='html'>How to convert character date &quot;10/13/2019&quot; to date9. Format</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/3593224246943694340/comments/default/7569947252692156894'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/3593224246943694340/comments/default/7569947252692156894'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2016/07/sas-converting-number-format-to-date.html?showComment=1593592293145#c7569947252692156894' title=''/><author><name>Unknown</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/2016/07/sas-converting-number-format-to-date.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-3593224246943694340' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/3593224246943694340' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="July 1, 2020 at 1:31 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-6140681813800220678</id><published>2019-04-30T05:08:13.820-07:00</published><updated>2019-04-30T05:08:13.820-07:00</updated><title type='text'>why is date10. format giving the output as 14MAY20...</title><content type='html'>why is date10. format giving the output as 14MAY2016, it is the format date9.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/3593224246943694340/comments/default/6140681813800220678'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/3593224246943694340/comments/default/6140681813800220678'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2016/07/sas-converting-number-format-to-date.html?showComment=1556626093820#c6140681813800220678' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/04760265082053525282</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/2016/07/sas-converting-number-format-to-date.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-3593224246943694340' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/3593224246943694340' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-706394398"/><gd:extendedProperty name="blogger.displayTime" value="April 30, 2019 at 5:08 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-4121871847279024159</id><published>2018-11-05T00:42:36.697-08:00</published><updated>2018-11-05T00:42:36.697-08:00</updated><title type='text'>please my friend</title><content type='html'>please my friend</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/3593224246943694340/comments/default/4121871847279024159'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/3593224246943694340/comments/default/4121871847279024159'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2016/07/sas-converting-number-format-to-date.html?showComment=1541407356697#c4121871847279024159' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/3593224246943694340/comments/default/1404377470460267373'/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/06215266993031768611</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/2016/07/sas-converting-number-format-to-date.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-3593224246943694340' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/3593224246943694340' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-539815989"/><gd:extendedProperty name="blogger.displayTime" value="November 5, 2018 at 12:42 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-1404377470460267373</id><published>2018-11-05T00:42:05.428-08:00</published><updated>2018-11-05T00:42:05.428-08:00</updated><title type='text'>one question, why i cant change the format yymmdd8...</title><content type='html'>one question, why i cant change the format yymmdd8. by the format date9. in the input function?<br />what type of formats i can take or select?<br />the put(date,8.) variable have not a format date, why i can not take other format date?</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/3593224246943694340/comments/default/1404377470460267373'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/3593224246943694340/comments/default/1404377470460267373'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2016/07/sas-converting-number-format-to-date.html?showComment=1541407325428#c1404377470460267373' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/06215266993031768611</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/2016/07/sas-converting-number-format-to-date.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-3593224246943694340' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/3593224246943694340' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-539815989"/><gd:extendedProperty name="blogger.displayTime" value="November 5, 2018 at 12:42 AM"/></entry></feed>