<?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.post4805219372040978819..comments</id><updated>2024-12-13T03:11:35.450-08:00</updated><title type='text'>Comments on ListenData: Missing Values 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/4805219372040978819/comments/default'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/01/missing-values-in-sas.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-5396947715537495211</id><published>2021-02-26T22:07:52.324-08:00</published><updated>2021-02-26T22:07:52.324-08:00</updated><title type='text'>I want to treat 43% missing with value=1,27% missi...</title><content type='html'>I want to treat 43% missing with value=1,27% missing with value=2, 16% missing with value=3, 14% missing with value=4.&lt;br /&gt;How can I do this?&lt;br /&gt;Can anyone please help?</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4805219372040978819/comments/default/5396947715537495211'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4805219372040978819/comments/default/5396947715537495211'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/01/missing-values-in-sas.html?showComment=1614406072324#c5396947715537495211' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/11572473676075404619</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/2015/01/missing-values-in-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4805219372040978819' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4805219372040978819' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1263865125"/><gd:extendedProperty name="blogger.displayTime" value="February 26, 2021 at 10:07 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-3386665424521786663</id><published>2019-09-24T05:31:12.211-07:00</published><updated>2019-09-24T05:31:12.211-07:00</updated><title type='text'>Try this out ....&#xa;data nidhi1;set nidhi;&#xa;array new...</title><content type='html'>Try this out ....&lt;br /&gt;data nidhi1;set nidhi;&lt;br /&gt;array new  _numeric_;&lt;br /&gt;do over new;&lt;br /&gt;if new=. then new=0;&lt;br /&gt;end;&lt;br /&gt;run;&lt;br /&gt;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4805219372040978819/comments/default/3386665424521786663'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4805219372040978819/comments/default/3386665424521786663'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/01/missing-values-in-sas.html?showComment=1569328272211#c3386665424521786663' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/10258167595535461723</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/2015/01/missing-values-in-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4805219372040978819' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4805219372040978819' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-433513279"/><gd:extendedProperty name="blogger.displayTime" value="September 24, 2019 at 5:31 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-979953096571400545</id><published>2019-07-10T02:03:00.101-07:00</published><updated>2019-07-10T02:03:00.101-07:00</updated><title type='text'>data nidhi;&#xa;input x y z;&#xa;cards;&#xa;22 5 56&#xa;. 25 96&#xa;56...</title><content type='html'>data nidhi;&lt;br /&gt;input x y z;&lt;br /&gt;cards;&lt;br /&gt;22 5 56&lt;br /&gt;. 25 96&lt;br /&gt;56 . 56&lt;br /&gt;66 52 41&lt;br /&gt;96 52 . &lt;br /&gt;85 . 52&lt;br /&gt;. . 44&lt;br /&gt;;&lt;br /&gt;run;&lt;br /&gt;I want to assign 0 to the all missing values in one statment.&lt;br /&gt;can anyone help?</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4805219372040978819/comments/default/979953096571400545'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4805219372040978819/comments/default/979953096571400545'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/01/missing-values-in-sas.html?showComment=1562749380101#c979953096571400545' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/05285379063252956420</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/2015/01/missing-values-in-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4805219372040978819' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4805219372040978819' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-2005692161"/><gd:extendedProperty name="blogger.displayTime" value="July 10, 2019 at 2:03 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-7739718205562949444</id><published>2019-04-07T22:44:07.944-07:00</published><updated>2019-04-07T22:44:07.944-07:00</updated><title type='text'>BrO,Why dont you help in doing the same.Rather the...</title><content type='html'>BrO,Why dont you help in doing the same.Rather then pointing someone,do some good for others as well.&lt;br /&gt;&lt;br /&gt;Mr.Deepanshu is giving his best for all beginners.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4805219372040978819/comments/default/7739718205562949444'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4805219372040978819/comments/default/7739718205562949444'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/01/missing-values-in-sas.html?showComment=1554702247944#c7739718205562949444' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4805219372040978819/comments/default/5348392541621273967'/><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/2015/01/missing-values-in-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4805219372040978819' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4805219372040978819' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="April 7, 2019 at 10:44 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-2466112913250587781</id><published>2019-02-28T16:21:35.172-08:00</published><updated>2019-02-28T16:21:35.172-08:00</updated><title type='text'>thanks for the excellent tutorials , please keep d...</title><content type='html'>thanks for the excellent tutorials , please keep datasets and examples in same lesson. it will be helpful for indevedual topic readers.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4805219372040978819/comments/default/2466112913250587781'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4805219372040978819/comments/default/2466112913250587781'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/01/missing-values-in-sas.html?showComment=1551399695172#c2466112913250587781' title=''/><author><name>rajesh</name><uri>https://www.blogger.com/profile/04861888176154144501</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/2015/01/missing-values-in-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4805219372040978819' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4805219372040978819' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1221672669"/><gd:extendedProperty name="blogger.displayTime" value="February 28, 2019 at 4:21 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-1687562691465016670</id><published>2019-01-31T09:07:59.514-08:00</published><updated>2019-01-31T09:07:59.514-08:00</updated><title type='text'>i tried the same code &#xa;&#xa;data work.missvalue;&#xa;input...</title><content type='html'>i tried the same code &lt;br /&gt;&lt;br /&gt;data work.missvalue;&lt;br /&gt;input x y z;&lt;br /&gt;cards;&lt;br /&gt;1 2 4&lt;br /&gt;7 8 .&lt;br /&gt;7 - 7&lt;br /&gt;6 9 .&lt;br /&gt;9 8 _&lt;br /&gt;9 9 7&lt;br /&gt;;&lt;br /&gt;run;&lt;br /&gt;&lt;br /&gt;options missing=&amp;#39;&amp;#39;;&lt;br /&gt;data readin;&lt;br /&gt;set work.missvalue;&lt;br /&gt;IF MISSING(CATS(OF_ALL_))THEN DELETE;&lt;br /&gt;RUN;&lt;br /&gt;&lt;br /&gt;but in my above code out is blank : Rows 4 and Column 0&lt;br /&gt;please guide someone</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4805219372040978819/comments/default/1687562691465016670'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4805219372040978819/comments/default/1687562691465016670'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/01/missing-values-in-sas.html?showComment=1548954479514#c1687562691465016670' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4805219372040978819/comments/default/7175980534573851712'/><author><name>Bhupinder</name><uri>https://www.blogger.com/profile/14500548925339278560</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/2015/01/missing-values-in-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4805219372040978819' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4805219372040978819' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-629345625"/><gd:extendedProperty name="blogger.displayTime" value="January 31, 2019 at 9:07 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-2951709113609325951</id><published>2018-04-23T17:40:56.217-07:00</published><updated>2018-04-23T17:40:56.217-07:00</updated><title type='text'>Hi....,&#xa;I would like to get the variables has to b...</title><content type='html'>Hi....,&lt;br /&gt;I would like to get the variables has to be printed which have couple of missing values.&lt;br /&gt;&lt;br /&gt;For ex: if the name variable has missing record the name variable should be printed.&lt;br /&gt;&lt;br /&gt;if id variables has a missing record the id variables has to be printed.&lt;br /&gt;&lt;br /&gt;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4805219372040978819/comments/default/2951709113609325951'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4805219372040978819/comments/default/2951709113609325951'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/01/missing-values-in-sas.html?showComment=1524530456217#c2951709113609325951' 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/2015/01/missing-values-in-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4805219372040978819' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4805219372040978819' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="April 23, 2018 at 5:40 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-5348392541621273967</id><published>2018-01-01T21:21:37.747-08:00</published><updated>2018-01-01T21:21:37.747-08:00</updated><title type='text'>Please edit this chapter based on the fact that so...</title><content type='html'>Please edit this chapter based on the fact that some of the datasets are dependent on other chapters and we can&amp;#39;t run the code to see what&amp;#39;s going on (unless we still have prior datasets)</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4805219372040978819/comments/default/5348392541621273967'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4805219372040978819/comments/default/5348392541621273967'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/01/missing-values-in-sas.html?showComment=1514870497747#c5348392541621273967' 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/2015/01/missing-values-in-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4805219372040978819' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4805219372040978819' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="January 1, 2018 at 9:21 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-7175980534573851712</id><published>2017-11-09T17:32:25.230-08:00</published><updated>2017-11-09T17:32:25.230-08:00</updated><title type='text'>I tried this code with the temp data but its not r...</title><content type='html'>I tried this code with the temp data but its not removing any rows.&lt;br /&gt;&lt;br /&gt;options missing = &amp;#39; &amp;#39;;&lt;br /&gt;data readin;&lt;br /&gt;set outdata;&lt;br /&gt;if missing(cats(of _all_)) then delete;&lt;br /&gt;run;&lt;br /&gt;&lt;br /&gt;Output is same as the data set. Is it working for any one else ?&lt;br /&gt;&lt;br /&gt;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4805219372040978819/comments/default/7175980534573851712'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4805219372040978819/comments/default/7175980534573851712'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/01/missing-values-in-sas.html?showComment=1510277545230#c7175980534573851712' 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/2015/01/missing-values-in-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4805219372040978819' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4805219372040978819' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="November 9, 2017 at 5:32 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-773981248157651462</id><published>2017-03-25T11:36:08.336-07:00</published><updated>2017-03-25T11:36:08.336-07:00</updated><title type='text'>Thanks, the information was really helpful.</title><content type='html'>Thanks, the information was really helpful.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4805219372040978819/comments/default/773981248157651462'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4805219372040978819/comments/default/773981248157651462'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/01/missing-values-in-sas.html?showComment=1490466968336#c773981248157651462' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/09157567913706185363</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/2015/01/missing-values-in-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4805219372040978819' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4805219372040978819' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-974319281"/><gd:extendedProperty name="blogger.displayTime" value="March 25, 2017 at 11:36 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-1960985085345427281</id><published>2016-12-13T19:16:31.805-08:00</published><updated>2016-12-13T19:16:31.805-08:00</updated><title type='text'>Thanks a lot! This blog has been very helpful.</title><content type='html'>Thanks a lot! This blog has been very helpful.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4805219372040978819/comments/default/1960985085345427281'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4805219372040978819/comments/default/1960985085345427281'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/01/missing-values-in-sas.html?showComment=1481685391805#c1960985085345427281' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/02080254938597483119</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/2015/01/missing-values-in-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4805219372040978819' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4805219372040978819' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1677800533"/><gd:extendedProperty name="blogger.displayTime" value="December 13, 2016 at 7:16 PM"/></entry></feed>