A\u015fa\u011f\u0131daki \u00f6rnek , NOT IN<\/b> operat\u00f6r\u00fcn\u00fcn pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir.<\/span><\/p>\n SAS’ta \u00e7e\u015fitli basketbol oyuncular\u0131 hakk\u0131nda bilgi i\u00e7eren a\u015fa\u011f\u0131daki veri k\u00fcmesine sahip oldu\u011fumuzu varsayal\u0131m:<\/span> <\/p>\n PROC SQL’de<\/strong> NOT IN<\/b> operat\u00f6r\u00fcn\u00fc yaln\u0131zca tak\u0131m\u0131n “Cavs” veya “Celtics”e e\u015fit olmad\u0131\u011f\u0131 sat\u0131rlar\u0131 se\u00e7mek i\u00e7in kullanabiliriz:<\/span> <\/p>\n D\u00f6nd\u00fcr\u00fclen sat\u0131rlar\u0131n yaln\u0131zca tak\u0131m\u0131n “Cavs” veya “Celtics” ile e\u015fit olmad\u0131\u011f\u0131 sat\u0131rlar oldu\u011funu unutmay\u0131n.<\/span><\/p>\n Ayr\u0131ca, yaln\u0131zca tak\u0131m\u0131n “Cavs” veya “Celtics”e e\u015fit olmad\u0131\u011f\u0131 sat\u0131rlar\u0131 i\u00e7eren yeni bir veri k\u00fcmesi olu\u015fturmak i\u00e7in bir SET<\/b> ifadesinde NOT IN<\/strong> operat\u00f6r\u00fcn\u00fc de kullanabilirsiniz:<\/span><\/span> <\/p>\n New_data<\/strong> ad\u0131 verilen yeni veri k\u00fcmesi, yaln\u0131zca orijinal veri k\u00fcmesindeki, tak\u0131m\u0131n “Cavs” veya “Celtics” ile e\u015fit olmad\u0131\u011f\u0131 sat\u0131rlar\u0131 i\u00e7eriyor.<\/span><\/p>\n A\u015fa\u011f\u0131daki e\u011fitimlerde SAS’ta di\u011fer ortak g\u00f6revlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n SAS: PROC SQL’de IN operat\u00f6r\u00fc nas\u0131l kullan\u0131l\u0131r?<\/a> Yaln\u0131zca bir de\u011fi\u015fkenin de\u011ferler listesinde bir de\u011fere sahip olmad\u0131\u011f\u0131 sat\u0131rlar\u0131 d\u00f6nd\u00fcrmek i\u00e7in SAS’ta NOT IN operat\u00f6r\u00fcn\u00fc kullanabilirsiniz. A\u015fa\u011f\u0131daki \u00f6rnek , NOT IN operat\u00f6r\u00fcn\u00fcn pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir. \u00d6rnek: SAS’ta NOT IN operat\u00f6r\u00fcn\u00fc kullanma SAS’ta \u00e7e\u015fitli basketbol oyuncular\u0131 hakk\u0131nda bilgi i\u00e7eren a\u015fa\u011f\u0131daki veri k\u00fcmesine sahip oldu\u011fumuzu varsayal\u0131m: \/*create dataset*\/ data my_data; input team $points; datalines ; […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-3954","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n \u00d6rnek: SAS’ta NOT IN operat\u00f6r\u00fcn\u00fc kullanma<\/strong><\/h2>\n
\/*create dataset*\/\n<\/span>data<\/span> my_data;\n input<\/span> team $points;\n datalines<\/span> ;\nCavs 12\nCavs 14\nWarriors 15\nHawks 18\nMavs 31\nMavs 32\nMavs 35\nCeltics 36\nCeltics 40\n;\nrun<\/span> ;\n\n\/*view dataset*\/\n<\/span>proc print<\/span> data<\/span> =my_data;\n<\/strong><\/span><\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comme1.jpg\")
<\/p>\n \/*select all rows where team is not 'Cavs' or 'Celtics'*\/ \n<\/span>proc sql<\/span> ;\n <\/span>select<\/span> *\n <\/span>from<\/span> my_data\n <\/span>where<\/span> team<\/span> not in ('Cavs', 'Celtics');<\/span><\/span>\nquit<\/span> ;<\/span><\/strong> <\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/notin1.jpg\")
<\/p>\n \/*create new dataset that only contains rows where team is not Cavs or Celtics*\/\ndata<\/span> new_data;\n set<\/span> my_data;\n where<\/span> team not in<\/span> ('Cavs', 'Celtics');\nrun<\/span> ;\n\n\/*view new dataset*\/\n<\/span>proc print<\/span> data<\/span> =new_data;<\/span><\/span><\/strong> <\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/notin2.jpg\")
<\/p>\n Ek kaynaklar<\/strong><\/span><\/h2>\n
SAS: PROC SQL’de LIKE operat\u00f6r\u00fc nas\u0131l kullan\u0131l\u0131r?<\/a>
SAS: PROC SQL’de WHERE operat\u00f6r\u00fc nas\u0131l kullan\u0131l\u0131r?<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"