<?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.<br />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;
by sex age;
run;

data abc1;...</title><content type='html'>proc sort data = abc;<br />by sex age;<br />run;<br /><br />data abc1;<br />set abc;<br />by sex;<br />retain counter;<br />if first.sex then counter = 1;else counter = counter + 1;<br />run;<br /><br />proc sort data = abc1;<br />by descending sex ;<br />run;<br /><br />proc sort data = abc1;<br />by counter;<br />run;<br /><br />@ashwani<br /></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;
set outdata;
if missing(coalescec(of...</title><content type='html'>data readin;<br />set outdata;<br />if missing(coalescec(of _char_)) then delete;<br />run;<br /><br />data readin1;<br />set outdata;<br />if missing(coalesce(of _numeric_)) then delete;<br />run;<br /></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 .<br /></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 = &#39; &#39;;
data readin;
 set...</title><content type='html'>options missing = &#39; &#39;;<br />data readin;<br /> set outdata;<br /> if missing(cats(of _numeric_)) then delete;<br />run;<br /><br />this is to delete rows where all numeric columns have missing values.<br /><br />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-
data a;
set o...</title><content type='html'>To delete blank rows in any dataset-<br />data a;<br />set outdata;<br />if cmiss(of _all_) = 4 then delete; // 4 is number of variables in data<br />run;<br /><br /> </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;
by sex age;
run;

data abc1;...</title><content type='html'>proc sort data = abc;<br />by sex age;<br />run;<br /><br />data abc1;<br />set abc;<br />retain counter;<br />if first.sex then counter = 1;else counter = counter + 1;<br />by sex;<br />ranking = strip(input(counter,z9.) || sex);<br />drop counter;<br />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--

data abc;
input name$ sex$ age;
dat...</title><content type='html'>my question--<br /><br />data abc;<br />input name$ sex$ age;<br />datalines;<br />tushar m 26<br />dhiru m 27<br />twinkle f 20<br />ankita f 22<br />goldi f 24<br />nikhil m 25<br />;<br /><br />i want to arrange observations by sex alternatively like 1st m 2nd f 3rd m 4th f<br />5th m 6th f.<br />how i do it ???? <br />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 = &#39; &#39;;
data readin;
 set...</title><content type='html'>options missing = &#39; &#39;;<br />data readin;<br /> set outdata;<br /> if missing(cats(of _all_)) then delete;<br />run;<br />when we run this code i am getting an error that _all_ is uninitialise<br /> </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&#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 ;)<br /></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 &#39;key&#39;, your code coul...</title><content type='html'>Because Name is your &#39;key&#39;, your code could be written more succinctly as:<br />data readin;<br /> set outdata;<br /> where not missing( Name);<br />run;<br /><br />But, if you got records with a Name, but no Scores, you could write it as:<br />data readin;<br /> set outdata;<br /> where n( of Score1-Score3) &gt; 0 ;<br />run;<br /><br />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>