{"id":4562,"date":"2023-07-10T02:25:38","date_gmt":"2023-07-10T02:25:38","guid":{"rendered":"https:\/\/statorials.org\/pt\/funcao-de-traducao-sas\/"},"modified":"2023-07-10T02:25:38","modified_gmt":"2023-07-10T02:25:38","slug":"funcao-de-traducao-sas","status":"publish","type":"post","link":"https:\/\/statorials.org\/pt\/funcao-de-traducao-sas\/","title":{"rendered":"Como usar a fun\u00e7\u00e3o translate no sas (com exemplos)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Voc\u00ea pode usar a fun\u00e7\u00e3o <b>TRANSLATE<\/b> no SAS para substituir todas as ocorr\u00eancias de caracteres espec\u00edficos em uma string por novos caracteres.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Esta fun\u00e7\u00e3o usa a seguinte sintaxe:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>TRADUZIR (fonte, para, de)<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Ouro:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>fonte:<\/strong> Nome da vari\u00e1vel a ser pesquisada<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>to<\/strong> : Caracteres a serem usados como substitutos<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>from<\/strong> : Caracteres a serem substitu\u00eddos<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Os exemplos a seguir mostram como usar esta fun\u00e7\u00e3o na pr\u00e1tica com o seguinte conjunto de dados no SAS:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008000;\">\/*create dataset*\/\n<\/span><span style=\"color: #800080;\">data<\/span> my_data;\n    <span style=\"color: #3366ff;\">input<\/span> team $position $points assists;\n    <span style=\"color: #3366ff;\">datalines<\/span> ;\nA Guard 14 4\nA Guard 22 6\nA Guard 24 9\nA Forward 13 8\nA Forward 13 9\nA Guard 10 5\nB Guard 24 4\nB Guard 22 6\nB Forward 34 2\nB Forward 15 5\nB Forward 23 5\nB Guard 10 4\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<\/strong><\/span><\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35625 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/traduire1.png\" alt=\"\" width=\"286\" height=\"327\" srcset=\"\" sizes=\"auto, \"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Exemplo 1: Use TRANSLATE para substituir caracteres por novos caracteres<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">O c\u00f3digo a seguir mostra como usar a fun\u00e7\u00e3o <b>TRANSLATE<\/b> para substituir cada ocorr\u00eancia da letra \u201cr\u201d na coluna <strong>de posi\u00e7\u00e3o<\/strong> por um \u201cz\u201d:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008000;\">\/*create new dataset*\/\n<\/span><span style=\"color: #800080;\">data<\/span> new_data;\n    <span style=\"color: #3366ff;\">set<\/span> original_data;\n    position = <span style=\"color: #3366ff;\">translate<\/span> (position, \"z\", \"r\");\n<span style=\"color: #800080;\">run<\/span> ;\n\n<span style=\"color: #008000;\">\/*view new dataset*\/\n<\/span><span style=\"color: #800080;\">proc print<\/span> <span style=\"color: #3366ff;\">data<\/span> =new_data;<\/strong><\/span> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35626 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/traduire2.png\" alt=\"\" width=\"285\" height=\"338\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Observe que todas as ocorr\u00eancias da letra \u201cr\u201d na coluna <strong>de posi\u00e7\u00e3o<\/strong> foram substitu\u00eddas pela letra \u201cz\u201d.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Exemplo 2: Use TRANSLATE para substituir caracteres por espa\u00e7os<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">O c\u00f3digo a seguir mostra como usar a fun\u00e7\u00e3o <b>TRANSLATE<\/b> para substituir cada ocorr\u00eancia de \u201cr\u201d na coluna <b>de posi\u00e7\u00e3o<\/b> por um espa\u00e7o:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008000;\">\/*create new dataset*\/\n<\/span><span style=\"color: #800080;\">data<\/span> new_data;\n    <span style=\"color: #3366ff;\">set<\/span> my_data;\n    position = <span style=\"color: #3366ff;\">compress<\/span> ( <span style=\"color: #3366ff;\">translate<\/span> (position, \"\", \"r\"));\n<span style=\"color: #800080;\">run<\/span> ;\n\n<span style=\"color: #008000;\">\/*view new dataset*\/\n<\/span><span style=\"color: #800080;\">proc print<\/span> <span style=\"color: #3366ff;\">data<\/span> =new_data;<\/strong><\/span> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35627 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/traduire3.png\" alt=\"\" width=\"286\" height=\"331\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Observe que cada ocorr\u00eancia de \u201cr\u201d na coluna <strong>de posi\u00e7\u00e3o<\/strong> foi substitu\u00edda por um espa\u00e7o.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Isso tem o mesmo efeito que simplesmente remover a string \u201cr\u201d de cada nome de postagem.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Nota n\u00ba 1<\/strong> : envolvemos a fun\u00e7\u00e3o <a href=\"https:\/\/statorials.org\/pt\/funcao-de-compressao-da-camara-de-ar\/\" target=\"_blank\" rel=\"noopener\">COMPRESS<\/a> em torno da fun\u00e7\u00e3o <strong>TRANSLATE<\/strong> para remover todos os espa\u00e7os das strings na coluna <strong>de posi\u00e7\u00e3o<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Observa\u00e7\u00e3o n\u00ba 2<\/strong> : voc\u00ea pode encontrar a documenta\u00e7\u00e3o completa da fun\u00e7\u00e3o SAS <b>TRANSLATE<\/b> <a href=\"https:\/\/documentation.sas.com\/doc\/en\/pgmsascdc\/v_038\/lefunctionsref\/p05ww22zp7lcg3n1bjk7v93tscyo.htm\" target=\"_blank\" rel=\"noopener\">aqui<\/a> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Recursos adicionais<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Os tutoriais a seguir explicam como executar outras tarefas comuns no SAS:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/pt\/sas-extrair-numero-do-canal\/\" target=\"_blank\" rel=\"noopener\">Como extrair n\u00fameros de uma string no SAS<\/a><br \/> <a href=\"https:\/\/statorials.org\/pt\/sob-funcao-de-airlock\/\" target=\"_blank\" rel=\"noopener\">Como usar a fun\u00e7\u00e3o SUBSTR no SAS<\/a><br \/><a href=\"https:\/\/statorials.org\/pt\/nao-remova-caracteres-especiais\/\" target=\"_blank\" rel=\"noopener\">Como remover caracteres especiais de strings no SAS<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Voc\u00ea pode usar a fun\u00e7\u00e3o TRANSLATE no SAS para substituir todas as ocorr\u00eancias de caracteres espec\u00edficos em uma string por novos caracteres. Esta fun\u00e7\u00e3o usa a seguinte sintaxe: TRADUZIR (fonte, para, de) Ouro: fonte: Nome da vari\u00e1vel a ser pesquisada to : Caracteres a serem usados como substitutos from : Caracteres a serem substitu\u00eddos Os [&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":[],"class_list":["post-4562","post","type-post","status-publish","format-standard","hentry","category-guia"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Como usar a fun\u00e7\u00e3o TRANSLATE no SAS (com exemplos) - Estatologia<\/title>\n<meta name=\"description\" content=\"Este tutorial explica como usar a fun\u00e7\u00e3o TRANSLATE no SAS para substituir caracteres espec\u00edficos em uma string por novos caracteres.\" \/>\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\/pt\/funcao-de-traducao-sas\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Como usar a fun\u00e7\u00e3o TRANSLATE no SAS (com exemplos) - Estatologia\" \/>\n<meta property=\"og:description\" content=\"Este tutorial explica como usar a fun\u00e7\u00e3o TRANSLATE no SAS para substituir caracteres espec\u00edficos em uma string por novos caracteres.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/pt\/funcao-de-traducao-sas\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-10T02:25:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/traduire1.png\" \/>\n<meta name=\"author\" content=\"Dr. benjamim anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dr. benjamim anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/pt\/funcao-de-traducao-sas\/\",\"url\":\"https:\/\/statorials.org\/pt\/funcao-de-traducao-sas\/\",\"name\":\"Como usar a fun\u00e7\u00e3o TRANSLATE no SAS (com exemplos) - Estatologia\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/pt\/#website\"},\"datePublished\":\"2023-07-10T02:25:38+00:00\",\"dateModified\":\"2023-07-10T02:25:38+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/pt\/#\/schema\/person\/e08f98e8db95e0aa9c310e1b27c9c666\"},\"description\":\"Este tutorial explica como usar a fun\u00e7\u00e3o TRANSLATE no SAS para substituir caracteres espec\u00edficos em uma string por novos caracteres.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/pt\/funcao-de-traducao-sas\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/pt\/funcao-de-traducao-sas\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/pt\/funcao-de-traducao-sas\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Lar\",\"item\":\"https:\/\/statorials.org\/pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como usar a fun\u00e7\u00e3o translate no sas (com exemplos)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/pt\/#website\",\"url\":\"https:\/\/statorials.org\/pt\/\",\"name\":\"Statorials\",\"description\":\"O seu guia para a literacia estat\u00edstica!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/pt\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/pt\/#\/schema\/person\/e08f98e8db95e0aa9c310e1b27c9c666\",\"name\":\"Dr. benjamim anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/statorials.org\/pt\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/statorials.org\/pt\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"https:\/\/statorials.org\/pt\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Dr. benjamim anderson\"},\"description\":\"Ol\u00e1, sou Benjamin, um professor aposentado de estat\u00edstica que se tornou professor dedicado na Statorials. Com vasta experi\u00eancia e conhecimento na \u00e1rea de estat\u00edstica, estou empenhado em compartilhar meu conhecimento para capacitar os alunos por meio de Statorials. Saber mais\",\"sameAs\":[\"https:\/\/statorials.org\/pt\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Como usar a fun\u00e7\u00e3o TRANSLATE no SAS (com exemplos) - Estatologia","description":"Este tutorial explica como usar a fun\u00e7\u00e3o TRANSLATE no SAS para substituir caracteres espec\u00edficos em uma string por novos caracteres.","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\/pt\/funcao-de-traducao-sas\/","og_locale":"pt_PT","og_type":"article","og_title":"Como usar a fun\u00e7\u00e3o TRANSLATE no SAS (com exemplos) - Estatologia","og_description":"Este tutorial explica como usar a fun\u00e7\u00e3o TRANSLATE no SAS para substituir caracteres espec\u00edficos em uma string por novos caracteres.","og_url":"https:\/\/statorials.org\/pt\/funcao-de-traducao-sas\/","og_site_name":"Statorials","article_published_time":"2023-07-10T02:25:38+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/traduire1.png"}],"author":"Dr. benjamim anderson","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Dr. benjamim anderson","Tempo estimado de leitura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/pt\/funcao-de-traducao-sas\/","url":"https:\/\/statorials.org\/pt\/funcao-de-traducao-sas\/","name":"Como usar a fun\u00e7\u00e3o TRANSLATE no SAS (com exemplos) - Estatologia","isPartOf":{"@id":"https:\/\/statorials.org\/pt\/#website"},"datePublished":"2023-07-10T02:25:38+00:00","dateModified":"2023-07-10T02:25:38+00:00","author":{"@id":"https:\/\/statorials.org\/pt\/#\/schema\/person\/e08f98e8db95e0aa9c310e1b27c9c666"},"description":"Este tutorial explica como usar a fun\u00e7\u00e3o TRANSLATE no SAS para substituir caracteres espec\u00edficos em uma string por novos caracteres.","breadcrumb":{"@id":"https:\/\/statorials.org\/pt\/funcao-de-traducao-sas\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/pt\/funcao-de-traducao-sas\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/pt\/funcao-de-traducao-sas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Lar","item":"https:\/\/statorials.org\/pt\/"},{"@type":"ListItem","position":2,"name":"Como usar a fun\u00e7\u00e3o translate no sas (com exemplos)"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/pt\/#website","url":"https:\/\/statorials.org\/pt\/","name":"Statorials","description":"O seu guia para a literacia estat\u00edstica!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/pt\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"pt-PT"},{"@type":"Person","@id":"https:\/\/statorials.org\/pt\/#\/schema\/person\/e08f98e8db95e0aa9c310e1b27c9c666","name":"Dr. benjamim anderson","image":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/statorials.org\/pt\/#\/schema\/person\/image\/","url":"https:\/\/statorials.org\/pt\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"https:\/\/statorials.org\/pt\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Dr. benjamim anderson"},"description":"Ol\u00e1, sou Benjamin, um professor aposentado de estat\u00edstica que se tornou professor dedicado na Statorials. Com vasta experi\u00eancia e conhecimento na \u00e1rea de estat\u00edstica, estou empenhado em compartilhar meu conhecimento para capacitar os alunos por meio de Statorials. Saber mais","sameAs":["https:\/\/statorials.org\/pt"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/posts\/4562","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/comments?post=4562"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/posts\/4562\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/media?parent=4562"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/categories?post=4562"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/tags?post=4562"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}