Bunu yapman\u0131n iki yolu vard\u0131r:<\/span><\/p>\n 1.<\/strong> S\u0131f\u0131rdan bir pano olu\u015fturun<\/span><\/p>\n 2.<\/strong> Mevcut verilerden bir tablo olu\u015fturun<\/span><\/p>\n A\u015fa\u011f\u0131daki \u00f6rneklerde her ikisinin de proc sql<\/strong> kullan\u0131larak nas\u0131l yap\u0131laca\u011f\u0131 g\u00f6sterilmektedir.<\/span><\/p>\n A\u015fa\u011f\u0131daki kod, SAS’ta proc sql<\/strong> kullan\u0131larak \u00fc\u00e7 s\u00fctunlu bir tablonun nas\u0131l olu\u015fturulaca\u011f\u0131n\u0131 g\u00f6sterir:<\/span> <\/p>\n Bo\u015f bir tablo olu\u015fturmak i\u00e7in create table’\u0131<\/strong> kulland\u0131k, sonra tabloya de\u011fer eklemek i\u00e7in insert into’u<\/strong> kulland\u0131k, sonra tabloyu g\u00f6r\u00fcnt\u00fclemek i\u00e7in select * from’u<\/strong> kulland\u0131k.<\/span><\/p>\n Sonu\u00e7, farkl\u0131 basketbol tak\u0131mlar\u0131 hakk\u0131nda \u00e7e\u015fitli bilgilerin g\u00f6r\u00fcnt\u00fclendi\u011fi \u00fc\u00e7 s\u00fctunlu bir tablodur.<\/span><\/p>\n A\u015fa\u011f\u0131daki kod, \u00f6nceki \u00f6rnekte olu\u015fturdu\u011fumuz mevcut bir veri k\u00fcmesini kullanarak bir tablo olu\u015fturmak i\u00e7in proc sql’nin<\/strong> nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir:<\/span> <\/p>\n Sonu\u00e7, mevcut bir veri k\u00fcmesindeki de\u011ferleri i\u00e7eren iki s\u00fctun i\u00e7eren bir tablodur.<\/span><\/p>\n Not<\/strong> : Tabloda kullan\u0131lacak s\u00fctun adlar\u0131n\u0131 belirtmek i\u00e7in as<\/strong> i\u015flevini kulland\u0131k ancak s\u00fctunlar\u0131 yeniden adland\u0131rmak istemiyorsan\u0131z as<\/strong> i\u015flevini kullanman\u0131za gerek yoktur.<\/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’ta frekans tablolar\u0131 nas\u0131l olu\u015fturulur?<\/a> SAS’ta h\u0131zl\u0131 bir \u015fekilde tablo olu\u015fturmak i\u00e7in proc sql’yi kullanabilirsiniz. Bunu yapman\u0131n iki yolu vard\u0131r: 1. S\u0131f\u0131rdan bir pano olu\u015fturun 2. Mevcut verilerden bir tablo olu\u015fturun A\u015fa\u011f\u0131daki \u00f6rneklerde her ikisinin de proc sql kullan\u0131larak nas\u0131l yap\u0131laca\u011f\u0131 g\u00f6sterilmektedir. \u00d6rnek 1: S\u0131f\u0131rdan bir tablo olu\u015fturun A\u015fa\u011f\u0131daki kod, SAS’ta proc sql kullan\u0131larak \u00fc\u00e7 s\u00fctunlu bir tablonun nas\u0131l olu\u015fturulaca\u011f\u0131n\u0131 […]<\/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-3667","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n \u00d6rnek 1: S\u0131f\u0131rdan bir tablo olu\u015fturun<\/strong><\/span><\/h2>\n
\/*create empty table*\/\n<\/span>proc sql<\/span> ;\n create table<\/span> my_table\n (team char(10),\n number points,\n rebounds num);\n\n\/*insert values into table*\/ \n<\/span>insert into<\/span> my_table\n values<\/span> ('Mavs', 99, 22)\n values<\/span> ('Hawks', 104, 20)\n values<\/span> ('Hornets', 88, 25)\n values<\/span> ('Lakers', 113, 19)\n values<\/span> ('Warriors', 109, 32);\n\n\/*display table*\/\n<\/span>select<\/span> * from<\/span> my_table;\nrun<\/span> ;\n<\/strong><\/pre>\n![\"SAS'ta](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tablesas1.jpg\")
<\/p>\n \u00d6rnek 2: Mevcut verilerden tablo olu\u015fturma<\/strong><\/span><\/h2>\n
\/*create table from existing dateset*\/\n<\/span>proc sql<\/span> ;\n create table<\/span> my_table2 as<\/span>\n select<\/span> team as<\/span> Team_Name,\n points as<\/span> Points_Scored\n from<\/span> my_table;\n \n\/*display table*\/\n<\/span>select<\/span> * from<\/span> my_table2;\nrun<\/span> ;\n<\/strong><\/span><\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tablesas2.jpg\")
<\/p>\n Ek kaynaklar<\/strong><\/span><\/h2>\n
SAS’ta farkl\u0131 de\u011ferler nas\u0131l say\u0131l\u0131r?<\/a>
SAS’ta g\u00f6zlemler gruba g\u00f6re nas\u0131l say\u0131l\u0131r?<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"