<?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.post4407145381440299646..comments</id><updated>2024-12-13T03:11:35.450-08:00</updated><title type='text'>Comments on ListenData: SAS : Dropping variables ending with a specific string</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/4407145381440299646/comments/default'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/05/sas-dropping-variables-ending-with.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>7</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-1716589600496177301</id><published>2024-10-06T23:09:15.115-07:00</published><updated>2024-10-06T23:09:15.115-07:00</updated><title type='text'>without sql, this can be done I guessdata have;
se...</title><content type='html'>without sql, this can be done I guessdata have;<br />set sashelp.class;<br />r_d = ranuni(9);<br />b_d = ranuni(10);<br />c_DD = ranuni(11);<br />run;<br /><br />proc transpose data=have out=h1;<br />var _all_;<br />run;<br /><br /><br />data h2;<br />set h1;<br />where _NAME_ not like &#39;%_d&#39;;<br />run;<br /><br />proc transpose data=h2 out=h3(drop=_name_ _label_);<br />var _all_;<br />run ;<br /></content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4407145381440299646/comments/default/1716589600496177301'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4407145381440299646/comments/default/1716589600496177301'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/05/sas-dropping-variables-ending-with.html?showComment=1728281355115#c1716589600496177301' title=''/><author><name>Shirisha</name><uri>https://www.blogger.com/profile/07187379101164211993</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/05/sas-dropping-variables-ending-with.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4407145381440299646' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4407145381440299646' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1226216701"/><gd:extendedProperty name="blogger.displayTime" value="October 6, 2024 at 11:09 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-6465572786918378586</id><published>2020-05-13T23:01:14.216-07:00</published><updated>2020-05-13T23:01:14.216-07:00</updated><title type='text'>How to import all files with the name starting wit...</title><content type='html'>How to import all files with the name starting with Sta with extension CSV.<br />Note: All files are present in same folder.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4407145381440299646/comments/default/6465572786918378586'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4407145381440299646/comments/default/6465572786918378586'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/05/sas-dropping-variables-ending-with.html?showComment=1589436074216#c6465572786918378586' title=''/><author><name>ammu</name><uri>https://www.blogger.com/profile/05233699643506959293</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/05/sas-dropping-variables-ending-with.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4407145381440299646' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4407145381440299646' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-769577426"/><gd:extendedProperty name="blogger.displayTime" value="May 13, 2020 at 11:01 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-4963219177737786353</id><published>2020-01-22T08:32:50.597-08:00</published><updated>2020-01-22T08:32:50.597-08:00</updated><title type='text'>Code for dropping variables ending with &#39;_d&#3...</title><content type='html'>Code for dropping variables ending with &#39;_d&#39; or &#39;_D&#39;<br /><br />proc contents data=have out=t(keep=name);<br />run;<br /><br />proc sql;<br />select distinct name into : n1 separated by &#39; &#39; from t<br />where upcase(name) like &#39;%_D&#39;;<br />quit;<br /><br />%put &amp;n1;<br /><br />data fnl;<br />set have;<br />drop &amp;n1;<br />run;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4407145381440299646/comments/default/4963219177737786353'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4407145381440299646/comments/default/4963219177737786353'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/05/sas-dropping-variables-ending-with.html?showComment=1579710770597#c4963219177737786353' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/16795565839020970116</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/05/sas-dropping-variables-ending-with.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4407145381440299646' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4407145381440299646' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-462745044"/><gd:extendedProperty name="blogger.displayTime" value="January 22, 2020 at 8:32 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-8307238501592028392</id><published>2019-04-05T10:10:47.900-07:00</published><updated>2019-04-05T10:10:47.900-07:00</updated><title type='text'>Try this:

data A;
input ID COMMENTS $30. ;
Datali...</title><content type='html'>Try this:<br /><br />data A;<br />input ID COMMENTS $30. ;<br />Datalines4;<br />1 Com1;com2;com3;com4;com5<br />2 Com1;com2<br />3 Com1;com2;com3<br />;;;;<br /><br />data x(drop = i y comments);<br />set a;<br />y= countw(comments);<br />do i=1 to y;<br />id= id;<br />comments_new = scan(comments,i);<br />output;<br />end;<br /><br />run;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4407145381440299646/comments/default/8307238501592028392'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4407145381440299646/comments/default/8307238501592028392'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/05/sas-dropping-variables-ending-with.html?showComment=1554484247900#c8307238501592028392' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4407145381440299646/comments/default/7742315423412998716'/><author><name>Richa</name><uri>https://www.blogger.com/profile/02645950856207703469</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/05/sas-dropping-variables-ending-with.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4407145381440299646' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4407145381440299646' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-2031519199"/><gd:extendedProperty name="blogger.displayTime" value="April 5, 2019 at 10:10 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-7742315423412998716</id><published>2019-01-30T01:45:05.304-08:00</published><updated>2019-01-30T01:45:05.304-08:00</updated><title type='text'>how to write a program to change DATASET-A to DATA...</title><content type='html'>how to write a program to change DATASET-A to DATASET-B<br />DATASET -A<br /><br />ID COMMENTS<br />1 Com1;com2;com3;com4;com5;<br />2 Com1;com2<br />3 Com1;com2;com3<br /><br />DATASET-B<br /><br />ID COMMENTS<br />1 Com1<br />1 Com2<br />1 Com3<br />1 Com4<br />1 Com5<br />2 Com1<br />2 Com2<br />3 Com1<br />3 Com2<br />3 Com3<br /></content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4407145381440299646/comments/default/7742315423412998716'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4407145381440299646/comments/default/7742315423412998716'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/05/sas-dropping-variables-ending-with.html?showComment=1548841505304#c7742315423412998716' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/05431943254171305457</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/05/sas-dropping-variables-ending-with.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4407145381440299646' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4407145381440299646' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-961385689"/><gd:extendedProperty name="blogger.displayTime" value="January 30, 2019 at 1:45 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-2184920692833754215</id><published>2019-01-29T04:05:53.882-08:00</published><updated>2019-01-29T04:05:53.882-08:00</updated><title type='text'>but how to separate many strings from one observat...</title><content type='html'>but how to separate many strings from one observation and arranging under the same variable.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4407145381440299646/comments/default/2184920692833754215'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4407145381440299646/comments/default/2184920692833754215'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/05/sas-dropping-variables-ending-with.html?showComment=1548763553882#c2184920692833754215' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/05431943254171305457</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/05/sas-dropping-variables-ending-with.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4407145381440299646' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4407145381440299646' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-961385689"/><gd:extendedProperty name="blogger.displayTime" value="January 29, 2019 at 4:05 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-7214021945611022221</id><published>2018-11-24T08:54:12.546-08:00</published><updated>2018-11-24T08:54:12.546-08:00</updated><title type='text'>Can I use this by using like in where statement ?</title><content type='html'>Can I use this by using like in where statement ?</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4407145381440299646/comments/default/7214021945611022221'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4407145381440299646/comments/default/7214021945611022221'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/05/sas-dropping-variables-ending-with.html?showComment=1543078452546#c7214021945611022221' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/12808115696359039265</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/05/sas-dropping-variables-ending-with.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4407145381440299646' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4407145381440299646' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-761643155"/><gd:extendedProperty name="blogger.displayTime" value="November 24, 2018 at 8:54 AM"/></entry></feed>