{"id":4433,"date":"2023-07-11T03:45:15","date_gmt":"2023-07-11T03:45:15","guid":{"rendered":"https:\/\/statorials.org\/id\/tanpa-menggabungkan-satu-ke-banyak\/"},"modified":"2023-07-11T03:45:15","modified_gmt":"2023-07-11T03:45:15","slug":"tanpa-menggabungkan-satu-ke-banyak","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/tanpa-menggabungkan-satu-ke-banyak\/","title":{"rendered":"Cara melakukan penggabungan satu-ke-banyak di sas"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks berikut untuk melakukan penggabungan satu-ke-banyak di SAS:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #800080;\">data<\/span> final_data;\n  <span style=\"color: #3366ff;\">merge<\/span> data_one data_many;\n  <span style=\"color: #3366ff;\">byID<\/span> ;\n<span style=\"color: #800080;\">run<\/span> ;\n<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Contoh khusus ini membuat kumpulan data baru bernama <strong>final_data<\/strong> dengan menggabungkan kumpulan data bernama <strong>data_one<\/strong> dan <strong>data_many<\/strong> pada variabel bernama <strong>ID<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dalam kumpulan data <strong>data_one<\/strong> , setiap nilai ID unik hanya muncul satu kali.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dalam kumpulan data <strong>data_many<\/strong> , setiap nilai ID unik muncul beberapa kali.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini disebut penggabungan satu ke banyak.<\/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: Penggabungan satu-ke-banyak di SAS<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut bernama <strong>data_one<\/strong> yang berisi informasi tentang staf penjualan suatu perusahaan:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008000;\">\/*create dataset*\/\n<\/span><span style=\"color: #800080;\">data<\/span> data_one;\n    <span style=\"color: #3366ff;\">inputIDGender<\/span> $;\n    <span style=\"color: #3366ff;\">datalines<\/span> ;\n1 Male\n2 Male\n3 Female\n4 Male\n5 Female\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> = data_one;<\/strong><\/span> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34729 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/otm1.png\" alt=\"\" width=\"156\" height=\"170\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Perhatikan bahwa setiap nilai ID unik hanya muncul satu kali dalam kumpulan data.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Sekarang misalkan kita memiliki kumpulan data lain bernama <strong>data_many<\/strong> yang berisi informasi tentang penjualan yang dilakukan oleh setiap penjual di lokasi berbeda:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008000;\">\/*create dataset*\/\n<\/span><span style=\"color: #800080;\">data<\/span> data_many;\n    <span style=\"color: #3366ff;\">input<\/span> Store ID $Sales;\n    <span style=\"color: #3366ff;\">datalines<\/span> ;\n1 to 22\n1 B 25\n1 C 20\n2 to 14\n2 B 23\n3 to 10\n4 to 15\n4 B 29\n5 to 16\n5 C 22\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> = data_many;<\/strong><\/span> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34730 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/otm2.png\" alt=\"\" width=\"207\" height=\"306\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa setiap nilai ID unik muncul beberapa kali.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks berikut untuk melakukan penggabungan satu-ke-banyak menggunakan kumpulan data berikut:<\/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 new dataset using one-to-many merge*\/<\/span>\ndata<\/span> final_data;\n  <span style=\"color: #3366ff;\">merge<\/span> data_one data_many;\n  <span style=\"color: #3366ff;\">byID<\/span> ;\n<span style=\"color: #800080;\">run<\/span> ;\n\n<span style=\"color: #800080;\"><span style=\"color: #008000;\">\/*view new dataset*\/\n<\/span>proc print<\/span> <span style=\"color: #3366ff;\">data<\/span> =final_data;<\/strong><\/span> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34731 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/otm3.png\" alt=\"\" width=\"276\" height=\"318\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Penggabungan satu-ke-banyak menghasilkan kumpulan data baru yang berisi semua informasi dari kedua kumpulan data.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk pernyataan <strong>penggabungan<\/strong> SAS <a href=\"https:\/\/documentation.sas.com\/doc\/en\/pgmsascdc\/9.4_3.5\/lestmtsref\/n1i8w2bwu1fn5kn1gpxj18xttbb0.htm\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/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\/tanpa-kiri-bergabung\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara melakukan gabung kiri di SAS<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/sas-gabung-dalam\/\" target=\"_blank\" rel=\"noopener\">Cara melakukan inner join di SAS<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/sas-gabungan-luar\/\" target=\"_blank\" rel=\"noopener\">Cara melakukan penggabungan eksternal di SAS<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks berikut untuk melakukan penggabungan satu-ke-banyak di SAS: data final_data; merge data_one data_many; byID ; run ; Contoh khusus ini membuat kumpulan data baru bernama final_data dengan menggabungkan kumpulan data bernama data_one dan data_many pada variabel bernama ID . Dalam kumpulan data data_one , setiap nilai ID unik hanya muncul satu kali. [&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 melakukan penggabungan satu-ke-banyak di SAS - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara melakukan penggabungan satu-ke-banyak 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\/tanpa-menggabungkan-satu-ke-banyak\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara melakukan penggabungan satu-ke-banyak di SAS - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara melakukan penggabungan satu-ke-banyak di SAS, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/tanpa-menggabungkan-satu-ke-banyak\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-11T03:45:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/otm1.png\" \/>\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\/tanpa-menggabungkan-satu-ke-banyak\/\",\"url\":\"https:\/\/statorials.org\/id\/tanpa-menggabungkan-satu-ke-banyak\/\",\"name\":\"Cara melakukan penggabungan satu-ke-banyak di SAS - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-11T03:45:15+00:00\",\"dateModified\":\"2023-07-11T03:45:15+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara melakukan penggabungan satu-ke-banyak di SAS, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/tanpa-menggabungkan-satu-ke-banyak\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/tanpa-menggabungkan-satu-ke-banyak\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/tanpa-menggabungkan-satu-ke-banyak\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara melakukan penggabungan satu-ke-banyak di sas\"}]},{\"@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 melakukan penggabungan satu-ke-banyak di SAS - Statorials","description":"Tutorial ini menjelaskan cara melakukan penggabungan satu-ke-banyak 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\/tanpa-menggabungkan-satu-ke-banyak\/","og_locale":"id_ID","og_type":"article","og_title":"Cara melakukan penggabungan satu-ke-banyak di SAS - Statorials","og_description":"Tutorial ini menjelaskan cara melakukan penggabungan satu-ke-banyak di SAS, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/tanpa-menggabungkan-satu-ke-banyak\/","og_site_name":"Statorials","article_published_time":"2023-07-11T03:45:15+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/otm1.png"}],"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\/tanpa-menggabungkan-satu-ke-banyak\/","url":"https:\/\/statorials.org\/id\/tanpa-menggabungkan-satu-ke-banyak\/","name":"Cara melakukan penggabungan satu-ke-banyak di SAS - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-11T03:45:15+00:00","dateModified":"2023-07-11T03:45:15+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara melakukan penggabungan satu-ke-banyak di SAS, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/tanpa-menggabungkan-satu-ke-banyak\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/tanpa-menggabungkan-satu-ke-banyak\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/tanpa-menggabungkan-satu-ke-banyak\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara melakukan penggabungan satu-ke-banyak di sas"}]},{"@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\/4433"}],"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=4433"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4433\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4433"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4433"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4433"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}