{"id":4217,"date":"2023-07-12T18:44:36","date_gmt":"2023-07-12T18:44:36","guid":{"rendered":"https:\/\/statorials.org\/id\/tabel-pivot-sas\/"},"modified":"2023-07-12T18:44:36","modified_gmt":"2023-07-12T18:44:36","slug":"tabel-pivot-sas","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/tabel-pivot-sas\/","title":{"rendered":"Cara membuat pivottable di sas (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan <strong>PROC TABULATE<\/strong> di SAS untuk membuat tabel pivot guna meringkas variabel dalam kumpulan data.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Prosedur ini menggunakan sintaks dasar berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #800080;\">proc tabulate<\/span> <span style=\"color: #3366ff;\">data<\/span> =my_data;\n    <span style=\"color: #3366ff;\">class<\/span> var1;\n    <span style=\"color: #3366ff;\">var<\/span> var2 var3;\n    <span style=\"color: #3366ff;\">table<\/span> var1, var2 var3;\n<span style=\"color: #800080;\">run<\/span> ;\n<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Pernyataan <strong>kelas<\/strong> menentukan variabel yang akan dikelompokkan, pernyataan <strong>var<\/strong> menentukan variabel numerik yang akan diringkas, dan pernyataan <strong>tabel<\/strong> menentukan format tabel pivot.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Gunakan Tabulasi Proc untuk Membuat PivotTable di SAS<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Anggaplah kita memiliki kumpulan data berikut di SAS yang berisi informasi tentang jumlah penjualan dan pengembalian yang dilakukan di berbagai toko grosir:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008000;\">\/*create dataset*\/\n<span style=\"color: #000000;\"><span style=\"color: #800080;\">data<\/span> my_data;\n    <span style=\"color: #3366ff;\">input<\/span> store $sales returns;\n    <span style=\"color: #3366ff;\">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;\n<span style=\"color: #800080;\">run<\/span> ;\n\n<span style=\"color: #008000;\">\/*view dataset*\/\n<\/span><span style=\"color: #800080;\">proc print<\/span> <span style=\"color: #3366ff;\">data<\/span> =my_data;\n<\/span><\/span><\/strong><\/span><\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-33365 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivotsas1.jpg\" alt=\"\" width=\"214\" height=\"404\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekarang misalkan kita ingin membuat tabel pivot yang merangkum jumlah penjualan dan pengembalian di setiap toko.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks berikut untuk melakukan ini:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #800080;\"><span style=\"color: #008000;\">\/*create pivot table to summarize sum of sales and returns by store*\/<\/span>\nproc tabulate<\/span> <span style=\"color: #3366ff;\">data<\/span> =my_data;\n    <span style=\"color: #3366ff;\">classstore<\/span> ;\n    <span style=\"color: #3366ff;\">var<\/span> salesreturns;\n    <span style=\"color: #3366ff;\">table<\/span> store, sales returns;\n<span style=\"color: #800080;\">run<\/span> ;<\/strong><\/span> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-33366\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivotsas2.jpg\" alt=\"tabel pivot di SAS\" width=\"186\" height=\"174\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Tabel pivot yang dihasilkan menunjukkan jumlah penjualan dan pengembalian di setiap toko.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita dapat melihat:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Jumlah penjualan yang dilakukan di toko A adalah <strong>38<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Jumlah pengembalian yang dilakukan untuk menyimpan A adalah <strong>4<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Jumlah penjualan yang dilakukan di toko B adalah <strong>51<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Jumlah pengembalian yang dilakukan ke toko B adalah <strong>13<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Secara default, SAS menghitung jumlah setiap variabel numerik dalam tabel pivot.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Namun, Anda dapat mengetikkan <strong>*Average<\/strong> setelah setiap variabel numerik untuk menghitung nilai rata-rata:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #800080;\"><span style=\"color: #008000;\">\/*create pivot table to summarize mean of sales and returns by store*\/<\/span>\nproc tabulate<\/span> <span style=\"color: #3366ff;\">data<\/span> =my_data;\n    <span style=\"color: #3366ff;\">classstore<\/span> ;\n    <span style=\"color: #3366ff;\">var<\/span> salesreturns;\n    <span style=\"color: #3366ff;\">table<\/span> store, sales*Mean returns*Mean;\n<span style=\"color: #800080;\">run<\/span> ;<\/strong><\/span> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-33367 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivotsas3.jpg\" alt=\"\" width=\"172\" height=\"158\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Tabel pivot yang dihasilkan menunjukkan rata-rata penjualan dan pengembalian di setiap toko.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita dapat melihat:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Nilai rata-rata penjualan yang dilakukan di toko A adalah <strong>7,6<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Nilai rata-rata pengembalian yang dilakukan di toko A adalah <strong>0,80<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Nilai rata-rata penjualan yang dilakukan di toko B adalah <strong>10,2<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Nilai rata-rata pengembalian yang dilakukan di toko B adalah <strong>2,6<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di SAS:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/prosedur-ringkasan-di-sas\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan ringkasan prosedur di SAS<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/korelasi-di-airlock\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung korelasi di SAS<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/tabel-frekuensi-sas\/\" target=\"_blank\" rel=\"noopener\">Cara membuat tabel frekuensi di SAS<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan PROC TABULATE di SAS untuk membuat tabel pivot guna meringkas variabel dalam kumpulan data. Prosedur ini menggunakan sintaks dasar berikut: proc tabulate data =my_data; class var1; var var2 var3; table var1, var2 var3; run ; Pernyataan kelas menentukan variabel yang akan dikelompokkan, pernyataan var menentukan variabel numerik yang akan diringkas, dan pernyataan [&hellip;]<\/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":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cara Membuat PivotTable di SAS (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat tabel pivot di SAS, dengan sebuah contoh.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/tabel-pivot-sas\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat PivotTable di SAS (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat tabel pivot di SAS, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/tabel-pivot-sas\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-12T18:44:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivotsas1.jpg\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/tabel-pivot-sas\/\",\"url\":\"https:\/\/statorials.org\/id\/tabel-pivot-sas\/\",\"name\":\"Cara Membuat PivotTable di SAS (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-12T18:44:36+00:00\",\"dateModified\":\"2023-07-12T18:44:36+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat tabel pivot di SAS, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/tabel-pivot-sas\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/tabel-pivot-sas\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/tabel-pivot-sas\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat pivottable di sas (dengan contoh)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cara Membuat PivotTable di SAS (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara membuat tabel pivot di SAS, dengan sebuah contoh.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/statorials.org\/id\/tabel-pivot-sas\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat PivotTable di SAS (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara membuat tabel pivot di SAS, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/tabel-pivot-sas\/","og_site_name":"Statorials","article_published_time":"2023-07-12T18:44:36+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivotsas1.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/tabel-pivot-sas\/","url":"https:\/\/statorials.org\/id\/tabel-pivot-sas\/","name":"Cara Membuat PivotTable di SAS (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-12T18:44:36+00:00","dateModified":"2023-07-12T18:44:36+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat tabel pivot di SAS, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/tabel-pivot-sas\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/tabel-pivot-sas\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/tabel-pivot-sas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat pivottable di sas (dengan contoh)"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4217"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=4217"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4217\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4217"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4217"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4217"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}