tag:blogger.com,1999:blog-7958828565254404797.post2348211211546513763..comments2024-03-28T07:44:59.527-07:00Comments on ListenData: Dropping variables from a data set in SASDeepanshu Bhallahttp://www.blogger.com/profile/09802839558125192674noreply@blogger.comBlogger18125tag:blogger.com,1999:blog-7958828565254404797.post-58025911688230939902019-07-22T17:09:17.663-07:002019-07-22T17:09:17.663-07:00What exactly issue you are facing in downloading t...What exactly issue you are facing in downloading the university edition? I fixed the second one - you should access the file now. Please check and confirm the same. Thanks!Deepanshu Bhallahttps://www.blogger.com/profile/09802839558125192674noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-85126630362724923482019-07-22T08:45:39.660-07:002019-07-22T08:45:39.660-07:00Hello sir,
amazing free tutorials for SAS. Helping...Hello sir,<br />amazing free tutorials for SAS. Helping me a-lot in learning.<br />I have 2 issues:<br />1. unable to download the University edition<br />2. Can't access the file "Advanced SAS Interview Questions and Answers".<br />Will be of great help if you can help me with these two things sir.<br /><br />Thank You!<br /><br />Keep up the great work sir.Anonymoushttps://www.blogger.com/profile/06133132521378255173noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-5976691327967954512019-02-01T01:42:34.586-08:002019-02-01T01:42:34.586-08:00confused please help out.
In abv we are selecting...confused please help out. <br />In abv we are selecting gender.. so why we are dropping age?<br />and age to khai mntn ni h. Shivangihttps://www.blogger.com/profile/06982284823277741012noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-7367307541025750702018-04-03T22:48:39.977-07:002018-04-03T22:48:39.977-07:00yes,
totalsum = sum(obs1,obs2,obs3);
drop obs1 obs...yes,<br />totalsum = sum(obs1,obs2,obs3);<br />drop obs1 obs2 obs3;<br />newsum=2*totalsum;<br />As you can see that here drop is used as data statement so pdv is generated for those variable, so we can modify or delete those variable.Anonymoushttps://www.blogger.com/profile/01838438561279215196noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-20083486622864922362018-02-04T22:58:56.519-08:002018-02-04T22:58:56.519-08:00After droping a variable from a dataset can we alt...After droping a variable from a dataset can we alter those variable?<br /> totalsum = sum(obs1,obs2,obs3);<br />drop obs1 obs2 obs3;<br />/*Now is this possible!*/newsum=2*totalsum<br />Anonymoushttps://www.blogger.com/profile/13332552724118773178noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-26782186244807303792018-01-17T19:28:46.879-08:002018-01-17T19:28:46.879-08:00As per my knowledge, DROP option can be used after...As per my knowledge, DROP option can be used after data statement too.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-50226289073120982252018-01-06T16:57:44.236-08:002018-01-06T16:57:44.236-08:00I am getting an error after running below mention ...I am getting an error after running below mention code.. Pls advise anyone <br />Proc print data = mylib. import (Keep=Region Plan Actual) (obs=10);<br />Run; Anonymoushttps://www.blogger.com/profile/13850068902120202718noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-50582977833108508612018-01-04T04:08:21.456-08:002018-01-04T04:08:21.456-08:00Thanks for detailed tutorial
Really helpfulThanks for detailed tutorial<br />Really helpfulAnonymoushttps://www.blogger.com/profile/01196177159809084168noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-76014393870747442262017-08-26T12:44:58.173-07:002017-08-26T12:44:58.173-07:00Yes! That's right👍Yes! That's right👍Avinashhttps://www.blogger.com/profile/00209326770262006820noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-45295824258433713442017-08-08T14:12:57.489-07:002017-08-08T14:12:57.489-07:00Hi,
We can use drop statement in data step also ri...Hi,<br />We can use drop statement in data step also right?<br /><br />data readin (drop = obs1 obs2 obs3);<br />set outdata ;<br />totalsum = sum(obs1,obs2,obs3);<br />run;Sankyhttps://www.blogger.com/profile/16270506256985344817noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-22444497131348832322017-05-13T11:13:09.319-07:002017-05-13T11:13:09.319-07:00Thanks for pointing it out. Corrected! Thanks for pointing it out. Corrected! Deepanshu Bhallahttps://www.blogger.com/profile/09802839558125192674noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-58277312275957169092017-05-07T04:05:46.519-07:002017-05-07T04:05:46.519-07:00Hi,
Just one correction. Created data set does not...Hi,<br />Just one correction. Created data set does not contain any height variable.<br />Please update accordingly.<br />Thanks for your great work.Chandra Shekherhttps://www.blogger.com/profile/14675710892455974760noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-69148955261114561262017-02-21T16:44:53.348-08:002017-02-21T16:44:53.348-08:00hello, does keep statement and option act exactly ...hello, does keep statement and option act exactly like drop counterpart?<br />thanksAnonymoushttps://www.blogger.com/profile/04761299555245642056noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-9451968630382646592017-01-29T21:52:01.066-08:002017-01-29T21:52:01.066-08:00Really HelpfullReally HelpfullNareshhttps://www.blogger.com/profile/11077463755309792480noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-15860200050904620482016-10-11T12:16:20.879-07:002016-10-11T12:16:20.879-07:00it will not drop the vaiables age and height when ...it will not drop the vaiables age and height when the data statement is run but it will be droped while writing to the data set in the pdv.<br />and if ur data contained a attribute as gender then u can drop other variable for using any conditional statement .\<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-85609775132251219752016-09-13T07:11:39.306-07:002016-09-13T07:11:39.306-07:00In that case age and height of only females will c...In that case age and height of only females will come.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-5621580706497884762016-03-10T18:14:02.983-08:002016-03-10T18:14:02.983-08:00we command to SAS print data from outdata and drop...we command to SAS print data from outdata and drop age height where gender (F)<br /> i dint c any condition will be not satisfiedHealthhttps://www.blogger.com/profile/17581630337662878855noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-2048911023589539352015-12-02T02:11:25.500-08:002015-12-02T02:11:25.500-08:00DROP = option
data readin;
set outdata (drop =...DROP = option<br /><br /><br />data readin; <br /><br />set outdata (drop = age height);<br /> if gender = 'F';<br /><br />run;<br /><br /><br />if it will drop age and height first then how the if condition will be satisfied ? little confused.Will appreciate if you help.Anonymousnoreply@blogger.com