{"id":4436,"date":"2023-07-11T03:15:00","date_gmt":"2023-07-11T03:15:00","guid":{"rendered":"https:\/\/statorials.org\/id\/tanpa-penggabungan-dua-variabel\/"},"modified":"2023-07-11T03:15:00","modified_gmt":"2023-07-11T03:15:00","slug":"tanpa-penggabungan-dua-variabel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/tanpa-penggabungan-dua-variabel\/","title":{"rendered":"Sas: cara menggabungkan dataset berdasarkan dua variabel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks dasar berikut untuk menggabungkan dua kumpulan data di SAS berdasarkan kecocokan dua variabel:<\/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> data1(in=a) data2(in=b);\n  <span style=\"color: #3366ff;\">by<\/span> ID Store;\n  <span style=\"color: #3366ff;\">if<\/span> a <span style=\"color: #3366ff;\">and<\/span> b;\n<span style=\"color: #800080;\">run<\/span> ;<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Contoh khusus ini menggabungkan kumpulan data yang disebut <strong>data1<\/strong> dan <strong>data2<\/strong> berdasarkan variabel yang disebut <strong>ID<\/strong> dan <strong>Store<\/strong> dan hanya mengembalikan baris yang memiliki nilai di kedua kumpulan data.<\/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: Menggabungkan Kumpulan Data di SAS Berdasarkan Dua Variabel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut di SAS yang berisi informasi tentang tenaga penjualan suatu perusahaan:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008000;\">\/*create first dataset*\/\n<\/span><span style=\"color: #800080;\">data<\/span> data1;\n    <span style=\"color: #3366ff;\">inputStoreID<\/span> $;\n    <span style=\"color: #3366ff;\">datalines<\/span> ;\n1A\n1B\n1 C\n2A\n2C\n3A\n3 B\n;\n<span style=\"color: #800080;\">run<\/span> ;\n\n<span style=\"color: #008000;\">\/*view first dataset*\/\n<\/span><span style=\"color: #3366ff;\">title<\/span> \"data1\";\n<span style=\"color: #800080;\">proc print<\/span> <span style=\"color: #3366ff;\">data<\/span> = data1;<\/strong><\/span> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34751 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/par1.png\" alt=\"\" width=\"194\" height=\"233\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dan misalkan kita memiliki kumpulan data lain yang berisi informasi tentang penjualan yang dilakukan di toko berbeda oleh masing-masing rekanan:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008000;\">\/*create second dataset*\/\n<\/span><span style=\"color: #800080;\">data<\/span> data2;\n    <span style=\"color: #3366ff;\">input<\/span> Store ID $Sales;\n    <span style=\"color: #3366ff;\">datalines<\/span> ;\n1 to 22\n1 B 25\n2 to 40\n2 B 24\n2 C 29\n3 to 12\n3 B 15\n;\n<span style=\"color: #800080;\">run<\/span> ;\n\n<span style=\"color: #008000;\">\/*view second dataset*\/\n<\/span><span style=\"color: #3366ff;\">title<\/span> \"data2\";\n<span style=\"color: #800080;\">proc print<\/span> <span style=\"color: #3366ff;\">data<\/span> = data2;\n<\/strong><\/span><\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34752 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/par2.png\" alt=\"\" width=\"249\" height=\"258\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan pernyataan <strong>penggabungan<\/strong> berikut untuk menggabungkan dua kumpulan data berdasarkan nilai yang cocok di kolom <strong>ID<\/strong> <em>dan<\/em> <strong>Store<\/strong> , lalu hanya mengembalikan baris yang memiliki nilai di kedua kolom:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #800080;\"><span style=\"color: #008000;\">\/*perform merge*\/<\/span>\n<span style=\"color: #000000;\"><span style=\"color: #800080;\">data<\/span> final_data;\n  <span style=\"color: #3366ff;\">merge<\/span> data1(in=a) data2(in=b);\n  <span style=\"color: #3366ff;\">by<\/span> ID Store;\n  <span style=\"color: #3366ff;\">if<\/span> a <span style=\"color: #3366ff;\">and<\/span> b;\n<span style=\"color: #800080;\">run<\/span> ;\n\n<span style=\"color: #008000;\">\/*view results*\/\n<\/span><span style=\"color: #3366ff;\">title<\/span> \"final_data\";\n<span style=\"color: #800080;\">proc print<\/span> <span style=\"color: #3366ff;\">data<\/span> =final_data;\n<\/span><\/span><\/strong><\/span><\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34753 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/par3.png\" alt=\"\" width=\"213\" height=\"228\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kumpulan data yang dihasilkan mengembalikan baris yang nilai kolom <strong>ID<\/strong> dan <strong>Tokonya<\/strong> cocok.<\/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-menggabungkan-satu-ke-banyak\/\" target=\"_blank\" rel=\"noopener\">SAS: Cara melakukan penggabungan satu ke banyak<\/a><br \/><a href=\"https:\/\/statorials.org\/id\/tidak-menggabungkan-a-menjadi-b\/\" target=\"_blank\" rel=\"noopener\">SAS: Cara menggunakan (in=a) dalam pernyataan penggabungan<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/tidak-bergabung-jika-a-tidak-b\/\" target=\"_blank\" rel=\"noopener\">SAS: Bagaimana cara menggabungkan jika A bukan B<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks dasar berikut untuk menggabungkan dua kumpulan data di SAS berdasarkan kecocokan dua variabel: data final_data; merge data1(in=a) data2(in=b); by ID Store; if a and b; run ; Contoh khusus ini menggabungkan kumpulan data yang disebut data1 dan data2 berdasarkan variabel yang disebut ID dan Store dan hanya mengembalikan baris yang memiliki [&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>SAS: Cara menggabungkan kumpulan data berdasarkan dua variabel - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggabungkan dua kumpulan data di SAS berdasarkan dua variabel, beserta 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-penggabungan-dua-variabel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SAS: Cara menggabungkan kumpulan data berdasarkan dua variabel - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggabungkan dua kumpulan data di SAS berdasarkan dua variabel, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/tanpa-penggabungan-dua-variabel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-11T03:15:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/par1.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-penggabungan-dua-variabel\/\",\"url\":\"https:\/\/statorials.org\/id\/tanpa-penggabungan-dua-variabel\/\",\"name\":\"SAS: Cara menggabungkan kumpulan data berdasarkan dua variabel - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-11T03:15:00+00:00\",\"dateModified\":\"2023-07-11T03:15:00+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggabungkan dua kumpulan data di SAS berdasarkan dua variabel, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/tanpa-penggabungan-dua-variabel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/tanpa-penggabungan-dua-variabel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/tanpa-penggabungan-dua-variabel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Sas: cara menggabungkan dataset berdasarkan dua variabel\"}]},{\"@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":"SAS: Cara menggabungkan kumpulan data berdasarkan dua variabel - Statorial","description":"Tutorial ini menjelaskan cara menggabungkan dua kumpulan data di SAS berdasarkan dua variabel, beserta 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-penggabungan-dua-variabel\/","og_locale":"id_ID","og_type":"article","og_title":"SAS: Cara menggabungkan kumpulan data berdasarkan dua variabel - Statorial","og_description":"Tutorial ini menjelaskan cara menggabungkan dua kumpulan data di SAS berdasarkan dua variabel, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/tanpa-penggabungan-dua-variabel\/","og_site_name":"Statorials","article_published_time":"2023-07-11T03:15:00+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/par1.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-penggabungan-dua-variabel\/","url":"https:\/\/statorials.org\/id\/tanpa-penggabungan-dua-variabel\/","name":"SAS: Cara menggabungkan kumpulan data berdasarkan dua variabel - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-11T03:15:00+00:00","dateModified":"2023-07-11T03:15:00+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggabungkan dua kumpulan data di SAS berdasarkan dua variabel, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/tanpa-penggabungan-dua-variabel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/tanpa-penggabungan-dua-variabel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/tanpa-penggabungan-dua-variabel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Sas: cara menggabungkan dataset berdasarkan dua variabel"}]},{"@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\/4436"}],"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=4436"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4436\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4436"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4436"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4436"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}