{"id":2566,"date":"2023-07-21T17:15:28","date_gmt":"2023-07-21T17:15:28","guid":{"rendered":"https:\/\/statorials.org\/id\/sas-ekspor-ke-excel\/"},"modified":"2023-07-21T17:15:28","modified_gmt":"2023-07-21T17:15:28","slug":"sas-ekspor-ke-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/sas-ekspor-ke-excel\/","title":{"rendered":"Cara mengekspor data dari sas ke excel (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan <strong>proc ekspor<\/strong> untuk mengekspor data dengan cepat dari SAS ke file Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Prosedur ini menggunakan sintaks dasar berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008000;\">\/*export data to file called my_data.xlsx*\/\n<\/span><span style=\"color: #000000;\"><span style=\"color: #800080;\">proc export<\/span> <span style=\"color: #3366ff;\">data<\/span> =my_data\n    <span style=\"color: #3366ff;\">outfile<\/span> =\"\/home\/u13181\/my_data.xlsx\"\n    <span style=\"color: #3366ff;\">dbms<\/span> =xlsx\n    <span style=\"color: #3366ff;\">replace<\/span> ;\n    <span style=\"color: #3366ff;\">sheet<\/span> =\"FirstData\";\n<span style=\"color: #800080;\">run<\/span> ;<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Inilah yang dilakukan setiap baris:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>data<\/strong> : Nama kumpulan data yang akan diekspor<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>outfile<\/strong> : Lokasi untuk mengekspor file Excel<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>dmbs<\/strong> : Format file yang digunakan untuk ekspor<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>replace<\/strong> : Mengganti file jika sudah ada<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>sheet<\/strong> : Nama yang akan ditampilkan pada sheet di buku kerja Excel<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><b>Contoh 1: Ekspor kumpulan data ke lembar Excel<\/b><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Anggaplah kita memiliki kumpulan data berikut di SAS:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008000;\">\/*create dataset*\/\n<\/span><span style=\"color: #000000;\"><span style=\"color: #800080;\">data<\/span> my_data;\n    <span style=\"color: #3366ff;\">inputABC<\/span> ;\n    <span style=\"color: #3366ff;\">datalines<\/span> ;\n1 4 76\n2 3 49\n2 3 85\n4 5 88\n2 2 90\n4 6 78\n5 9 80\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;\n<\/span><\/strong><\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-22779 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/exporter11.jpg\" alt=\"\" width=\"143\" height=\"220\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan kode berikut untuk mengekspor dataset ini ke file Excel bernama <strong>my_data.xlsx<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008000;\">\/*export dataset*\/\n<\/span><span style=\"color: #000000;\"><span style=\"color: #800080;\">proc export<\/span> <span style=\"color: #3366ff;\">data<\/span> =my_data\n    <span style=\"color: #3366ff;\">outfile<\/span> =\"\/home\/u13181\/my_data.xlsx\"\n    <span style=\"color: #3366ff;\">dbms<\/span> =xlsx\n    <span style=\"color: #3366ff;\">replace<\/span> ;\n    <span style=\"color: #3366ff;\">sheet<\/span> =\"FirstData\";\n<span style=\"color: #800080;\">run<\/span> ;<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Saya kemudian dapat menavigasi ke lokasi di komputer tempat saya mengekspor file dan melihatnya di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-22780 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/exporter21.jpg\" alt=\"\" width=\"462\" height=\"404\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Data di Excel adalah kumpulan data SAS dan lembar di buku kerja Excel disebut &#8220;Data Pertama&#8221; seperti yang saya tentukan dalam pernyataan <strong>proc ekspor<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><b>Contoh 2: Ekspor Beberapa Kumpulan Data ke Beberapa Lembar Excel<\/b><\/span><\/h3>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Katakanlah kita memiliki dua kumpulan data di SAS:<\/span><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008000;\">\/*create first dataset*\/\n<\/span><span style=\"color: #800080;\">data<\/span> my_data;\n    <span style=\"color: #3366ff;\">inputABC<\/span> ;\n    <span style=\"color: #3366ff;\">datalines<\/span> ;\n1 4 76\n2 3 49\n2 3 85\n4 5 88\n2 2 90\n4 6 78\n5 9 80\n;\n<span style=\"color: #800080;\">run<\/span> ;\n\n<span style=\"color: #008000;\">\/*create second dataset*\/\n<\/span><span style=\"color: #800080;\">data<\/span> my_data2;\n    <span style=\"color: #3366ff;\">inputDEF<\/span> ;\n    <span style=\"color: #3366ff;\">datalines<\/span> ;\n1 4 90\n2 3 49\n2 3 85\n4 5 88\n2 1 90\n;\n<span style=\"color: #800080;\">run<\/span> ;<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan kode berikut untuk mengekspor kedua kumpulan data ke file Excel yang sama di lembar berbeda:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008000;\">\/*export first dataset to first sheet in Excel*\/\n<\/span><span style=\"color: #800080;\">proc export<\/span> <span style=\"color: #3366ff;\">data<\/span> =my_data\n    <span style=\"color: #3366ff;\">outfile<\/span> =\"\/home\/u13181\/my_data.xlsx\"\n    <span style=\"color: #3366ff;\">dbms<\/span> =xlsx\n    <span style=\"color: #3366ff;\">replace<\/span> ;\n    <span style=\"color: #3366ff;\">sheet<\/span> =\"FirstData\";\n<span style=\"color: #800080;\">run<\/span> ;\n\n<span style=\"color: #008000;\">\/*export second dataset to second sheet in Excel*\/\n<\/span><span style=\"color: #800080;\">proc export<\/span> <span style=\"color: #3366ff;\">data<\/span> =my_data2\n    <span style=\"color: #3366ff;\">outfile<\/span> =\"\/home\/u13181\/my_data.xlsx\"\n    <span style=\"color: #3366ff;\">dbms<\/span> =xlsx\n    <span style=\"color: #3366ff;\">replace<\/span> ;\n    <span style=\"color: #3366ff;\">sheet<\/span> =\"Second Data\";\n<span style=\"color: #800080;\">run<\/span> ;<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Saya kemudian dapat menavigasi ke lokasi di komputer saya tempat saya mengekspor file dan melihatnya di Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Lembar pertama berjudul \u201cData Pertama\u201d berisi kumpulan data pertama:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-22781 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/exporter31.jpg\" alt=\"\" width=\"474\" height=\"393\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dan lembar kedua berjudul \u201cData Kedua\u201d berisi kumpulan data kedua:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-22782 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/exporter41.jpg\" alt=\"\" width=\"479\" height=\"395\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong><span style=\"color: #000000;\">Sumber daya tambahan<\/span><\/strong><\/span><\/h3>\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\/menormalkan-data-di-airlock\/\" target=\"_blank\" rel=\"noopener\">Cara menormalkan data di SAS<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/sas-mengganti-nama-variabel\/\" target=\"_blank\" rel=\"noopener\">Cara mengganti nama variabel di SAS<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/jangan-hapus-duplikat\/\" target=\"_blank\" rel=\"noopener\">Cara menghapus duplikat di SAS<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/tanpa-mengganti-nilai-yang-hilang-dengan-nol\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara mengganti nilai yang hilang dengan nol di SAS<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan proc ekspor untuk mengekspor data dengan cepat dari SAS ke file Excel. Prosedur ini menggunakan sintaks dasar berikut: \/*export data to file called my_data.xlsx*\/ proc export data =my_data outfile =&#8221;\/home\/u13181\/my_data.xlsx&#8221; dbms =xlsx replace ; sheet =&#8221;FirstData&#8221;; run ; Inilah yang dilakukan setiap baris: data : Nama kumpulan data yang akan diekspor outfile [&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 Mengekspor Data dari SAS ke Excel (dengan Contoh) - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengekspor data dari SAS ke Excel, 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-ekspor-ke-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Mengekspor Data dari SAS ke Excel (dengan Contoh) - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengekspor data dari SAS ke Excel, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/sas-ekspor-ke-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-21T17:15:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/exporter11.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-ekspor-ke-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/sas-ekspor-ke-excel\/\",\"name\":\"Cara Mengekspor Data dari SAS ke Excel (dengan Contoh) - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-21T17:15:28+00:00\",\"dateModified\":\"2023-07-21T17:15:28+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengekspor data dari SAS ke Excel, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/sas-ekspor-ke-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/sas-ekspor-ke-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/sas-ekspor-ke-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengekspor data dari sas ke excel (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 Mengekspor Data dari SAS ke Excel (dengan Contoh) - Statorials","description":"Tutorial ini menjelaskan cara mengekspor data dari SAS ke Excel, 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-ekspor-ke-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Mengekspor Data dari SAS ke Excel (dengan Contoh) - Statorials","og_description":"Tutorial ini menjelaskan cara mengekspor data dari SAS ke Excel, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/sas-ekspor-ke-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-21T17:15:28+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/exporter11.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-ekspor-ke-excel\/","url":"https:\/\/statorials.org\/id\/sas-ekspor-ke-excel\/","name":"Cara Mengekspor Data dari SAS ke Excel (dengan Contoh) - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-21T17:15:28+00:00","dateModified":"2023-07-21T17:15:28+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengekspor data dari SAS ke Excel, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/sas-ekspor-ke-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/sas-ekspor-ke-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/sas-ekspor-ke-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengekspor data dari sas ke excel (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\/2566"}],"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=2566"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2566\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2566"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2566"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2566"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}