{"id":2645,"date":"2023-07-21T09:04:21","date_gmt":"2023-07-21T09:04:21","guid":{"rendered":"https:\/\/statorials.org\/id\/sas-proc-transpos\/"},"modified":"2023-07-21T09:04:21","modified_gmt":"2023-07-21T09:04:21","slug":"sas-proc-transpos","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/sas-proc-transpos\/","title":{"rendered":"Cara menggunakan proc transpose di sas (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan <strong>PROC TRANSPOSE<\/strong> di SAS untuk mengubah urutan kumpulan data dengan cepat dari <a href=\"https:\/\/statorials.org\/id\/data-panjang-vs-data-lebar\/\" target=\"_blank\" rel=\"noopener\">format panjang ke format lebar<\/a> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Fungsi ini menggunakan sintaks dasar berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #800080;\">proc transpose <span style=\"color: #000000;\"><span style=\"color: #3366ff;\">data<\/span> =long_data <span style=\"color: #3366ff;\">out<\/span> =wide_data;\n    <span style=\"color: #3366ff;\">by<\/span> var1;\n    <span style=\"color: #3366ff;\">idvar2<\/span> ;\n    <span style=\"color: #3366ff;\">var<\/span> var3;\n<span style=\"color: #800080;\">run<\/span> ;\n<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>by<\/strong> : Variabel yang akan ditempatkan di sepanjang garis<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>id<\/strong> : Variabel yang akan ditempatkan di sepanjang kolom<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>var<\/strong> : Variabel yang nilainya ditempatkan pada dataset<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan <strong>PROC TRANSPOSE<\/strong> dalam praktiknya.<\/span><\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Cara menggunakan PROC TRANSPOSE di SAS<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut dalam format panjang di SAS:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008000;\">\/*create dataset in long format*\/\n<span style=\"color: #000000;\"><span style=\"color: #800080;\">data<\/span> long_data;\n    <span style=\"color: #3366ff;\">input<\/span> team $variable $value;\n    <span style=\"color: #3366ff;\">datalines<\/span> ;\nA Points 88\nA Assists 12\nA Rebounds 22\nB Points 91\nB Assists 17\nB Rebounds 28\nC Points 99\nC Assists 24\nC Rebounds 30\nD Points 94\nD Assists 28\nD Rebounds 31\n;\n<span style=\"color: #800080;\">run<\/span> ;\n\n<span style=\"color: #008000;\">\/*view dataset*\/<\/span>\n<span style=\"color: #800080;\">proc print<\/span> <span style=\"color: #3366ff;\">data<\/span> =long_data;<\/span><\/span><\/strong><\/span> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23314 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/transposer1.jpg\" alt=\"\" width=\"200\" height=\"299\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan <strong>PROC TRANSPOSE<\/strong> untuk mengonversi kumpulan data ini dari format panjang ke format lebar:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008000;\">\/*create new dataset in wide format*\/\n<span style=\"color: #000000;\"><span style=\"color: #800080;\">proc transpose<\/span> <span style=\"color: #3366ff;\">data<\/span> =long_data <span style=\"color: #3366ff;\">out<\/span> =wide_data;\n    <span style=\"color: #3366ff;\">by<\/span> team;\n    <span style=\"color: #3366ff;\">variableid<\/span> ;\n    <span style=\"color: #3366ff;\">varvalue<\/span> ;\n<span style=\"color: #800080;\">run<\/span> ;\n\n<span style=\"color: #008000;\">\/*view wide data*\/\n<\/span><span style=\"color: #800080;\">proc print<\/span> <span style=\"color: #3366ff;\">data<\/span> =wide_data;<\/span><\/span><\/strong><\/span> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23315 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/transposer2.jpg\" alt=\"\" width=\"365\" height=\"137\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa dataset ini berisi informasi yang sama dengan dataset sebelumnya, namun hanya ditampilkan dalam format lebar.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Secara default, SAS membuat variabel <strong>_NAME_<\/strong> yang menunjukkan variabel mana yang digunakan untuk nilai dalam kumpulan data.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jangan ragu untuk menggunakan pernyataan <strong>DROP<\/strong> untuk menghapus variabel ini saat menggunakan <strong>PROC TRANSPOSE<\/strong> :<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008000;\">\/*create new dataset in wide format*\/\n<span style=\"color: #000000;\"><span style=\"color: #800080;\">proc transpose<\/span> <span style=\"color: #3366ff;\">data<\/span> =long_data <span style=\"color: #3366ff;\">out<\/span> =wide_data( <span style=\"color: #3366ff;\">drop<\/span> =_name_);\n    <span style=\"color: #3366ff;\">by<\/span> team;\n    <span style=\"color: #3366ff;\">variableid<\/span> ;\n    <span style=\"color: #3366ff;\">varvalue<\/span> ;\n<span style=\"color: #800080;\">run<\/span> ;\n\n<span style=\"color: #008000;\">\/*view wide data*\/\n<\/span><span style=\"color: #800080;\">proc print<\/span> <span style=\"color: #3366ff;\">data<\/span> =wide_data;<\/span><\/span><\/strong><\/span> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23316 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/transposer3.jpg\" alt=\"\" width=\"297\" height=\"136\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa variabel <strong>_NAME_<\/strong> telah dihapus dari kumpulan data.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\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\/proc-tabulasi-sas\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan Proc Tabulate 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 TRANSPOSE di SAS untuk mengubah urutan kumpulan data dengan cepat dari format panjang ke format lebar . Fungsi ini menggunakan sintaks dasar berikut: proc transpose data =long_data out =wide_data; by var1; idvar2 ; var var3; run ; Emas: by : Variabel yang akan ditempatkan di sepanjang garis id : Variabel yang [&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 Menggunakan PROC TRANSPOSE di SAS (dengan Contoh) - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan PROC TRANSPOSE di SAS untuk mengubah urutan dataset, dengan beberapa 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\/sas-proc-transpos\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menggunakan PROC TRANSPOSE di SAS (dengan Contoh) - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan PROC TRANSPOSE di SAS untuk mengubah urutan dataset, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/sas-proc-transpos\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-21T09:04:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/transposer1.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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/sas-proc-transpos\/\",\"url\":\"https:\/\/statorials.org\/id\/sas-proc-transpos\/\",\"name\":\"Cara Menggunakan PROC TRANSPOSE di SAS (dengan Contoh) - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-21T09:04:21+00:00\",\"dateModified\":\"2023-07-21T09:04:21+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan PROC TRANSPOSE di SAS untuk mengubah urutan dataset, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/sas-proc-transpos\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/sas-proc-transpos\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/sas-proc-transpos\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggunakan proc transpose 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 Menggunakan PROC TRANSPOSE di SAS (dengan Contoh) - Statorials","description":"Tutorial ini menjelaskan cara menggunakan PROC TRANSPOSE di SAS untuk mengubah urutan dataset, dengan beberapa 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\/sas-proc-transpos\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menggunakan PROC TRANSPOSE di SAS (dengan Contoh) - Statorials","og_description":"Tutorial ini menjelaskan cara menggunakan PROC TRANSPOSE di SAS untuk mengubah urutan dataset, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/sas-proc-transpos\/","og_site_name":"Statorials","article_published_time":"2023-07-21T09:04:21+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/transposer1.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/sas-proc-transpos\/","url":"https:\/\/statorials.org\/id\/sas-proc-transpos\/","name":"Cara Menggunakan PROC TRANSPOSE di SAS (dengan Contoh) - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-21T09:04:21+00:00","dateModified":"2023-07-21T09:04:21+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan PROC TRANSPOSE di SAS untuk mengubah urutan dataset, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/sas-proc-transpos\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/sas-proc-transpos\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/sas-proc-transpos\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggunakan proc transpose 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\/2645"}],"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=2645"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2645\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2645"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2645"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2645"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}