{"id":2626,"date":"2023-07-21T10:58:52","date_gmt":"2023-07-21T10:58:52","guid":{"rendered":"https:\/\/statorials.org\/id\/sas-gabung-dalam\/"},"modified":"2023-07-21T10:58:52","modified_gmt":"2023-07-21T10:58:52","slug":"sas-gabung-dalam","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/sas-gabung-dalam\/","title":{"rendered":"Cara melakukan inner join di sas (dengan contoh)"},"content":{"rendered":"

<\/p>\n

\n

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

 proc sql<\/span> ;\n    create table<\/span> final_table as<\/span>\n    select<\/span> * from<\/span> data1 as<\/span> x join<\/span> data2 as<\/span> y\n    on<\/span> x.ID = y.ID;\nquit<\/span> ;<\/strong><\/span><\/pre>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.
<\/span><\/p>\n
 Terkait:<\/strong> Bagaimana cara melakukan gabung kiri di SAS<\/a><\/span><\/p>\n
 Contoh: Inner Join di SAS<\/strong><\/span><\/h2>\n
 Anggaplah kita memiliki dua kumpulan data berikut di SAS:<\/span> <\/p>\n
 \/*create datasets*\/\ndata<\/span> data1;\n    input<\/span> team $points;\n    datalines<\/span> ;\nMavs 99\nSpurs 93\nRockets 88\nThunder 91\nWarriors 104\nCavs 93\nNets 90\nHawks 91\n;\nrun<\/span> ;\n\ndata<\/span> data2;\n    input<\/span> team $rebounds;\n    datalines<\/span> ;\nMavs 21\nSpurs 18\nWarriors 27\nHawks 29\nKnicks 40\nRaptors 30\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
 Perhatikan bahwa kedua kumpulan data memiliki variabel yang sama: team<\/strong> .<\/span><\/p>\n
 Kita akan menggunakan sintaks berikut untuk melakukan penggabungan dalam dan membuat kumpulan data baru yang hanya berisi baris tempat variabel tim<\/strong> muncul di kedua kumpulan data:<\/span> <\/p>\n
 \/*perform inner join*\/\n<\/span>proc sql<\/span> ;\n\tcreate table<\/span> final_table as<\/span>\n\tselect<\/span> * from<\/span> data1 as<\/span> x join<\/span> data2 as<\/span> y\n\ton<\/span> x.team = y.team;\nquit<\/span> ;\n\n\/*view results of inner join*\/\n<\/span>proc print<\/span> data<\/span> =final_table;<\/span><\/span><\/strong><\/span> <\/pre>\n
\"\"<\/p>\n
 Kumpulan data yang dihasilkan hanya berisi baris tempat variabel tim<\/strong> muncul di kedua kumpulan data.<\/span><\/p>\n
 Jika mengacu pada dua dataset sebelumnya, Anda akan melihat bahwa hanya ada empat tim yang muncul di kedua dataset tersebut: Mavs, Spurs, Warriors, dan Hawks.<\/span><\/p>\n
 Karena kami memilih untuk menggabungkan dua kumpulan data pada variabel tim<\/strong> , inilah empat tim yang juga muncul di kumpulan data akhir.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di SAS:<\/span><\/p>\n
 Cara menormalkan data di SAS<\/a>
 Bagaimana cara mengganti karakter dalam string di SAS<\/a>
 Bagaimana cara mengganti nilai yang hilang dengan nol di SAS<\/a>
 Cara menghapus duplikat di SAS<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan sintaks dasar berikut untuk melakukan penggabungan dalam dengan dua kumpulan data di SAS: proc sql ; create table final_table as select * from data1 as x join data2 as y on x.ID = y.ID; quit ; Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya. Terkait: Bagaimana cara melakukan gabung kiri di […]<\/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 Inner Join di SAS (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara melakukan inner join dengan dua dataset 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-gabung-dalam\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Melakukan Inner Join di SAS (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara melakukan inner join dengan dua dataset di SAS, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/sas-gabung-dalam\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-21T10:58:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/innersas1.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-gabung-dalam\/\",\"url\":\"https:\/\/statorials.org\/id\/sas-gabung-dalam\/\",\"name\":\"Cara Melakukan Inner Join di SAS (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-21T10:58:52+00:00\",\"dateModified\":\"2023-07-21T10:58:52+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara melakukan inner join dengan dua dataset di SAS, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/sas-gabung-dalam\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/sas-gabung-dalam\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/sas-gabung-dalam\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara melakukan inner 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 Inner Join di SAS (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara melakukan inner join dengan dua dataset 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-gabung-dalam\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Melakukan Inner Join di SAS (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara melakukan inner join dengan dua dataset di SAS, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/sas-gabung-dalam\/","og_site_name":"Statorials","article_published_time":"2023-07-21T10:58:52+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/innersas1.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-gabung-dalam\/","url":"https:\/\/statorials.org\/id\/sas-gabung-dalam\/","name":"Cara Melakukan Inner Join di SAS (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-21T10:58:52+00:00","dateModified":"2023-07-21T10:58:52+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara melakukan inner join dengan dua dataset di SAS, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/sas-gabung-dalam\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/sas-gabung-dalam\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/sas-gabung-dalam\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara melakukan inner 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\/2626"}],"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=2626"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2626\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2626"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2626"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2626"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}