<?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.post6953820374151930319..comments</id><updated>2024-12-13T03:11:35.450-08:00</updated><title type='text'>Comments on ListenData: SAS : Delete empty rows 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/6953820374151930319/comments/default'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2014/02/sas-delete-empty-rows-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>14</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-5111174607857556367</id><published>2022-01-28T06:09:11.046-08:00</published><updated>2022-01-28T06:09:11.046-08:00</updated><title type='text'>The below query will give the max length of the va...</title><content type='html'>The below query will give the max length of the variable data.&lt;br /&gt;proc sql; select max(length(forename)) from have; quit;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6953820374151930319/comments/default/5111174607857556367'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6953820374151930319/comments/default/5111174607857556367'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2014/02/sas-delete-empty-rows-in-sas.html?showComment=1643378951046#c5111174607857556367' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6953820374151930319/comments/default/5128371709749834201'/><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/2014/02/sas-delete-empty-rows-in-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-6953820374151930319' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/6953820374151930319' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-2100201656"/><gd:extendedProperty name="blogger.displayTime" value="January 28, 2022 at 6:09 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-6374964661030401200</id><published>2020-08-08T04:39:57.400-07:00</published><updated>2020-08-08T04:39:57.400-07:00</updated><title type='text'>proc sort data = abc;&#xa;by sex age;&#xa;run;&#xa;&#xa;data abc1;...</title><content type='html'>proc sort data = abc;&lt;br /&gt;by sex age;&lt;br /&gt;run;&lt;br /&gt;&lt;br /&gt;data abc1;&lt;br /&gt;set abc;&lt;br /&gt;by sex;&lt;br /&gt;retain counter;&lt;br /&gt;if first.sex then counter = 1;else counter = counter + 1;&lt;br /&gt;run;&lt;br /&gt;&lt;br /&gt;proc sort data = abc1;&lt;br /&gt;by descending sex ;&lt;br /&gt;run;&lt;br /&gt;&lt;br /&gt;proc sort data = abc1;&lt;br /&gt;by counter;&lt;br /&gt;run;&lt;br /&gt;&lt;br /&gt;@ashwani&lt;br /&gt;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6953820374151930319/comments/default/6374964661030401200'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6953820374151930319/comments/default/6374964661030401200'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2014/02/sas-delete-empty-rows-in-sas.html?showComment=1596886797400#c6374964661030401200' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6953820374151930319/comments/default/999867554722386181'/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/04926032502040026375</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/2014/02/sas-delete-empty-rows-in-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-6953820374151930319' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/6953820374151930319' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-860665413"/><gd:extendedProperty name="blogger.displayTime" value="August 8, 2020 at 4:39 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-3441154361467507818</id><published>2019-03-11T01:34:29.353-07:00</published><updated>2019-03-11T01:34:29.353-07:00</updated><title type='text'>data readin;&#xa;set outdata;&#xa;if  missing(coalescec(of...</title><content type='html'>data readin;&lt;br /&gt;set outdata;&lt;br /&gt;if  missing(coalescec(of _char_)) then delete;&lt;br /&gt;run;&lt;br /&gt;&lt;br /&gt;data readin1;&lt;br /&gt;set outdata;&lt;br /&gt;if  missing(coalesce(of _numeric_)) then delete;&lt;br /&gt;run;&lt;br /&gt;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6953820374151930319/comments/default/3441154361467507818'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6953820374151930319/comments/default/3441154361467507818'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2014/02/sas-delete-empty-rows-in-sas.html?showComment=1552293269353#c3441154361467507818' 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/2014/02/sas-delete-empty-rows-in-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-6953820374151930319' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/6953820374151930319' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="March 11, 2019 at 1:34 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-5128371709749834201</id><published>2018-08-07T05:27:37.023-07:00</published><updated>2018-08-07T05:27:37.023-07:00</updated><title type='text'>I want to know how to reduce the length of particu...</title><content type='html'>I want to know how to reduce the length of particular column based on the maximum length of the value in that particular column. e.g if i assigned column a as 200 length but i have maximum length of the value present in it as 20 .&lt;br /&gt;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6953820374151930319/comments/default/5128371709749834201'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6953820374151930319/comments/default/5128371709749834201'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2014/02/sas-delete-empty-rows-in-sas.html?showComment=1533644857023#c5128371709749834201' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/17156016804000969239</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/2014/02/sas-delete-empty-rows-in-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-6953820374151930319' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/6953820374151930319' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1910603886"/><gd:extendedProperty name="blogger.displayTime" value="August 7, 2018 at 5:27 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-7378945209366703113</id><published>2018-06-07T05:35:06.500-07:00</published><updated>2018-06-07T05:35:06.500-07:00</updated><title type='text'>What can I do if want to delete all columns from d...</title><content type='html'>What can I do if want to delete all columns from dataset having blank values</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6953820374151930319/comments/default/7378945209366703113'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6953820374151930319/comments/default/7378945209366703113'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2014/02/sas-delete-empty-rows-in-sas.html?showComment=1528374906500#c7378945209366703113' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/14355225618413275400</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/2014/02/sas-delete-empty-rows-in-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-6953820374151930319' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/6953820374151930319' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-114658946"/><gd:extendedProperty name="blogger.displayTime" value="June 7, 2018 at 5:35 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-5580097894294233148</id><published>2017-11-21T23:14:33.563-08:00</published><updated>2017-11-21T23:14:33.563-08:00</updated><title type='text'>options missing = &amp;#39; &amp;#39;;&#xa;data readin;&#xa;   set...</title><content type='html'>options missing = &amp;#39; &amp;#39;;&lt;br /&gt;data readin;&lt;br /&gt;   set outdata;&lt;br /&gt;   if missing(cats(of _numeric_)) then delete;&lt;br /&gt;run;&lt;br /&gt;&lt;br /&gt;this is to delete rows  where all numeric columns have missing values.&lt;br /&gt;&lt;br /&gt;please comment if the answer is right or wrong</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6953820374151930319/comments/default/5580097894294233148'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6953820374151930319/comments/default/5580097894294233148'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2014/02/sas-delete-empty-rows-in-sas.html?showComment=1511334873563#c5580097894294233148' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/10273885870587761167</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/2014/02/sas-delete-empty-rows-in-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-6953820374151930319' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/6953820374151930319' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-219570833"/><gd:extendedProperty name="blogger.displayTime" value="November 21, 2017 at 11:14 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-2466269072534550195</id><published>2017-08-16T23:03:24.957-07:00</published><updated>2017-08-16T23:03:24.957-07:00</updated><title type='text'>To delete blank rows in any dataset-&#xa;data a;&#xa;set o...</title><content type='html'>To delete blank rows in any dataset-&lt;br /&gt;data a;&lt;br /&gt;set outdata;&lt;br /&gt;if cmiss(of _all_) = 4 then delete; // 4 is number of variables in data&lt;br /&gt;run;&lt;br /&gt;&lt;br /&gt; </content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6953820374151930319/comments/default/2466269072534550195'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6953820374151930319/comments/default/2466269072534550195'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2014/02/sas-delete-empty-rows-in-sas.html?showComment=1502949804957#c2466269072534550195' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/00156279828248296468</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/2014/02/sas-delete-empty-rows-in-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-6953820374151930319' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/6953820374151930319' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-2049848460"/><gd:extendedProperty name="blogger.displayTime" value="August 16, 2017 at 11:03 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-1153950506029359917</id><published>2017-08-16T05:14:20.069-07:00</published><updated>2017-08-16T05:14:20.069-07:00</updated><title type='text'>proc sort data = abc;&#xa;by sex age;&#xa;run;&#xa;&#xa;data abc1;...</title><content type='html'>proc sort data = abc;&lt;br /&gt;by sex age;&lt;br /&gt;run;&lt;br /&gt;&lt;br /&gt;data abc1;&lt;br /&gt;set abc;&lt;br /&gt;retain counter;&lt;br /&gt;if first.sex then counter = 1;else counter = counter + 1;&lt;br /&gt;by sex;&lt;br /&gt;ranking = strip(input(counter,z9.) || sex);&lt;br /&gt;drop counter;&lt;br /&gt;run;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6953820374151930319/comments/default/1153950506029359917'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6953820374151930319/comments/default/1153950506029359917'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2014/02/sas-delete-empty-rows-in-sas.html?showComment=1502885660069#c1153950506029359917' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6953820374151930319/comments/default/999867554722386181'/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/10526467921352726716</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/2014/02/sas-delete-empty-rows-in-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-6953820374151930319' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/6953820374151930319' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-317855089"/><gd:extendedProperty name="blogger.displayTime" value="August 16, 2017 at 5:14 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-999867554722386181</id><published>2017-04-20T21:33:41.082-07:00</published><updated>2017-04-20T21:33:41.082-07:00</updated><title type='text'>my question--&#xa;&#xa;data abc;&#xa;input name$ sex$ age;&#xa;dat...</title><content type='html'>my question--&lt;br /&gt;&lt;br /&gt;data abc;&lt;br /&gt;input name$ sex$ age;&lt;br /&gt;datalines;&lt;br /&gt;tushar m 26&lt;br /&gt;dhiru m 27&lt;br /&gt;twinkle f 20&lt;br /&gt;ankita f 22&lt;br /&gt;goldi f 24&lt;br /&gt;nikhil m 25&lt;br /&gt;;&lt;br /&gt;&lt;br /&gt;i want to arrange observations by sex alternatively like 1st m 2nd f 3rd m 4th f&lt;br /&gt;5th m 6th f.&lt;br /&gt;how i do it ???? &lt;br /&gt;plz tell me ans.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6953820374151930319/comments/default/999867554722386181'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6953820374151930319/comments/default/999867554722386181'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2014/02/sas-delete-empty-rows-in-sas.html?showComment=1492749221082#c999867554722386181' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/11385830738725435531</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/2014/02/sas-delete-empty-rows-in-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-6953820374151930319' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/6953820374151930319' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-718402266"/><gd:extendedProperty name="blogger.displayTime" value="April 20, 2017 at 9:33 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-8135615105145791054</id><published>2017-03-08T10:01:54.750-08:00</published><updated>2017-03-08T10:01:54.750-08:00</updated><title type='text'>It is working fine at my end. Which version of SAS...</title><content type='html'>It is working fine at my end. Which version of SAS you are using?</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6953820374151930319/comments/default/8135615105145791054'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6953820374151930319/comments/default/8135615105145791054'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2014/02/sas-delete-empty-rows-in-sas.html?showComment=1488996114750#c8135615105145791054' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6953820374151930319/comments/default/7916749962935173599'/><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/2014/02/sas-delete-empty-rows-in-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-6953820374151930319' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/6953820374151930319' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-966036103"/><gd:extendedProperty name="blogger.displayTime" value="March 8, 2017 at 10:01 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-7916749962935173599</id><published>2017-03-08T01:31:19.619-08:00</published><updated>2017-03-08T01:31:19.619-08:00</updated><title type='text'>options missing = &amp;#39; &amp;#39;;&#xa;data readin;&#xa;   set...</title><content type='html'>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;when we run this code i am getting an error that _all_ is uninitialise&lt;br /&gt; </content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6953820374151930319/comments/default/7916749962935173599'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6953820374151930319/comments/default/7916749962935173599'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2014/02/sas-delete-empty-rows-in-sas.html?showComment=1488965479619#c7916749962935173599' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/13666858891769851799</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/2014/02/sas-delete-empty-rows-in-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-6953820374151930319' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/6953820374151930319' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1450138435"/><gd:extendedProperty name="blogger.displayTime" value="March 8, 2017 at 1:31 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-2873605670367366976</id><published>2016-01-25T03:51:02.263-08:00</published><updated>2016-01-25T03:51:02.263-08:00</updated><title type='text'>Anytime you change the Options, please do take car...</title><content type='html'>Anytime you change the Options, please do take care to change it back so that later code doesn&amp;#39;t change its behavior.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6953820374151930319/comments/default/2873605670367366976'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6953820374151930319/comments/default/2873605670367366976'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2014/02/sas-delete-empty-rows-in-sas.html?showComment=1453722662263#c2873605670367366976' 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/2014/02/sas-delete-empty-rows-in-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-6953820374151930319' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/6953820374151930319' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="January 25, 2016 at 3:51 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-7780643320047723109</id><published>2015-01-15T11:08:45.276-08:00</published><updated>2015-01-15T11:08:45.276-08:00</updated><title type='text'>But if i want to delete rows only when missing val...</title><content type='html'>But if i want to delete rows only when missing values exist in all the variables ;)&lt;br /&gt;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6953820374151930319/comments/default/7780643320047723109'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6953820374151930319/comments/default/7780643320047723109'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2014/02/sas-delete-empty-rows-in-sas.html?showComment=1421348925276#c7780643320047723109' title=''/><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/2014/02/sas-delete-empty-rows-in-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-6953820374151930319' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/6953820374151930319' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-966036103"/><gd:extendedProperty name="blogger.displayTime" value="January 15, 2015 at 11:08 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-224977552563012844</id><published>2014-12-04T10:28:24.041-08:00</published><updated>2014-12-04T10:28:24.041-08:00</updated><title type='text'>Because Name is your &amp;#39;key&amp;#39;, your code coul...</title><content type='html'>Because Name is your &amp;#39;key&amp;#39;, your code could be written more succinctly as:&lt;br /&gt;data readin;&lt;br /&gt;   set outdata;&lt;br /&gt;      where not missing( Name);&lt;br /&gt;run;&lt;br /&gt;&lt;br /&gt;But, if you got records with a Name, but no Scores, you could write it as:&lt;br /&gt;data readin;&lt;br /&gt;   set outdata;&lt;br /&gt;      where n( of Score1-Score3) &amp;gt; 0 ;&lt;br /&gt;run;&lt;br /&gt;&lt;br /&gt;Cheers, :)</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6953820374151930319/comments/default/224977552563012844'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6953820374151930319/comments/default/224977552563012844'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2014/02/sas-delete-empty-rows-in-sas.html?showComment=1417717704041#c224977552563012844' title=''/><author><name>Unknown</name><uri>https://www.blogger.com/profile/11992813918627099592</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/2014/02/sas-delete-empty-rows-in-sas.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-6953820374151930319' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/6953820374151930319' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1222177812"/><gd:extendedProperty name="blogger.displayTime" value="December 4, 2014 at 10:28 AM"/></entry></feed>