{"id":4543,"date":"2023-07-10T06:01:57","date_gmt":"2023-07-10T06:01:57","guid":{"rendered":"https:\/\/statorials.org\/id\/tanggal-format-sas-proc-sql\/"},"modified":"2023-07-10T06:01:57","modified_gmt":"2023-07-10T06:01:57","slug":"tanggal-format-sas-proc-sql","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/tanggal-format-sas-proc-sql\/","title":{"rendered":"Sas: cara memformat nilai tanggal di proc sql"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan pernyataan FORMAT<\/strong> dalam PROC SQL<\/strong> di SAS untuk memformat nilai tanggal dengan cara tertentu.<\/span><\/span><\/p>\n

Contoh berikut menunjukkan bagaimana menggunakan pernyataan FORMAT<\/strong> dalam praktiknya.<\/span><\/p>\n

Contoh: Memformat nilai tanggal di PROC SQL<\/strong><\/span><\/h2>\n

Misalkan kita memiliki kumpulan data berikut di SAS yang berisi informasi tentang tanggal mulai promosi di toko ritel dan total penjualan yang dilakukan:<\/span> <\/p>\n

 \/*create dataset*\/\n<\/span>data<\/span> my_data;\n    format<\/span> start_date date9.<\/span> ;\n    input<\/span> start_date: date9.<\/span> dirty;\n    datalines<\/span> ;\n01JAN2023 22\n01FEB2023 16\n14MAR2023 11\n01MAY2023 32\n13MAY2023 15\n18AUG2023 11\n20OCT2023 36\n;\nrun<\/span> ;\n\n\/*view dataset*\/\n<\/span>proc print<\/span> data<\/span> =my_data;\n<\/strong><\/span><\/pre>\n
\"\"<\/p>\n
 Kita dapat menggunakan PROC SQL<\/strong> dengan pernyataan FORMAT<\/strong> untuk memilih semua baris dalam dataset ini dan menampilkan nilai di kolom tanggal_mulai<\/strong> dalam format MM\/DD\/YY<\/strong> :<\/span> <\/p>\n
 \/*select all rows and format start_date column using mmddyy8.*\/ \n<\/span>proc sql<\/span> ;\n    select<\/span> start_date format= mmddyy8.<\/span> , dirty\n    from<\/span> my_data;\nquit<\/span> ;<\/span><\/strong><\/span> <\/pre>\n
\"\"<\/p>\n
 Perhatikan bahwa nilai di kolom tanggal_mulai<\/strong> sekarang ditampilkan dalam format MM\/DD\/YY<\/strong> .<\/span><\/p>\n
 Anda juga dapat menggunakan pernyataan FORMAT<\/strong> untuk memformat variabel baru yang dibuat menggunakan PROC SQL<\/strong> .<\/span><\/p>\n
 Misalnya, kode berikut menunjukkan cara membuat variabel baru bernama tanggal_akhir<\/strong> dengan menambahkan 7 hari ke tanggal_mulai<\/strong> dan memformatnya sebagai tanggal9.<\/strong> alih-alih:<\/span> <\/p>\n
 \/*create new end_date column with specific format*\/ \n<\/span>proc sql<\/span> ;\n    select<\/span> start_date format= mmddyy8.<\/span> , start_date+7 as<\/span> end_date format= date9.<\/span> , dirty\n    from<\/span> my_data;\nquit<\/span> ;<\/strong><\/span> <\/pre>\n
\"\"<\/p>\n
 Perhatikan bahwa kita dapat menentukan format variabel tanggal_mulai<\/strong> dan tanggal_akhir<\/strong> dengan menggunakan pernyataan FORMAT<\/strong> beberapa kali.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di SAS:<\/span><\/p>\n
 SAS: Cara menggunakan operator WHERE di PROC SQL<\/a>
 SAS: Cara menggunakan operator IN di PROC SQL<\/a>
 SAS: Cara menggunakan UPDATE di PROC SQL<\/a>
 SAS: Cara menggunakan CONTAIN dalam PROC SQL<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan pernyataan FORMAT dalam PROC SQL di SAS untuk memformat nilai tanggal dengan cara tertentu. Contoh berikut menunjukkan bagaimana menggunakan pernyataan FORMAT dalam praktiknya. Contoh: Memformat nilai tanggal di PROC SQL Misalkan kita memiliki kumpulan data berikut di SAS yang berisi informasi tentang tanggal mulai promosi di toko ritel dan total penjualan yang […]<\/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":"\nSAS: Cara memformat nilai tanggal di PROC SQL - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memformat nilai tanggal menggunakan PROC SQL di SAS, dengan sebuah 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\/tanggal-format-sas-proc-sql\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SAS: Cara memformat nilai tanggal di PROC SQL - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memformat nilai tanggal menggunakan PROC SQL di SAS, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/tanggal-format-sas-proc-sql\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-10T06:01:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sql1.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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/tanggal-format-sas-proc-sql\/\",\"url\":\"https:\/\/statorials.org\/id\/tanggal-format-sas-proc-sql\/\",\"name\":\"SAS: Cara memformat nilai tanggal di PROC SQL - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-10T06:01:57+00:00\",\"dateModified\":\"2023-07-10T06:01:57+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memformat nilai tanggal menggunakan PROC SQL di SAS, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/tanggal-format-sas-proc-sql\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/tanggal-format-sas-proc-sql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/tanggal-format-sas-proc-sql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Sas: cara memformat nilai tanggal di proc sql\"}]},{\"@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 memformat nilai tanggal di PROC SQL - Statorials","description":"Tutorial ini menjelaskan cara memformat nilai tanggal menggunakan PROC SQL di SAS, dengan sebuah 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\/tanggal-format-sas-proc-sql\/","og_locale":"id_ID","og_type":"article","og_title":"SAS: Cara memformat nilai tanggal di PROC SQL - Statorials","og_description":"Tutorial ini menjelaskan cara memformat nilai tanggal menggunakan PROC SQL di SAS, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/tanggal-format-sas-proc-sql\/","og_site_name":"Statorials","article_published_time":"2023-07-10T06:01:57+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sql1.png"}],"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\/tanggal-format-sas-proc-sql\/","url":"https:\/\/statorials.org\/id\/tanggal-format-sas-proc-sql\/","name":"SAS: Cara memformat nilai tanggal di PROC SQL - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-10T06:01:57+00:00","dateModified":"2023-07-10T06:01:57+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memformat nilai tanggal menggunakan PROC SQL di SAS, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/tanggal-format-sas-proc-sql\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/tanggal-format-sas-proc-sql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/tanggal-format-sas-proc-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Sas: cara memformat nilai tanggal di proc sql"}]},{"@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\/4543"}],"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=4543"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4543\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4543"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4543"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4543"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}