{"id":4228,"date":"2023-07-12T16:50:04","date_gmt":"2023-07-12T16:50:04","guid":{"rendered":"https:\/\/statorials.org\/id\/sas-gabungan-luar\/"},"modified":"2023-07-12T16:50:04","modified_gmt":"2023-07-12T16:50:04","slug":"sas-gabungan-luar","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/sas-gabungan-luar\/","title":{"rendered":"Cara melakukan outer join di sas (dengan contoh)"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan sintaks dasar berikut untuk melakukan gabungan luar dengan dua kumpulan data di SAS:<\/span><\/p>\n

 proc sql<\/span> ;\n    create table<\/span> final_table as<\/span>\n    select<\/span> coalesce(x.team, y.team) as<\/span> team, x.team, x.points, y.team, y.assists\n    from<\/span> data1 as<\/span> x full join<\/span> data2 as<\/span> y\n    on<\/span> x.team = y.team;\nquit<\/span> ;<\/strong><\/span><\/pre>\n
 Contoh khusus ini melakukan penggabungan luar menggunakan pernyataan gabungan penuh<\/strong> dan mengembalikan semua baris dalam kumpulan data yang disebut data1<\/strong> dan data2<\/strong> .<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Contoh: Melakukan Outer Join di SAS<\/strong><\/span><\/h2>\n
 Misalkan kita memiliki dua kumpulan data berikut di SAS yang berisi informasi tentang berbagai tim bola basket:<\/span> <\/p>\n
 \/*create datasets*\/\ndata<\/span> data1;\n    input<\/span> team $points;\n    datalines<\/span> ;\nAt 18\nB22\nC19\nD 14\nE14\nF 11\nG20\nH 28 \n;\nrun<\/span> ;\n\ndata<\/span> data2;\n    input<\/span> team $assists;\n    datalines<\/span> ;\nAt 4\nB9\nC14\nD 13\nL 10\nM 8\n;\nrun<\/span> ;\n\n\/*view datasets*\/\n<\/span>proc print<\/span> data<\/span> =data1;\nproc print<\/span> data<\/span> =data2;<\/span><\/span><\/strong> <\/pre>\n
\"\"<\/p>\n
 Kita dapat menggunakan sintaks berikut untuk melakukan penggabungan luar dan membuat kumpulan data baru yang berisi setiap baris dari kedua kumpulan data:<\/span> <\/p>\n
 \/*perform outer join*\/<\/span>\nproc sql<\/span> ;\n    create table<\/span> final_table as<\/span>\n    select<\/span> coalesce(x.team, y.team) as<\/span> team, x.team, x.points, y.team, y.assists\n    from<\/span> data1 as<\/span> x full join<\/span> data2 as<\/span> y\n    on<\/span> x.team = y.team;\nquit<\/span> ;\n\n\/*view results of outer join*\/\n<\/span>proc print<\/span> data<\/span> =final_table;\n<\/strong><\/span><\/pre>\n
\"\"<\/p>\n
 Kumpulan data yang dihasilkan berisi setiap baris dari setiap kumpulan data individual.<\/span><\/p>\n
 Perhatikan bahwa kami harus menggunakan fungsi COALESCE<\/a> untuk memastikan bahwa nama tim dari kedua kumpulan data dikembalikan dalam kumpulan data yang dihasilkan.<\/span><\/span><\/p>\n
 Jika kita tidak menggunakan fungsi ini, hanya nilai kolom tim dari dataset pertama yang akan ditampilkan di dataset yang dihasilkan.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di SAS:<\/span><\/p>\n
 Cara melakukan inner join di SAS<\/a>
 Bagaimana cara melakukan gabung kiri di SAS<\/a>
 Cara menghapus duplikat di SAS<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan sintaks dasar berikut untuk melakukan gabungan luar dengan dua kumpulan data di SAS: proc sql ; create table final_table as select coalesce(x.team, y.team) as team, x.team, x.points, y.team, y.assists from data1 as x full join data2 as y on x.team = y.team; quit ; Contoh khusus ini melakukan penggabungan luar menggunakan pernyataan […]<\/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":"\nCara Melakukan Outer Join di SAS (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara melakukan penggabungan luar 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\/sas-gabungan-luar\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Melakukan Outer Join di SAS (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara melakukan penggabungan luar di SAS, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/sas-gabungan-luar\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-12T16:50:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/exterieur1.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\/sas-gabungan-luar\/\",\"url\":\"https:\/\/statorials.org\/id\/sas-gabungan-luar\/\",\"name\":\"Cara Melakukan Outer Join di SAS (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-12T16:50:04+00:00\",\"dateModified\":\"2023-07-12T16:50:04+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara melakukan penggabungan luar di SAS, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/sas-gabungan-luar\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/sas-gabungan-luar\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/sas-gabungan-luar\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara melakukan outer join 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 Melakukan Outer Join di SAS (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara melakukan penggabungan luar 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\/sas-gabungan-luar\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Melakukan Outer Join di SAS (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara melakukan penggabungan luar di SAS, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/sas-gabungan-luar\/","og_site_name":"Statorials","article_published_time":"2023-07-12T16:50:04+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/exterieur1.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\/sas-gabungan-luar\/","url":"https:\/\/statorials.org\/id\/sas-gabungan-luar\/","name":"Cara Melakukan Outer Join di SAS (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-12T16:50:04+00:00","dateModified":"2023-07-12T16:50:04+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara melakukan penggabungan luar di SAS, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/sas-gabungan-luar\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/sas-gabungan-luar\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/sas-gabungan-luar\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara melakukan outer join 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\/4228"}],"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=4228"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4228\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4228"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4228"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4228"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}