{"id":4528,"date":"2023-07-10T09:01:43","date_gmt":"2023-07-10T09:01:43","guid":{"rendered":"https:\/\/statorials.org\/id\/rentang-impor-excel-sas\/"},"modified":"2023-07-10T09:01:43","modified_gmt":"2023-07-10T09:01:43","slug":"rentang-impor-excel-sas","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/rentang-impor-excel-sas\/","title":{"rendered":"Sas: cara mengimpor rentang tertentu dari excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan pernyataan <strong>PROC IMPORT<\/strong> dengan opsi <strong>RANGE<\/strong> untuk mengimpor rentang sel tertentu dari file Excel ke SAS.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, Anda dapat 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 basketball_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\/basketball_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: #3366ff;\">range<\/span> =\"Sheet1$C4:E11\";\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>dmbs<\/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<li> <span style=\"color: #000000;\"><strong>range<\/strong> : Rentang sel yang akan diimpor<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa contoh khusus ini akan mengimpor sel dalam rentang <strong>C4:E11<\/strong> dari <strong>Sheet1<\/strong> dari file Excel bernama <strong>basket_data.xlsx<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menggunakan sintaksis ini dalam praktik dengan file Excel berikut yang disebut <strong>basket_data.xlsx<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35382 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/orange1.png\" alt=\"\" width=\"475\" height=\"430\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><b>Contoh 1: Impor data dari file Excel ke SAS tanpa menentukan rentangnya<\/b><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks berikut untuk mengimpor file Excel ke dalam kumpulan data SAS bernama <strong>my_data<\/strong> tanpa menentukan rentang sel tertentu yang akan diimpor:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008000;\">\/*import data from Excel file called basketball_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\/basketball_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> =my_data;<\/span><\/strong> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35383 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/irange2.png\" alt=\"\" width=\"264\" height=\"289\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Karena kami tidak menggunakan pernyataan <strong>rentang<\/strong> untuk menentukan rentang sel yang akan diimpor, SAS mengimpor semua sel hingga menemukan data di lembar.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><b>Contoh 2: Impor data dari file Excel ke SAS dan tentukan rentangnya<\/b><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks berikut untuk mengimpor file Excel ke dalam kumpulan data SAS bernama <strong>my_data<\/strong> dan menggunakan opsi <strong>rentang<\/strong> untuk mengimpor rentang sel tertentu saja:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008000;\">\/*import specific cells from Excel file called basketball_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\/basketball_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: #3366ff;\">range<\/span> =\"Sheet1$C4:E11\";\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> =my_data;<\/span><\/strong> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35384 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/irange3.png\" alt=\"\" width=\"246\" height=\"229\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Karena kami menggunakan pernyataan <strong>rentang<\/strong> untuk menentukan rentang sel yang akan diimpor, SAS hanya mengimpor sel dalam rentang tersebut dari lembar.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa Anda juga dapat meneruskan rentang bernama ke pernyataan <strong>rentang<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, jika rentang sel <strong>C4:E11<\/strong> memiliki rentang bernama <strong>my_range<\/strong> , Anda bisa menggunakan argumen <strong>range=\u201dmy_range\u201d<\/strong> dalam pernyataan <strong>PROC IMPORT<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk pernyataan <strong>PROC IMPORT<\/strong> di SAS <a href=\"https:\/\/documentation.sas.com\/doc\/en\/pgmsascdc\/9.4_3.5\/proc\/n18jyszn33umngn14czw2qfw7thc.htm\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/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> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/sas-impor-csv\/\" target=\"_blank\" rel=\"noopener\">Cara mengimpor file CSV ke SAS<\/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><br \/> <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","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan pernyataan PROC IMPORT dengan opsi RANGE untuk mengimpor rentang sel tertentu dari file Excel ke SAS. Untuk melakukannya, Anda dapat menggunakan sintaks dasar berikut: \/*import data from Excel file called basketball_data.xlsx*\/ proc import out =my_data datafile =&#8221;\/home\/u13181\/basketball_data.xlsx&#8221; dbms =xlsx replace ; getnames =YES; range =&#8221;Sheet1$C4:E11&#8243;; run ; Inilah yang dilakukan setiap baris: [&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>SAS: Cara mengimpor rentang tertentu dari Excel - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengimpor rentang sel tertentu dari 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\/rentang-impor-excel-sas\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SAS: Cara mengimpor rentang tertentu dari Excel - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengimpor rentang sel tertentu dari Excel ke SAS, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/rentang-impor-excel-sas\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-10T09:01:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/orange1.png\" \/>\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\/rentang-impor-excel-sas\/\",\"url\":\"https:\/\/statorials.org\/id\/rentang-impor-excel-sas\/\",\"name\":\"SAS: Cara mengimpor rentang tertentu dari Excel - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-10T09:01:43+00:00\",\"dateModified\":\"2023-07-10T09:01:43+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengimpor rentang sel tertentu dari Excel ke SAS, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/rentang-impor-excel-sas\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/rentang-impor-excel-sas\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/rentang-impor-excel-sas\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Sas: cara mengimpor rentang tertentu dari excel\"}]},{\"@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":"SAS: Cara mengimpor rentang tertentu dari Excel - Statorials","description":"Tutorial ini menjelaskan cara mengimpor rentang sel tertentu dari 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\/rentang-impor-excel-sas\/","og_locale":"id_ID","og_type":"article","og_title":"SAS: Cara mengimpor rentang tertentu dari Excel - Statorials","og_description":"Tutorial ini menjelaskan cara mengimpor rentang sel tertentu dari Excel ke SAS, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/rentang-impor-excel-sas\/","og_site_name":"Statorials","article_published_time":"2023-07-10T09:01:43+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/orange1.png"}],"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\/rentang-impor-excel-sas\/","url":"https:\/\/statorials.org\/id\/rentang-impor-excel-sas\/","name":"SAS: Cara mengimpor rentang tertentu dari Excel - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-10T09:01:43+00:00","dateModified":"2023-07-10T09:01:43+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengimpor rentang sel tertentu dari Excel ke SAS, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/rentang-impor-excel-sas\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/rentang-impor-excel-sas\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/rentang-impor-excel-sas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Sas: cara mengimpor rentang tertentu dari excel"}]},{"@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\/4528"}],"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=4528"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4528\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4528"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4528"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4528"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}