A\u015fa\u011f\u0131daki \u00f6rnek bu ifadenin pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6stermektedir.<\/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 Veri k\u00fcmesindeki t\u00fcm benzersiz sat\u0131rlar\u0131 se\u00e7mek i\u00e7in PROC SQL’de<\/strong> SELECT DISTINCT<\/b> ifadesini kullanabiliriz:<\/span> <\/p>\n Not<\/strong> : SELECT DISTINCT’ten<\/strong> sonra gelen y\u0131ld\u0131z sembol\u00fc ( *<\/strong> ), SAS’a veri k\u00fcmesindeki t\u00fcm<\/em> s\u00fctunlar\u0131 se\u00e7mesini s\u00f6yler.<\/span><\/p>\n T\u00fcm benzersiz sat\u0131rlar\u0131n \u00e7\u0131kt\u0131da g\u00f6r\u00fcnt\u00fclendi\u011fini unutmay\u0131n.<\/span><\/p>\n \u00d6rne\u011fin, birka\u00e7 sat\u0131r\u0131n tak\u0131m de\u011feri A<\/strong> , konum de\u011feri Forward<\/strong> ve puan de\u011feri 13’t\u00fcr<\/strong> , ancak bu sat\u0131rlardan yaln\u0131zca biri g\u00f6r\u00fcnt\u00fclenir.<\/span><\/p>\n Hangi s\u00fctunlar\u0131 se\u00e7mek istedi\u011fimizi de belirtebilece\u011fimizi unutmay\u0131n:<\/span> <\/p>\n Sonu\u00e7ta yaln\u0131zca benzersiz kayd\u0131rma ve konum kombinasyonlar\u0131n\u0131n g\u00f6r\u00fcnt\u00fclendi\u011fini unutmay\u0131n.<\/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 ORDER BY nas\u0131l kullan\u0131l\u0131r?<\/a> Bir veri k\u00fcmesinde yaln\u0131zca benzersiz sat\u0131rlar\u0131 se\u00e7mek i\u00e7in SAS’ta PROC SQL’de SELECT DISTINCT deyimini kullanabilirsiniz. A\u015fa\u011f\u0131daki \u00f6rnek bu ifadenin pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6stermektedir. \u00d6rnek: SAS’ta SELECT DISTINCT kullan\u0131m\u0131 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 $position $points; datalines ; A Guard 14 A […]<\/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-4600","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n \u00d6rnek: SAS’ta SELECT DISTINCT kullan\u0131m\u0131<\/strong><\/h2>\n
\/*create dataset*\/\n<\/span>data<\/span> my_data;\n input<\/span> team $position $points;\n datalines<\/span> ;\nA Guard 14\nA Guard 14\nA Guard 24\nA Forward 13\nA Forward 13\nB Guard 22\nB Guard 22\nB Forward 34\nC Forward 15\nC Forward 18\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\/distinct11.png\")
<\/p>\n \/*select all unique rows*\/\n<\/span>proc sql<\/span> ;\n select distinct<\/span> *\nfrom<\/span> my_data;\nquit<\/span> ;<\/strong><\/span> <\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/distinct12.png\")
<\/p>\n \/*select all unique combinations of team and position*\/\n<\/span>proc sql<\/span> ;\n select distinct<\/span> team, position\nfrom<\/span> my_data;\nquit<\/span> ;<\/strong><\/span> <\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/distinct13.png\")
<\/p>\n Ek kaynaklar<\/strong><\/span><\/h2>\n
SAS: PROC SQL’de CONTAINS 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":"