{"id":2568,"date":"2023-07-21T17:04:42","date_gmt":"2023-07-21T17:04:42","guid":{"rendered":"https:\/\/statorials.org\/id\/seperti-impor-excel\/"},"modified":"2023-07-21T17:04:42","modified_gmt":"2023-07-21T17:04:42","slug":"seperti-impor-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/seperti-impor-excel\/","title":{"rendered":"Cara mengimpor file excel ke sas (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan <strong>proc import<\/strong> untuk mengimpor data dengan cepat dari file Excel ke SAS.<\/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;\">\/*import data from Excel file called my_data.xlsx*\/\n<\/span><span style=\"color: #000000;\"><span style=\"color: #800080;\">proc import<\/span> <span style=\"color: #3366ff;\">out<\/span> =my_data\n    <span style=\"color: #3366ff;\">datafile<\/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;\">getnames<\/span> =YES;\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>out<\/strong> : Nama yang akan diberikan pada kumpulan data setelah diimpor ke SAS<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>datafile<\/strong> : Lokasi file Excel yang akan diimpor<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>dbms<\/strong> : Format file yang sedang diimpor<\/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>getnames<\/strong> : gunakan baris pertama sebagai nama variabel (setel ke NO jika baris pertama tidak berisi nama variabel)<\/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: Impor data dari file Excel ke SAS<\/b><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-22796 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/excel11.jpg\" alt=\"\" width=\"458\" height=\"420\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan kode berikut untuk mengimpor dataset ini ke SAS dan menyebutnya <strong>new_data<\/strong> :<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008000;\">\/*import data from Excel file called my_data.xlsx*\/\n<\/span><span style=\"color: #000000;\"><span style=\"color: #800080;\">proc import<\/span> <span style=\"color: #3366ff;\">out<\/span> =new_data\n    <span style=\"color: #3366ff;\">datafile<\/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;\">getnames<\/span> =YES;\n<span style=\"color: #800080;\">run<\/span> ;\n\n<span style=\"color: #008000;\">\/*view dataset*\/<\/span>\n<span style=\"color: #800080;\">proc print<\/span> <span style=\"color: #3366ff;\">data<\/span> = new_data;<\/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=\"136\" height=\"208\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Data yang ditampilkan pada output SAS cocok dengan data yang ditampilkan pada file Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Kami menggunakan <strong>getnames=YES<\/strong> saat mengimpor file karena baris pertama file Excel berisi nama variabel.<\/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\/sas-ekspor-ke-excel\/\" target=\"_blank\" rel=\"noopener\">Cara mengekspor data dari SAS ke file Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/sas-ekspor-ke-csv\/\" target=\"_blank\" rel=\"noopener\">Cara mengekspor data dari SAS ke file CSV<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan proc import untuk mengimpor data dengan cepat dari file Excel ke SAS. Prosedur ini menggunakan sintaks dasar berikut: \/*import data from Excel file called my_data.xlsx*\/ proc import out =my_data datafile =&#8221;\/home\/u13181\/my_data.xlsx&#8221; dbms =xlsx replace ; getnames =YES; run ; Inilah yang dilakukan setiap baris: out : Nama yang akan diberikan pada kumpulan [&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 Mengimpor File Excel ke SAS (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengimpor file Excel ke 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\/seperti-impor-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Mengimpor File Excel ke SAS (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengimpor file Excel ke SAS, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/seperti-impor-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-21T17:04:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/excel11.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\/seperti-impor-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/seperti-impor-excel\/\",\"name\":\"Cara Mengimpor File Excel ke SAS (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-21T17:04:42+00:00\",\"dateModified\":\"2023-07-21T17:04:42+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengimpor file Excel ke SAS, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/seperti-impor-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/seperti-impor-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/seperti-impor-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengimpor file excel ke 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 Mengimpor File Excel ke SAS (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara mengimpor file Excel ke 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\/seperti-impor-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Mengimpor File Excel ke SAS (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara mengimpor file Excel ke SAS, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/seperti-impor-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-21T17:04:42+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/excel11.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\/seperti-impor-excel\/","url":"https:\/\/statorials.org\/id\/seperti-impor-excel\/","name":"Cara Mengimpor File Excel ke SAS (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-21T17:04:42+00:00","dateModified":"2023-07-21T17:04:42+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengimpor file Excel ke SAS, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/seperti-impor-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/seperti-impor-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/seperti-impor-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengimpor file excel ke 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\/2568"}],"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=2568"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2568\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2568"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2568"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2568"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}