{"id":3667,"date":"2023-07-16T06:01:53","date_gmt":"2023-07-16T06:01:53","guid":{"rendered":"https:\/\/statorials.org\/id\/membuat-tabel-airlock\/"},"modified":"2023-07-16T06:01:53","modified_gmt":"2023-07-16T06:01:53","slug":"membuat-tabel-airlock","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/membuat-tabel-airlock\/","title":{"rendered":"Cara membuat tabel di sas (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan <strong>proc sql<\/strong> untuk membuat tabel di SAS dengan cepat.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ada dua cara untuk melakukan ini:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>1.<\/strong> Buat papan dari awal<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>2.<\/strong> Buat tabel dari data yang ada<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara melakukan keduanya menggunakan <strong>proc sql<\/strong> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Buat tabel dari awal<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara membuat tabel dengan tiga kolom menggunakan <strong>proc sql<\/strong> di SAS:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008000;\">\/*create empty table*\/\n<\/span><span style=\"color: #800080;\">proc sql<\/span> ;\n   <span style=\"color: #3366ff;\">create table<\/span> my_table\n       (team char(10),\n        number points,\n        rebounds num);\n\n<span style=\"color: #008000;\">\/*insert values into table*\/          \n<\/span><span style=\"color: #3366ff;\">insert into<\/span> my_table\n      <span style=\"color: #3366ff;\">values<\/span> ('Mavs', 99, 22)\n      <span style=\"color: #3366ff;\">values<\/span> ('Hawks', 104, 20)\n      <span style=\"color: #3366ff;\">values<\/span> ('Hornets', 88, 25)\n      <span style=\"color: #3366ff;\">values<\/span> ('Lakers', 113, 19)\n      <span style=\"color: #3366ff;\">values<\/span> ('Warriors', 109, 32);\n\n<span style=\"color: #008000;\">\/*display table*\/\n<\/span><span style=\"color: #3366ff;\">select<\/span> * <span style=\"color: #3366ff;\">from<\/span> my_table;\n<span style=\"color: #800080;\">run<\/span> ;\n<\/strong><\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-30047\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tablesas1.jpg\" alt=\"membuat tabel di SAS\" width=\"205\" height=\"155\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita menggunakan <strong>create table<\/strong> untuk membuat tabel kosong, lalu menggunakan <strong>insert into<\/strong> untuk menambahkan nilai pada tabel, lalu menggunakan <strong>select * from<\/strong> untuk menampilkan tabel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Hasilnya adalah tabel tiga kolom yang menampilkan berbagai informasi tentang tim bola basket yang berbeda.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Membuat tabel dari data yang ada<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara menggunakan <strong>proc sql<\/strong> untuk membuat tabel menggunakan dataset yang sudah kita buat pada contoh sebelumnya:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008000;\">\/*create table from existing dateset*\/\n<\/span><span style=\"color: #800080;\">proc sql<\/span> ;\n   <span style=\"color: #3366ff;\">create table<\/span> my_table2 <span style=\"color: #3366ff;\">as<\/span>\n      <span style=\"color: #3366ff;\">select<\/span> team <span style=\"color: #3366ff;\">as<\/span> Team_Name,\n             points <span style=\"color: #3366ff;\">as<\/span> Points_Scored\n         <span style=\"color: #3366ff;\">from<\/span> my_table;\n         \n<span style=\"color: #008000;\">\/*display table*\/\n<\/span><span style=\"color: #3366ff;\">select<\/span> * <span style=\"color: #3366ff;\">from<\/span> my_table2;\n<span style=\"color: #800080;\">run<\/span> ;\n<\/strong><\/span><\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30048 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tablesas2.jpg\" alt=\"\" width=\"208\" height=\"158\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Hasilnya adalah tabel yang berisi dua kolom dengan nilai dari dataset yang ada.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Kami menggunakan fungsi <strong>as<\/strong> untuk menentukan nama kolom yang akan digunakan dalam tabel, namun Anda tidak harus menggunakan fungsi <strong>as<\/strong> jika Anda tidak ingin mengganti nama kolom.<\/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> <a href=\"https:\/\/statorials.org\/id\/tabel-frekuensi-sas\/\" target=\"_blank\" rel=\"noopener\">Cara membuat tabel frekuensi di SAS<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/sebagai-akun-terpisah\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung nilai yang berbeda di SAS<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/akun-sas-per-grup\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung observasi berdasarkan kelompok di SAS<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan proc sql untuk membuat tabel di SAS dengan cepat. Ada dua cara untuk melakukan ini: 1. Buat papan dari awal 2. Buat tabel dari data yang ada Contoh berikut menunjukkan cara melakukan keduanya menggunakan proc sql . Contoh 1: Buat tabel dari awal Kode berikut menunjukkan cara membuat tabel dengan tiga kolom [&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>Cara Membuat Tabel di SAS (dengan Contoh) - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat tabel 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\/membuat-tabel-airlock\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat Tabel di SAS (dengan Contoh) - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat tabel di SAS, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/membuat-tabel-airlock\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-16T06:01:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tablesas1.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\/membuat-tabel-airlock\/\",\"url\":\"https:\/\/statorials.org\/id\/membuat-tabel-airlock\/\",\"name\":\"Cara Membuat Tabel di SAS (dengan Contoh) - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-16T06:01:53+00:00\",\"dateModified\":\"2023-07-16T06:01:53+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat tabel di SAS, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/membuat-tabel-airlock\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/membuat-tabel-airlock\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/membuat-tabel-airlock\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat tabel 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 Membuat Tabel di SAS (dengan Contoh) - Statorial","description":"Tutorial ini menjelaskan cara membuat tabel 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\/membuat-tabel-airlock\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Tabel di SAS (dengan Contoh) - Statorial","og_description":"Tutorial ini menjelaskan cara membuat tabel di SAS, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/membuat-tabel-airlock\/","og_site_name":"Statorials","article_published_time":"2023-07-16T06:01:53+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tablesas1.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\/membuat-tabel-airlock\/","url":"https:\/\/statorials.org\/id\/membuat-tabel-airlock\/","name":"Cara Membuat Tabel di SAS (dengan Contoh) - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-16T06:01:53+00:00","dateModified":"2023-07-16T06:01:53+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat tabel di SAS, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/membuat-tabel-airlock\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/membuat-tabel-airlock\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/membuat-tabel-airlock\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat tabel 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\/3667"}],"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=3667"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3667\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3667"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3667"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3667"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}