{"id":4573,"date":"2023-07-10T00:00:31","date_gmt":"2023-07-10T00:00:31","guid":{"rendered":"https:\/\/statorials.org\/id\/sas-proc-impor\/"},"modified":"2023-07-10T00:00:31","modified_gmt":"2023-07-10T00:00:31","slug":"sas-proc-impor","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/sas-proc-impor\/","title":{"rendered":"Panduan lengkap: cara menggunakan proc import di sas"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan pernyataan <strong>PROC IMPORT<\/strong> untuk mengimpor file data eksternal ke SAS.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pernyataan ini menggunakan sintaks dasar berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><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.csv\"\n    <span style=\"color: #3366ff;\">dbms<\/span> =csv\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 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;\">Anda dapat menggunakan sintaks umum ini untuk mengimpor hampir semua jenis file ke SAS. Anda hanya perlu mengubah nilai argumen <strong>dbms<\/strong> tergantung pada jenis file yang Anda impor.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Untuk mengimpor file CSV, tentukan <strong>dbms=csv<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\">Untuk mengimpor file Excel, tentukan <strong>dbms=xlsx<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\">Untuk mengimpor file teks, tentukan <strong>dbms=dlm<\/strong><\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan <strong>PROC IMPORT<\/strong> untuk mengimpor setiap jenis file ini.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><b>Contoh 1: Gunakan PROC IMPORT untuk mengimpor file CSV<\/b><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki file CSV berikut bernama <strong>my_data.csv<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-22801 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/csv3.jpg\" alt=\"\" width=\"391\" height=\"337\" 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 CSV file called my_data.csv*\/\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.csv\"\n    <span style=\"color: #3366ff;\">dbms<\/span> =csv\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 di output SAS cocok dengan data yang ditampilkan di file CSV.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><b>Contoh 2:<\/b><\/span> <span style=\"color: #000000;\"><b>Gunakan PROC IMPORT untuk mengimpor file Excel<\/b><\/span><\/h2>\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<h2> <span style=\"color: #000000;\"><b>Contoh 3:<\/b><\/span> <span style=\"color: #000000;\"><b>Gunakan PROC IMPORT untuk mengimpor file teks<\/b><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki file teks berikut bernama <strong>data.txt<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-12454 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/txtpandas1.png\" alt=\"\" width=\"452\" height=\"425\" 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 text file called data.txt*\/\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\/data.txt\"\n    <span style=\"color: #3366ff;\">dbms<\/span> =dlm\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-35371 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sasi1.png\" alt=\"\" width=\"195\" height=\"272\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Data yang ditampilkan di output SAS cocok dengan data yang ditampilkan di file teks.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Lihat <a href=\"https:\/\/documentation.sas.com\/doc\/en\/pgmsascdc\/9.4_3.5\/proc\/n18jyszn33umngn14czw2qfw7thc.htm\" target=\"_blank\" rel=\"noopener\">halaman dokumentasi<\/a> SAS untuk daftar lengkap argumen opsional yang dapat Anda gunakan saat mengimpor file.<\/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\/rentang-impor-excel-sas\/\" target=\"_blank\" rel=\"noopener\">SAS: Cara mengimpor rentang tertentu dari Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/prosedur-ringkasan-di-sas\/\" target=\"_blank\" rel=\"noopener\">SAS: Cara menggunakan ringkasan prosedur untuk meringkas kumpulan data<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/sebagai-konten-proc\/\" target=\"_blank\" rel=\"noopener\">SAS: Cara menggunakan konten Proc untuk mendapatkan konten dataset<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan pernyataan PROC IMPORT untuk mengimpor file data eksternal ke SAS. Pernyataan ini menggunakan sintaks dasar berikut: proc import out =my_data datafile =&#8221;\/home\/u13181\/my_data.csv&#8221; dbms =csv replace ; getnames =YES; run ; Inilah yang dilakukan setiap baris: out : Nama yang akan diberikan pada kumpulan data setelah diimpor ke SAS datafile : Lokasi file [&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>Panduan lengkap: Cara menggunakan PROC IMPORT di SAS - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan PROC IMPORT untuk mengimpor file 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\/sas-proc-impor\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Panduan lengkap: Cara menggunakan PROC IMPORT di SAS - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan PROC IMPORT untuk mengimpor file ke SAS, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/sas-proc-impor\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-10T00:00:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/csv3.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-proc-impor\/\",\"url\":\"https:\/\/statorials.org\/id\/sas-proc-impor\/\",\"name\":\"Panduan lengkap: Cara menggunakan PROC IMPORT di SAS - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-10T00:00:31+00:00\",\"dateModified\":\"2023-07-10T00:00:31+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan PROC IMPORT untuk mengimpor file ke SAS, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/sas-proc-impor\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/sas-proc-impor\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/sas-proc-impor\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Panduan lengkap: cara menggunakan proc import di sas\"}]},{\"@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":"Panduan lengkap: Cara menggunakan PROC IMPORT di SAS - Statorials","description":"Tutorial ini menjelaskan cara menggunakan PROC IMPORT untuk mengimpor file 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\/sas-proc-impor\/","og_locale":"id_ID","og_type":"article","og_title":"Panduan lengkap: Cara menggunakan PROC IMPORT di SAS - Statorials","og_description":"Tutorial ini menjelaskan cara menggunakan PROC IMPORT untuk mengimpor file ke SAS, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/sas-proc-impor\/","og_site_name":"Statorials","article_published_time":"2023-07-10T00:00:31+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/csv3.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-proc-impor\/","url":"https:\/\/statorials.org\/id\/sas-proc-impor\/","name":"Panduan lengkap: Cara menggunakan PROC IMPORT di SAS - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-10T00:00:31+00:00","dateModified":"2023-07-10T00:00:31+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan PROC IMPORT untuk mengimpor file ke SAS, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/sas-proc-impor\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/sas-proc-impor\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/sas-proc-impor\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Panduan lengkap: cara menggunakan proc import di sas"}]},{"@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\/4573"}],"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=4573"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4573\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4573"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4573"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4573"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}