{"id":3915,"date":"2023-07-14T19:08:42","date_gmt":"2023-07-14T19:08:42","guid":{"rendered":"https:\/\/statorials.org\/id\/sas-proc-sql-kecuali\/"},"modified":"2023-07-14T19:08:42","modified_gmt":"2023-07-14T19:08:42","slug":"sas-proc-sql-kecuali","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/sas-proc-sql-kecuali\/","title":{"rendered":"Sas: cara menggunakan kecuali di proc sql"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan operator KECUALI<\/b> dalam pernyataan SQL PROC<\/strong> di SAS untuk mengembalikan hanya baris dalam satu kumpulan data yang tidak ada dalam kumpulan data lain.<\/span><\/p>\n

Contoh berikut menunjukkan cara menggunakan operator EXCEPT<\/b> dalam praktiknya.<\/span><\/p>\n

Contoh: Menggunakan KECUALI dalam PROC SQL di SAS<\/strong><\/h2>\n

Misalkan kita memiliki kumpulan data berikut di SAS yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n

 \/*create first dataset*\/\n<\/span>data<\/span> data1;\n    input<\/span> team $points;\n    datalines<\/span> ;\nAT 12\nAt 14\nAt 15\nAt 18\nAt 20\nAt 22\n;\nrun<\/span> ;\n\n\/*view first dataset*\/\n<\/span>proc print<\/span> data<\/span> =data1;\n<\/strong><\/span><\/pre>\n
\"\"<\/p>\n
 Dan misalkan kita memiliki kumpulan data lain di SAS yang juga berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n
 \/*create second dataset*\/\n<\/span>data<\/span> data2;\n    input<\/span> team $points;\n    datalines<\/span> ;\nAT 12\nAt 14\nB23\nB25\nB29\nB 30\n;\nrun<\/span> ;\n\n\/*view second dataset*\/\n<\/span>proc print<\/span> data<\/span> =data2;<\/strong><\/span> <\/pre>\n
\"\"<\/p>\n
 Kita dapat menggunakan operator EXCEPT<\/b> dalam pernyataan SQL PROC<\/strong> untuk mengembalikan hanya baris-baris dari kumpulan data pertama yang tidak ada dalam kumpulan data kedua.<\/span> <\/p>\n
 \/*only return rows from first dataset that are not in second dataset*\/\n<\/span>proc sql<\/span> ;\n   title<\/span> 'data1 EXCEPT data2';\n   select<\/span> * from<\/span> data1\n   except<\/span>\n   select<\/span> * from<\/span> data2;\nquit<\/span> ;<\/strong><\/span> <\/pre>\n
\"\"<\/p>\n
 Perhatikan bahwa hanya baris dari kumpulan data pertama yang bukan milik kumpulan data kedua yang dikembalikan.<\/span><\/p>\n
 Kita juga dapat menggunakan operator EXCEPT<\/strong> untuk mengembalikan hanya baris dari dataset kedua yang tidak ada dalam dataset pertama:<\/span> <\/p>\n
 \/*only return rows from second dataset that are not in first dataset*\/\n<\/span>proc sql<\/span> ;\n   title<\/span> 'data2 EXCEPT data1';\n   select<\/span> * from<\/span> data2\n   except<\/span>\n   select<\/span> * from<\/span> data1;\nquit<\/span> ;<\/strong><\/span> <\/pre>\n
\"\"<\/p>\n
 Perhatikan bahwa hanya baris dari kumpulan data kedua yang bukan milik kumpulan data pertama yang dikembalikan.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di SAS:<\/span><\/p>\n
 SAS: Cara menggunakan UNION di PROC SQL<\/a>
 SAS: Cara menggunakan Proc Univariate berdasarkan grup<\/a>
 SAS: Cara menggunakan konten Proc<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan operator KECUALI dalam pernyataan SQL PROC di SAS untuk mengembalikan hanya baris dalam satu kumpulan data yang tidak ada dalam kumpulan data lain. Contoh berikut menunjukkan cara menggunakan operator EXCEPT dalam praktiknya. Contoh: Menggunakan KECUALI dalam PROC SQL di SAS Misalkan kita memiliki kumpulan data berikut di SAS yang berisi informasi tentang […]<\/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":"\nSAS: Cara menggunakan KECUALI di PROC SQL - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan operator EXCEPT pada PROC SQL di SAS, dengan beberapa 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-kecuali\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SAS: Cara menggunakan KECUALI di PROC SQL - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan operator EXCEPT pada PROC SQL di SAS, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/sas-proc-sql-kecuali\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-14T19:08:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/syndicat1.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-proc-sql-kecuali\/\",\"url\":\"https:\/\/statorials.org\/id\/sas-proc-sql-kecuali\/\",\"name\":\"SAS: Cara menggunakan KECUALI di PROC SQL - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-14T19:08:42+00:00\",\"dateModified\":\"2023-07-14T19:08:42+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan operator EXCEPT pada PROC SQL di SAS, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/sas-proc-sql-kecuali\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/sas-proc-sql-kecuali\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/sas-proc-sql-kecuali\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Sas: cara menggunakan kecuali 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 KECUALI di PROC SQL - Statologi","description":"Tutorial ini menjelaskan cara menggunakan operator EXCEPT pada PROC SQL di SAS, dengan beberapa 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-kecuali\/","og_locale":"id_ID","og_type":"article","og_title":"SAS: Cara menggunakan KECUALI di PROC SQL - Statologi","og_description":"Tutorial ini menjelaskan cara menggunakan operator EXCEPT pada PROC SQL di SAS, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/sas-proc-sql-kecuali\/","og_site_name":"Statorials","article_published_time":"2023-07-14T19:08:42+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/syndicat1.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-proc-sql-kecuali\/","url":"https:\/\/statorials.org\/id\/sas-proc-sql-kecuali\/","name":"SAS: Cara menggunakan KECUALI di PROC SQL - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-14T19:08:42+00:00","dateModified":"2023-07-14T19:08:42+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan operator EXCEPT pada PROC SQL di SAS, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/sas-proc-sql-kecuali\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/sas-proc-sql-kecuali\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/sas-proc-sql-kecuali\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Sas: cara menggunakan kecuali 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\/3915"}],"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=3915"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3915\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3915"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3915"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3915"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}