{"id":2625,"date":"2023-07-21T11:08:39","date_gmt":"2023-07-21T11:08:39","guid":{"rendered":"https:\/\/statorials.org\/id\/tanpa-kiri-bergabung\/"},"modified":"2023-07-21T11:08:39","modified_gmt":"2023-07-21T11:08:39","slug":"tanpa-kiri-bergabung","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/tanpa-kiri-bergabung\/","title":{"rendered":"Cara melakukan gabung kiri di sas (dengan contoh)"},"content":{"rendered":"

<\/p>\n

\n

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

 proc sql;\n    create<\/span> table<\/span> final_table as\n<\/span><\/span>select<\/span> * from<\/span> data1 as<\/span> x left join<\/span> data2 as<\/span> y\n    on<\/span> x.ID = y.ID;<\/span>\nquit;<\/span><\/strong><\/span><\/pre>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Terkait:<\/strong> Cara Melakukan Inner Join di SAS<\/a><\/span><\/p>\n
 Contoh: Kiri Gabung di SAS<\/strong><\/span><\/h3>\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\nGrizzlies 90\nHawks 91\n;\nrun<\/span> ;\n\ndata<\/span> data2;\n    input<\/span> team $rebounds;\n    datalines<\/span> ;\nMavs 21\nSpurs 18\nRockets 22\nWarriors 27\nCavs 15\nHawks 29\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 kiri dan membuat kumpulan data baru yang berisi setiap baris di data1<\/strong> dan hanya<\/em> baris di data2<\/strong> yang cocok dengan nama tim di data1<\/strong> :<\/span> <\/p>\n
 \/*perform left join*\/\n<\/span>proc sql;\ncreate<\/span> table<\/span> final_table as<\/span>\n\tselect<\/span> * from<\/span> data1 as<\/span> x left<\/span> join<\/span> data2 as<\/span> y\n\ton<\/span> x.team = y.team;<\/span>\nquit ;<\/span>\n\n\/*view results of left join*\/\n<\/span>proc print data<\/span> =final_table;<\/span><\/span><\/strong><\/span> <\/pre>\n
\"\"<\/p>\n
 Kumpulan data yang dihasilkan berisi semua tim asli dari data1<\/strong> , namun satu-satunya tim yang memiliki nilai untuk kolom pentalan<\/strong> adalah tim yang juga muncul di data2<\/strong> .<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h3>\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 kiri dengan dua kumpulan data di SAS: proc sql; create table final_table as select * from data1 as x left join data2 as y on x.ID = y.ID; quit; Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya. Terkait: Cara Melakukan Inner Join di SAS Contoh: […]<\/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 Gabung Kiri di SAS (dengan Contoh) - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara melakukan join kiri di SAS, dengan contoh lengkap.\" \/>\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-kiri-bergabung\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Melakukan Gabung Kiri di SAS (dengan Contoh) - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara melakukan join kiri di SAS, dengan contoh lengkap.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/tanpa-kiri-bergabung\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-21T11:08:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gauchesas1.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\/tanpa-kiri-bergabung\/\",\"url\":\"https:\/\/statorials.org\/id\/tanpa-kiri-bergabung\/\",\"name\":\"Cara Melakukan Gabung Kiri di SAS (dengan Contoh) - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-21T11:08:39+00:00\",\"dateModified\":\"2023-07-21T11:08:39+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara melakukan join kiri di SAS, dengan contoh lengkap.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/tanpa-kiri-bergabung\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/tanpa-kiri-bergabung\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/tanpa-kiri-bergabung\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara melakukan gabung kiri 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 Gabung Kiri di SAS (dengan Contoh) - Statorial","description":"Tutorial ini menjelaskan cara melakukan join kiri di SAS, dengan contoh lengkap.","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-kiri-bergabung\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Melakukan Gabung Kiri di SAS (dengan Contoh) - Statorial","og_description":"Tutorial ini menjelaskan cara melakukan join kiri di SAS, dengan contoh lengkap.","og_url":"https:\/\/statorials.org\/id\/tanpa-kiri-bergabung\/","og_site_name":"Statorials","article_published_time":"2023-07-21T11:08:39+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gauchesas1.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\/tanpa-kiri-bergabung\/","url":"https:\/\/statorials.org\/id\/tanpa-kiri-bergabung\/","name":"Cara Melakukan Gabung Kiri di SAS (dengan Contoh) - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-21T11:08:39+00:00","dateModified":"2023-07-21T11:08:39+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara melakukan join kiri di SAS, dengan contoh lengkap.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/tanpa-kiri-bergabung\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/tanpa-kiri-bergabung\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/tanpa-kiri-bergabung\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara melakukan gabung kiri 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\/2625"}],"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=2625"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2625\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2625"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2625"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2625"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}