<?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;&#xa;se...</title><content type='html'>without sql, this can be done I guessdata have;&lt;br /&gt;set sashelp.class;&lt;br /&gt;r_d = ranuni(9);&lt;br /&gt;b_d = ranuni(10);&lt;br /&gt;c_DD = ranuni(11);&lt;br /&gt;run;&lt;br /&gt;&lt;br /&gt;proc transpose data=have out=h1;&lt;br /&gt;var _all_;&lt;br /&gt;run;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;data h2;&lt;br /&gt;set h1;&lt;br /&gt;where _NAME_ not like &amp;#39;%_d&amp;#39;;&lt;br /&gt;run;&lt;br /&gt;&lt;br /&gt;proc transpose data=h2 out=h3(drop=_name_ _label_);&lt;br /&gt;var _all_;&lt;br /&gt;run  ;&lt;br /&gt;</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.&lt;br /&gt;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 &amp;#39;_d&amp;#3...</title><content type='html'>Code for dropping variables ending with &amp;#39;_d&amp;#39; or &amp;#39;_D&amp;#39;&lt;br /&gt;&lt;br /&gt;proc contents data=have out=t(keep=name);&lt;br /&gt;run;&lt;br /&gt;&lt;br /&gt;proc sql;&lt;br /&gt;select distinct name into : n1 separated by &amp;#39; &amp;#39; from t&lt;br /&gt;where upcase(name) like &amp;#39;%_D&amp;#39;;&lt;br /&gt;quit;&lt;br /&gt;&lt;br /&gt;%put &amp;amp;n1;&lt;br /&gt;&lt;br /&gt;data fnl;&lt;br /&gt;set have;&lt;br /&gt;drop &amp;amp;n1;&lt;br /&gt;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:&#xa;&#xa;data A;&#xa;input ID COMMENTS $30. ;&#xa;Datali...</title><content type='html'>Try this:&lt;br /&gt;&lt;br /&gt;data A;&lt;br /&gt;input ID COMMENTS $30. ;&lt;br /&gt;Datalines4;&lt;br /&gt;1 Com1;com2;com3;com4;com5&lt;br /&gt;2 Com1;com2&lt;br /&gt;3 Com1;com2;com3&lt;br /&gt;;;;;&lt;br /&gt;&lt;br /&gt;data x(drop = i y comments);&lt;br /&gt;set a;&lt;br /&gt;y= countw(comments);&lt;br /&gt;do i=1 to y;&lt;br /&gt;id= id;&lt;br /&gt;comments_new = scan(comments,i);&lt;br /&gt;output;&lt;br /&gt;end;&lt;br /&gt;&lt;br /&gt;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&lt;br /&gt;DATASET -A&lt;br /&gt;&lt;br /&gt;ID COMMENTS&lt;br /&gt;1 Com1;com2;com3;com4;com5;&lt;br /&gt;2 Com1;com2&lt;br /&gt;3 Com1;com2;com3&lt;br /&gt;&lt;br /&gt;DATASET-B&lt;br /&gt;&lt;br /&gt;ID  COMMENTS&lt;br /&gt;1 Com1&lt;br /&gt;1 Com2&lt;br /&gt;1 Com3&lt;br /&gt;1 Com4&lt;br /&gt;1 Com5&lt;br /&gt;2 Com1&lt;br /&gt;2 Com2&lt;br /&gt;3 Com1&lt;br /&gt;3 Com2&lt;br /&gt;3 Com3&lt;br /&gt;</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>