{"id":3957,"date":"2023-07-14T12:37:48","date_gmt":"2023-07-14T12:37:48","guid":{"rendered":"https:\/\/statorials.org\/id\/sas-proc-sql-memiliki\/"},"modified":"2023-07-14T12:37:48","modified_gmt":"2023-07-14T12:37:48","slug":"sas-proc-sql-memiliki","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/sas-proc-sql-memiliki\/","title":{"rendered":"Sas: cara menggunakan klausa having di proc sql"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan klausa <b>HAVING<\/b> di <strong>PROC SQL<\/strong> di SAS untuk memfilter baris yang memenuhi kondisi tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan perbedaan halus antara klausa <b>WHERE<\/b> dan <strong>HAVING<\/strong> :<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>WHERE<\/strong> memfilter baris sebelum pengelompokan terjadi.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>HAVING<\/strong> memfilter baris setelah pengelompokan apa pun.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan klausa <strong>HAVING<\/strong> dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Cara menggunakan klausa HAVING di PROC SQL<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut di SAS yang berisi informasi tentang berbagai pemain bola basket:<\/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> my_data;\n    <span style=\"color: #3366ff;\">input<\/span> team $position $points;\n    <span style=\"color: #3366ff;\">datalines<\/span> ;\nA Guard 22\nA Guard 20\nA Guard 30\nA Forward 14\nA Forward 11\nB Guard 12\nB Guard 22\nB Forward 30\nB Forward 9\nB Forward 12\nB Forward 25\nC Guard 22\nC Guard 19\nC Guard 10\n;\n<span style=\"color: #800080;\">run<\/span> ;\n\n<span style=\"color: #008000;\">\/*view dataset*\/\n<\/span><span style=\"color: #800080;\">proc print<\/span> <span style=\"color: #3366ff;\">data<\/span> =my_data;<\/strong><\/span> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31773 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/avoir1.jpg\" alt=\"\" width=\"236\" height=\"404\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan kode berikut untuk menghitung jumlah poin yang dicetak oleh pemain di setiap tim <strong>DIMANA<\/strong> pemainnya adalah penjaga, lalu memfilter hasilnya untuk hanya menampilkan tim <strong>yang MEMILIKI<\/strong> jumlah lebih besar dari 50:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #800080;\">proc sql<\/span> ;\n    <span style=\"color: #3366ff;\">select<\/span> team, sum(points) <span style=\"color: #3366ff;\">as<\/span> sum_points\n    <span style=\"color: #3366ff;\">from<\/span> my_data\n    <span style=\"color: #3366ff;\">where<\/span> position='Guard'\n    <span style=\"color: #3366ff;\">group<\/span> by team\n    <span style=\"color: #3366ff;\">having<\/span> sum_points &gt; <span style=\"color: #008000;\">50<\/span> ;\n<span style=\"color: #800080;\">quit<\/span> ;<\/strong><\/span> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31774 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/avoir2.jpg\" alt=\"\" width=\"157\" height=\"86\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Inilah cara kerja kode ini:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Pertama, kami menggunakan <strong>SELECT<\/strong> untuk memilih tim dan jumlah poin<\/span><\/li>\n<li> <span style=\"color: #000000;\">Kemudian kami menggunakan <strong>WHERE<\/strong> untuk memfilter baris yang posisinya &#8220;Penjaga&#8221;<\/span><\/li>\n<li> <span style=\"color: #000000;\">Selanjutnya, kami menggunakan <strong>GROUP<\/strong> untuk mengelompokkan hasil berdasarkan tim<\/span><\/li>\n<li> <span style=\"color: #000000;\">Selanjutnya, kami menggunakan <strong>HAVING<\/strong> untuk memfilter tim dengan jumlah poin &gt; 50.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Inilah hasil kueri ini jika kita tidak menyertakan pernyataan <strong>HAVING<\/strong> :<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #800080;\">proc sql<\/span> ;\n    <span style=\"color: #3366ff;\">select<\/span> team, sum(points) <span style=\"color: #3366ff;\">as<\/span> sum_points\n    <span style=\"color: #3366ff;\">from<\/span> my_data\n    <span style=\"color: #3366ff;\">where<\/span> position='Guard'\n    <span style=\"color: #3366ff;\">group<\/span> by team;\n<span style=\"color: #800080;\">quit<\/span> ;<\/strong><\/span> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31775 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/avoir3.jpg\" alt=\"\" width=\"166\" height=\"117\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa jumlah poin Tim B tidak lebih dari 50.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jadi ketika kita menggunakan pernyataan <strong>HAVING<\/strong> pada contoh sebelumnya, kita memfilter tim B karena jumlah poin mereka tidak lebih besar dari 50.<\/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> SAS: Cara menggunakan operator LIKE di PROC SQL<br \/> <a href=\"https:\/\/statorials.org\/id\/sas-proc-sql-masuk\/\" target=\"_blank\" rel=\"noopener\">SAS: Cara menggunakan operator IN di PROC SQL<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/sas-proc-sql-atau\/\" target=\"_blank\" rel=\"noopener\">SAS: Cara menggunakan operator WHERE di PROC SQL<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan klausa HAVING di PROC SQL di SAS untuk memfilter baris yang memenuhi kondisi tertentu. Perhatikan perbedaan halus antara klausa WHERE dan HAVING : WHERE memfilter baris sebelum pengelompokan terjadi. HAVING memfilter baris setelah pengelompokan apa pun. Contoh berikut menunjukkan cara menggunakan klausa HAVING dalam praktiknya. Contoh: Cara menggunakan klausa HAVING di PROC [&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 menggunakan klausa HAVING di PROC SQL - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan klausa HAVING dalam PROC SQL 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-proc-sql-memiliki\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SAS: Cara menggunakan klausa HAVING di PROC SQL - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan klausa HAVING dalam PROC SQL di SAS, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/sas-proc-sql-memiliki\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-14T12:37:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/avoir1.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-proc-sql-memiliki\/\",\"url\":\"https:\/\/statorials.org\/id\/sas-proc-sql-memiliki\/\",\"name\":\"SAS: Cara menggunakan klausa HAVING di PROC SQL - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-14T12:37:48+00:00\",\"dateModified\":\"2023-07-14T12:37:48+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan klausa HAVING dalam PROC SQL di SAS, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/sas-proc-sql-memiliki\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/sas-proc-sql-memiliki\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/sas-proc-sql-memiliki\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Sas: cara menggunakan klausa having di proc sql\"}]},{\"@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 menggunakan klausa HAVING di PROC SQL - Statorials","description":"Tutorial ini menjelaskan cara menggunakan klausa HAVING dalam PROC SQL 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-proc-sql-memiliki\/","og_locale":"id_ID","og_type":"article","og_title":"SAS: Cara menggunakan klausa HAVING di PROC SQL - Statorials","og_description":"Tutorial ini menjelaskan cara menggunakan klausa HAVING dalam PROC SQL di SAS, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/sas-proc-sql-memiliki\/","og_site_name":"Statorials","article_published_time":"2023-07-14T12:37:48+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/avoir1.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-proc-sql-memiliki\/","url":"https:\/\/statorials.org\/id\/sas-proc-sql-memiliki\/","name":"SAS: Cara menggunakan klausa HAVING di PROC SQL - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-14T12:37:48+00:00","dateModified":"2023-07-14T12:37:48+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan klausa HAVING dalam PROC SQL di SAS, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/sas-proc-sql-memiliki\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/sas-proc-sql-memiliki\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/sas-proc-sql-memiliki\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Sas: cara menggunakan klausa having di proc sql"}]},{"@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\/3957"}],"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=3957"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3957\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3957"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3957"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3957"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}