{"id":2567,"date":"2023-07-21T17:10:55","date_gmt":"2023-07-21T17:10:55","guid":{"rendered":"https:\/\/statorials.org\/id\/sas-ekspor-ke-csv\/"},"modified":"2023-07-21T17:10:55","modified_gmt":"2023-07-21T17:10:55","slug":"sas-ekspor-ke-csv","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/sas-ekspor-ke-csv\/","title":{"rendered":"Cara mengekspor data dari sas ke file csv (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 CSV.<\/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 data.csv*\/\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\/data.csv\"\n    <span style=\"color: #3366ff;\">dbms<\/span> =csv\n    <span style=\"color: #3366ff;\">replace<\/span> ;\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 CSV<\/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<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Terkait:<\/strong> <a href=\"https:\/\/statorials.org\/id\/sas-ekspor-ke-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Mengekspor Data dari SAS ke Excel<\/a><\/span><\/p>\n<h3> <span style=\"color: #000000;\"><b>Contoh 1: Ekspor kumpulan data ke format CSV dengan pengaturan default<\/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 kumpulan data ini ke file CSV bernama <strong>data.csv<\/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\/data.csv\"\n    <span style=\"color: #3366ff;\">dbms<\/span> =csv\n    <span style=\"color: #3366ff;\">replace<\/span> ;\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:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-22790 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/csv11.jpg\" alt=\"\" width=\"404\" height=\"332\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Data dalam file CSV sesuai dengan kumpulan data SAS.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><b>Contoh 2: Ekspor kumpulan data ke CSV dengan pengaturan khusus<\/b><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Anda juga dapat menggunakan argumen <strong>pembatas<\/strong> dan <strong>nama put<\/strong> untuk mengubah pembatas yang memisahkan nilai dan menghapus baris header dari kumpulan data.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kode berikut menunjukkan cara mengekspor kumpulan data SAS ke file CSV menggunakan titik koma sebagai pembatas dan tanpa baris header:<\/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\/data.csv\"\n    <span style=\"color: #3366ff;\">dbms<\/span> =csv\n    <span style=\"color: #3366ff;\">replace<\/span> ;\n    <span style=\"color: #3366ff;\">delimit<\/span> =\";\";\n    <span style=\"color: #3366ff;\">putnames<\/span> =NO;\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:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-22791 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/csv12.jpg\" alt=\"\" width=\"422\" height=\"327\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa baris header telah dihapus dan nilainya dipisahkan dengan titik koma, bukan koma.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/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 CSV. Prosedur ini menggunakan sintaks dasar berikut: \/*export data to file called data.csv*\/ proc export data =my_data outfile =&#8221;\/home\/u13181\/data.csv&#8221; dbms =csv replace ; run ; Inilah yang dilakukan setiap baris: data : Nama kumpulan data yang akan diekspor outfile : lokasi [&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 File CSV (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengekspor dataset SAS ke file CSV, 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-csv\/\" \/>\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 File CSV (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengekspor dataset SAS ke file CSV, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/sas-ekspor-ke-csv\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-21T17:10:55+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-csv\/\",\"url\":\"https:\/\/statorials.org\/id\/sas-ekspor-ke-csv\/\",\"name\":\"Cara Mengekspor Data dari SAS ke File CSV (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-21T17:10:55+00:00\",\"dateModified\":\"2023-07-21T17:10:55+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengekspor dataset SAS ke file CSV, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/sas-ekspor-ke-csv\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/sas-ekspor-ke-csv\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/sas-ekspor-ke-csv\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengekspor data dari sas ke file csv (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 File CSV (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara mengekspor dataset SAS ke file CSV, 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-csv\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Mengekspor Data dari SAS ke File CSV (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara mengekspor dataset SAS ke file CSV, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/sas-ekspor-ke-csv\/","og_site_name":"Statorials","article_published_time":"2023-07-21T17:10:55+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-csv\/","url":"https:\/\/statorials.org\/id\/sas-ekspor-ke-csv\/","name":"Cara Mengekspor Data dari SAS ke File CSV (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-21T17:10:55+00:00","dateModified":"2023-07-21T17:10:55+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengekspor dataset SAS ke file CSV, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/sas-ekspor-ke-csv\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/sas-ekspor-ke-csv\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/sas-ekspor-ke-csv\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengekspor data dari sas ke file csv (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\/2567"}],"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=2567"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2567\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2567"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2567"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2567"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}