Bu prosed\u00fcr a\u015fa\u011f\u0131daki temel s\u00f6zdizimini kullan\u0131r:<\/span><\/p>\n Class<\/strong> ifadesi gruplanacak de\u011fi\u015fkeni belirtir, var<\/strong> ifadesi \u00f6zetlenecek say\u0131sal de\u011fi\u015fkenleri belirtir ve table<\/strong> ifadesi pivot tablonun format\u0131n\u0131 belirtir.<\/span><\/p>\n A\u015fa\u011f\u0131daki \u00f6rnek, bu s\u00f6zdiziminin pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir.<\/span><\/p>\n SAS’ta \u00e7e\u015fitli marketlerde yap\u0131lan sat\u0131\u015f ve iade say\u0131lar\u0131na ili\u015fkin bilgileri i\u00e7eren a\u015fa\u011f\u0131daki veri k\u00fcmesine sahip oldu\u011fumuzu varsayal\u0131m:<\/span> <\/p>\n \u015eimdi her ma\u011fazadaki sat\u0131\u015f ve iadelerin toplam\u0131n\u0131 \u00f6zetleyen bir pivot tablo olu\u015fturmak istedi\u011fimizi varsayal\u0131m.<\/span><\/p>\n Bunu yapmak i\u00e7in a\u015fa\u011f\u0131daki s\u00f6zdizimini kullanabiliriz:<\/span> <\/p>\n Ortaya \u00e7\u0131kan pivot tablo, her ma\u011fazadaki sat\u0131\u015flar\u0131n ve iadelerin toplam\u0131n\u0131 g\u00f6sterir.<\/span><\/p>\n \u00d6rne\u011fin \u015funu g\u00f6rebiliriz:<\/span><\/p>\n Ve benzeri.<\/span><\/p>\n Varsay\u0131lan olarak SAS, pivot tablodaki her say\u0131sal de\u011fi\u015fkenin toplam\u0131n\u0131 hesaplar.<\/span><\/p>\n Ancak ortalama de\u011feri hesaplamak i\u00e7in her say\u0131sal de\u011fi\u015fkenin ard\u0131ndan *Ortalama<\/strong> yazabilirsiniz:<\/span> <\/p>\n Ortaya \u00e7\u0131kan pivot tablo, her ma\u011fazadaki ortalama sat\u0131\u015flar\u0131 ve iadeleri g\u00f6sterir.<\/span><\/p>\n \u00d6rne\u011fin \u015funu g\u00f6rebiliriz:<\/span><\/p>\n Ve benzeri.<\/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 prosed\u00fcr \u00f6zeti nas\u0131l kullan\u0131l\u0131r?<\/a> Bir veri k\u00fcmesindeki de\u011fi\u015fkenleri \u00f6zetlemek amac\u0131yla pivot tablolar olu\u015fturmak i\u00e7in SAS’ta PROC TABULATE’i kullanabilirsiniz. Bu prosed\u00fcr a\u015fa\u011f\u0131daki temel s\u00f6zdizimini kullan\u0131r: proc tabulate data =my_data; class var1; var var2 var3; table var1, var2 var3; run ; Class ifadesi gruplanacak de\u011fi\u015fkeni belirtir, var ifadesi \u00f6zetlenecek say\u0131sal de\u011fi\u015fkenleri belirtir ve table ifadesi pivot tablonun format\u0131n\u0131 belirtir. A\u015fa\u011f\u0131daki \u00f6rnek, […]<\/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-4218","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n proc tabulate<\/span> data<\/span> =my_data;\n class<\/span> var1;\n var<\/span> var2 var3;\n table<\/span> var1, var2 var3;\nrun<\/span> ;\n<\/strong><\/span><\/pre>\n \u00d6rnek: SAS’ta PivotTable Olu\u015fturmak i\u00e7in Proc Tabulate’i Kullanma<\/strong><\/span><\/h2>\n
\/*create dataset*\/\ndata<\/span> my_data;\n input<\/span> store $sales returns;\n datalines<\/span> ;\nAt 10 2\nAt 7 0\nAt 7 1\nAt 8 1\nAt 6 0\nB 10 2\nB 14 5\nB 13 4\nB 9 0\nB-52\nC 12 1\nC 10 1\nC 10 3\nC 12 4\nC 9 1\n;\nrun<\/span> ;\n\n\/*view dataset*\/\n<\/span>proc print<\/span> data<\/span> =my_data;\n<\/span><\/span><\/strong><\/span><\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivotsas1.jpg\")
<\/p>\n \/*create pivot table to summarize sum of sales and returns by store*\/<\/span>\nproc tabulate<\/span> data<\/span> =my_data;\n classstore<\/span> ;\n var<\/span> salesreturns;\n table<\/span> store, sales returns;\nrun<\/span> ;<\/strong><\/span> <\/pre>\n![\"SAS'ta](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivotsas2.jpg\")
<\/p>\n\n
\/*create pivot table to summarize mean of sales and returns by store*\/<\/span>\nproc tabulate<\/span> data<\/span> =my_data;\n classstore<\/span> ;\n var<\/span> salesreturns;\n table<\/span> store, sales*Mean returns*Mean;\nrun<\/span> ;<\/strong><\/span> <\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivotsas3.jpg\")
<\/p>\n\n
Ek kaynaklar<\/strong><\/span><\/h2>\n
SAS’ta korelasyon nas\u0131l hesaplan\u0131r?<\/a>
SAS’ta frekans tablolar\u0131 nas\u0131l olu\u015fturulur?<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"