<?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.<br />How can I do this?<br />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 ....
data nidhi1;set nidhi;
array new...</title><content type='html'>Try this out ....<br />data nidhi1;set nidhi;<br />array new _numeric_;<br />do over new;<br />if new=. then new=0;<br />end;<br />run;<br /></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;
input x y z;
cards;
22 5 56
. 25 96
56...</title><content type='html'>data nidhi;<br />input x y z;<br />cards;<br />22 5 56<br />. 25 96<br />56 . 56<br />66 52 41<br />96 52 . <br />85 . 52<br />. . 44<br />;<br />run;<br />I want to assign 0 to the all missing values in one statment.<br />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.<br /><br />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 

data work.missvalue;
input...</title><content type='html'>i tried the same code <br /><br />data work.missvalue;<br />input x y z;<br />cards;<br />1 2 4<br />7 8 .<br />7 - 7<br />6 9 .<br />9 8 _<br />9 9 7<br />;<br />run;<br /><br />options missing=&#39;&#39;;<br />data readin;<br />set work.missvalue;<br />IF MISSING(CATS(OF_ALL_))THEN DELETE;<br />RUN;<br /><br />but in my above code out is blank : Rows 4 and Column 0<br />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....,
I would like to get the variables has to b...</title><content type='html'>Hi....,<br />I would like to get the variables has to be printed which have couple of missing values.<br /><br />For ex: if the name variable has missing record the name variable should be printed.<br /><br />if id variables has a missing record the id variables has to be printed.<br /><br /></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&#39;t run the code to see what&#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.<br /><br />options missing = &#39; &#39;;<br />data readin;<br />set outdata;<br />if missing(cats(of _all_)) then delete;<br />run;<br /><br />Output is same as the data set. Is it working for any one else ?<br /><br /></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>