Bu \u00f6zelli\u011fi pratikte kullanman\u0131n iki yayg\u0131n yolu \u015funlard\u0131r:<\/span><\/p>\n Y\u00f6ntem 1: Sat\u0131r Numaralar\u0131ndan olu\u015fan bir S\u00fctun Olu\u015fturmak i\u00e7in MONOTONIC() i\u015flevini kullan\u0131n<\/strong><\/span><\/p>\n Y\u00f6ntem 2: Veri k\u00fcmesini sat\u0131r numaralar\u0131na g\u00f6re filtrelemek i\u00e7in MONOTONIC() i\u015flevini kullan\u0131n<\/strong><\/span><\/p>\n A\u015fa\u011f\u0131daki \u00f6rnekler, SAS’ta a\u015fa\u011f\u0131daki veri k\u00fcmesiyle her y\u00f6ntemin pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir:<\/span> <\/p>\n A\u015fa\u011f\u0131daki kod, veri k\u00fcmesindeki her g\u00f6zlem i\u00e7in sat\u0131r numaras\u0131n\u0131 (1’den ba\u015flayarak) i\u00e7eren row_ID<\/strong> adl\u0131 yeni bir s\u00fctun olu\u015fturmak i\u00e7in MONOTONIC()<\/strong> i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir:<\/span> <\/p>\n Veri k\u00fcmesindeki her g\u00f6zlemin 1’den 9’a kadar sat\u0131r numaras\u0131n\u0131 i\u00e7eren sat\u0131r_ID<\/strong> ad\u0131 verilen yeni bir s\u00fctunun olu\u015fturuldu\u011funu unutmay\u0131n.<\/span><\/p>\n A\u015fa\u011f\u0131daki kod, sat\u0131r numaras\u0131 5’ten k\u00fc\u00e7\u00fck olan bir veri k\u00fcmesini filtrelemek i\u00e7in MONOTONIC()<\/strong> i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir:<\/span> <\/p>\n Sat\u0131r numaras\u0131n\u0131n 5’ten k\u00fc\u00e7\u00fck olmas\u0131 gerekti\u011fini belirtmek i\u00e7in MONOTONIC()<\/strong> i\u015flevini kulland\u0131\u011f\u0131m\u0131zdan, veri k\u00fcmesinin yaln\u0131zca ilk d\u00f6rt sat\u0131r\u0131n\u0131n g\u00f6sterildi\u011fine dikkat edin.<\/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> Bir veri k\u00fcmesi i\u00e7in sat\u0131r numaralar\u0131 olu\u015fturmak \u00fczere SAS’taki MONOTONIC() i\u015flevini kullanabilirsiniz. Bu \u00f6zelli\u011fi pratikte kullanman\u0131n iki yayg\u0131n yolu \u015funlard\u0131r: Y\u00f6ntem 1: Sat\u0131r Numaralar\u0131ndan olu\u015fan bir S\u00fctun Olu\u015fturmak i\u00e7in MONOTONIC() i\u015flevini kullan\u0131n \/*create column called row_ID that contains row numbers*\/ proc sql ; select team, monotonic() as row_ID from my_data; quit ; Y\u00f6ntem 2: Veri […]<\/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-4546","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n \/*create column called row_ID that contains row numbers*\/\n<\/span>proc sql<\/span> ;\n select<\/span> team, monotonic() as<\/span> row_ID\n from<\/span> my_data;\nquit<\/span> ;<\/strong><\/span><\/pre>\n \/*filter where row number is less than 5*\/\n<\/span>proc sql<\/span> ;\n select<\/span> *\n from<\/span> my_data\n where<\/span> monotonic() < 5;\nquit<\/span> ;<\/strong><\/span><\/pre>\n \/*create dataset*\/\n<\/span>data<\/span> my_data;\n input<\/span> team $points assists;\n datalines<\/span> ;\nCavs 12 5\nCavs 14 7\nWarriors 15 9\nHawks 18 9\nMavs 31 7\nMavs 32 5\nMavs 35 3\nCeltics 36 9\nCeltics 40 7\n;\nrun<\/span> ;\n\n\/*view dataset*\/\n<\/span>proc print<\/span> data<\/span> =my_data;<\/strong><\/span> <\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/monotone1.png\")
<\/p>\n \u00d6rnek 1: Sat\u0131r numaralar\u0131ndan olu\u015fan bir s\u00fctun olu\u015fturmak i\u00e7in MONOTONIC() i\u015flevini kullan\u0131n<\/strong><\/span><\/h2>\n
\/*create column called row_ID that contains row numbers*\/\n<\/span>proc sql<\/span> ;\n select<\/span> team, monotonic() as<\/span> row_ID\n from<\/span> my_data;\nquit<\/span> ;<\/strong><\/span> <\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/monotone2.png\")
<\/p>\n \u00d6rnek 2: Veri k\u00fcmesini sat\u0131r numaralar\u0131na g\u00f6re filtrelemek i\u00e7in MONOTONIC() i\u015flevini kullan\u0131n<\/strong><\/span><\/h2>\n
\/*filter where row number is less than 5*\/\n<\/span>proc sql<\/span> ;\n select<\/span> *\n from<\/span> my_data\n where<\/span> monotonic() < 5;\nquit<\/span> ;<\/strong><\/span> <\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/monoton3.png\")
<\/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><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"