A\u015fa\u011f\u0131daki \u00f6rnekler, CASE operat\u00f6r\u00fcn\u00fcn SAS’ta \u00e7e\u015fitli basketbol oyuncular\u0131 hakk\u0131nda bilgi i\u00e7eren a\u015fa\u011f\u0131daki veri k\u00fcmesiyle<\/span> pratikte<\/b> nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir<\/span> : <\/p>\n PROC SQL’de<\/strong> CASE<\/strong> operat\u00f6r\u00fcn\u00fc, veri k\u00fcmesinde point_flag<\/strong> ad\u0131 verilen yeni bir s\u00fctun olu\u015fturmak i\u00e7in kullanabiliriz; bu s\u00fctun, puan<\/strong> s\u00fctunundaki de\u011fer 20’den k\u00fc\u00e7\u00fckse 0 de\u011ferini veya aksi halde 1 de\u011ferini al\u0131r:<\/span> <\/p>\n Points_flag<\/strong> s\u00fctununun, puan<\/strong> s\u00fctununun de\u011feri 20’den k\u00fc\u00e7\u00fckse 0 de\u011ferini, aksi halde 1 de\u011ferini ald\u0131\u011f\u0131n\u0131 unutmay\u0131n.<\/span><\/p>\n PROC SQL’de<\/strong> CASE<\/strong> operat\u00f6r\u00fcn\u00fc, veri k\u00fcmesinde point_flag<\/strong> ad\u0131 verilen yeni bir s\u00fctun olu\u015fturmak i\u00e7in de kullanabiliriz; bu s\u00fctun, puan<\/strong> s\u00fctunundaki de\u011fer 20’den k\u00fc\u00e7\u00fckse 0 de\u011ferini, noktalar<\/strong> 35’ten k\u00fc\u00e7\u00fckse 1 de\u011ferini al\u0131r. veya aksi halde 2 de\u011feri:<\/span> <\/p>\n point_flag<\/strong> s\u00fctununun, puan<\/strong> s\u00fctunundaki kar\u015f\u0131l\u0131k gelen de\u011fere ba\u011fl\u0131 olarak 0, 1 veya 2 de\u011ferini ald\u0131\u011f\u0131n\u0131 unutmay\u0131n.<\/span><\/p>\n Not<\/strong> : Yeni bir s\u00fctunda istedi\u011finiz kadar farkl\u0131 de\u011fer \u00fcretmek i\u00e7in istedi\u011finiz kadar while<\/strong> ifadesi kullanmaktan \u00e7ekinmeyin.<\/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 WHERE operat\u00f6r\u00fc nas\u0131l kullan\u0131l\u0131r?<\/a> SAS’ta PROC SQL’de IF ifadesini kullanmak m\u00fcmk\u00fcn olmasa da bir de\u011fi\u015fkenin belirli ko\u015fullara g\u00f6re almas\u0131 gereken de\u011ferleri tan\u0131mlamak i\u00e7in CASE operat\u00f6r\u00fcn\u00fc kullanabilirsiniz. A\u015fa\u011f\u0131daki \u00f6rnekler, CASE operat\u00f6r\u00fcn\u00fcn SAS’ta \u00e7e\u015fitli basketbol oyuncular\u0131 hakk\u0131nda bilgi i\u00e7eren a\u015fa\u011f\u0131daki veri k\u00fcmesiyle pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir : \/*create dataset*\/ data my_data; input team $points; datalines ; Cavs 12 Cavs 14 Warriors […]<\/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-3977","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\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 \u00d6rnek 1: CASE operat\u00f6r\u00fcn\u00fc yaln\u0131zca iki sonu\u00e7la kullanma<\/strong><\/h2>\n
\/*create new column called points_flag using case operator*\/ \n<\/span>proc sql<\/span> ;\n <\/span>select<\/span> *,\n<\/span>box<\/span> \n when<\/span> points <<\/span> 20<\/span> then<\/span> 0<\/span> else<\/span> 1<\/span>\n end<\/span> as<\/span> points_flag\n<\/span>from<\/span> my_data;\n<\/span>quit<\/span> ;<\/span><\/span><\/strong><\/span> <\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ifsql1.jpg\")
<\/p>\n \u00d6rnek 2: CASE operat\u00f6r\u00fcn\u00fc ikiden fazla sonu\u00e7la kullanma<\/strong><\/h2>\n
\/*create new column called points_flag using case operator*\/ \n<\/span>proc sql<\/span> ;\n <\/span>select<\/span> *,\n <\/span>box<\/span> \n when<\/span> points <<\/span> 20<\/span> then<\/span> 0\n<\/span>when<\/span> points <<\/span> 35<\/span> then<\/span> 1<\/span> else<\/span> 2<\/span><\/span>\n end<\/span> as<\/span> points_flag\n <\/span>from<\/span> my_data;\n<\/span>quit<\/span> ;<\/span><\/strong><\/span> <\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ifsql2.jpg\")
<\/p>\n Ek kaynaklar<\/strong><\/span><\/h2>\n
SAS: PROC SQL’de IN operat\u00f6r\u00fc nas\u0131l kullan\u0131l\u0131r?<\/a>
SAS: PROC SQL’de UPDATE nas\u0131l kullan\u0131l\u0131r?<\/a>
SAS: PROC SQL’de CONTAINS nas\u0131l kullan\u0131l\u0131r?<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"