tag:blogger.com,1999:blog-7958828565254404797.post4407145381440299646..comments2024-03-18T15:20:29.180-07:00Comments on ListenData: SAS : Dropping variables ending with a specific stringDeepanshu Bhallahttp://www.blogger.com/profile/09802839558125192674noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-7958828565254404797.post-64655727869183785862020-05-13T23:01:14.216-07:002020-05-13T23:01:14.216-07:00How to import all files with the name starting wit...How to import all files with the name starting with Sta with extension CSV.<br />Note: All files are present in same folder.ammuhttps://www.blogger.com/profile/05233699643506959293noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-49632191777377863532020-01-22T08:32:50.597-08:002020-01-22T08:32:50.597-08:00Code for dropping variables ending with '_d...Code for dropping variables ending with '_d' or '_D'<br /><br />proc contents data=have out=t(keep=name);<br />run;<br /><br />proc sql;<br />select distinct name into : n1 separated by ' ' from t<br />where upcase(name) like '%_D';<br />quit;<br /><br />%put &n1;<br /><br />data fnl;<br />set have;<br />drop &n1;<br />run;Anonymoushttps://www.blogger.com/profile/16795565839020970116noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-83072385015920283922019-04-05T10:10:47.900-07:002019-04-05T10:10:47.900-07:00Try this:
data A;
input ID COMMENTS $30. ;
Datali...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;Richahttps://www.blogger.com/profile/02645950856207703469noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-52188287619724846682019-04-05T10:07:55.241-07:002019-04-05T10:07:55.241-07:00This comment has been removed by the author.Richahttps://www.blogger.com/profile/02645950856207703469noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-77423154234129987162019-01-30T01:45:05.304-08:002019-01-30T01:45:05.304-08:00how to write a program to change DATASET-A to DATA...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 />Anonymoushttps://www.blogger.com/profile/05431943254171305457noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-21849206928337542152019-01-29T04:05:53.882-08:002019-01-29T04:05:53.882-08:00but how to separate many strings from one observat...but how to separate many strings from one observation and arranging under the same variable.Anonymoushttps://www.blogger.com/profile/05431943254171305457noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-72140219456110222212018-11-24T08:54:12.546-08:002018-11-24T08:54:12.546-08:00Can I use this by using like in where statement ?Can I use this by using like in where statement ?Anonymoushttps://www.blogger.com/profile/12808115696359039265noreply@blogger.com