{"id":2552,"date":"2023-07-21T18:30:31","date_gmt":"2023-07-21T18:30:31","guid":{"rendered":"https:\/\/statorials.org\/pl\/nie-usuwaj-duplikatow\/"},"modified":"2023-07-21T18:30:31","modified_gmt":"2023-07-21T18:30:31","slug":"nie-usuwaj-duplikatow","status":"publish","type":"post","link":"https:\/\/statorials.org\/pl\/nie-usuwaj-duplikatow\/","title":{"rendered":"Jak usun\u0105\u0107 duplikaty w sas-ie (z przyk\u0142adami)"},"content":{"rendered":"

<\/p>\n

\n

Mo\u017cesz u\u017cy\u0107 sortowania proc<\/strong> w SAS-ie, aby szybko usun\u0105\u0107 zduplikowane wiersze ze zbioru danych.<\/span><\/p>\n

W tej procedurze zastosowano nast\u0119puj\u0105c\u0105 podstawow\u0105 sk\u0142adni\u0119:<\/span><\/p>\n

 proc sort<\/span> data<\/span> =original_data out<\/span> =no_dups_data nodupkey<\/span> ;\n<\/span>by<\/span> _all_;<\/span><\/span>\nrun;\n<\/span><\/span><\/strong><\/pre>\n
 Nale\u017cy pami\u0119ta\u0107, \u017ce argument by<\/strong> okre\u015bla, kt\u00f3re kolumny maj\u0105 by\u0107 skanowane podczas usuwania duplikat\u00f3w.<\/span><\/p>\n
 Poni\u017csze przyk\u0142ady pokazuj\u0105, jak usun\u0105\u0107 duplikaty z nast\u0119puj\u0105cego zbioru danych w SAS-ie:<\/span> <\/p>\n
 \/*create dataset*\/\n<\/span>data<\/span> original_data;\n    input<\/span> team $position $points;\n    datalines<\/span> ;\nA Guard 12\nA Guard 20\nA Guard 20\nA Guard 24\nA Forward 15\nA Forward 15\nA Forward 19\nA Forward 28\nB Guard 10\nB Guard 12\nB Guard 12\nB Guard 26\nB Forward 10\nB Forward 10\nB Forward 10\nB Forward 19\n;\nrun<\/span> ;\n\n\/*view dataset*\/\n<\/span>proc print<\/span> data<\/span> = original_data;<\/span><\/span><\/strong> <\/pre>\n
\"\"<\/p>\n
 Przyk\u0142ad 1: Usu\u0144 duplikaty ze wszystkich kolumn<\/strong><\/span><\/h3>\n
 Mo\u017cemy u\u017cy\u0107 poni\u017cszego kodu, aby usun\u0105\u0107 wiersze, kt\u00f3re maj\u0105 zduplikowane warto\u015bci we wszystkich kolumnach w zbiorze danych:<\/span> <\/p>\n
 \/*create dataset with no duplicate rows*\/\n<\/span>proc sort data<\/span> =original_data out<\/span> =no_dups_data nodupkey<\/span> ;\n    by<\/span> _all_;\nrun<\/span> ;\n\n\/*view dataset with no duplicate rows*\/\n<\/span>proc print<\/span> data<\/span> =no_dups_data;<\/span><\/span><\/strong><\/span> <\/pre>\n
\"\"<\/p>\n
 Nale\u017cy zauwa\u017cy\u0107, \u017ce z oryginalnego zbioru danych usuni\u0119to \u0142\u0105cznie pi\u0119\u0107 zduplikowanych wierszy.<\/span><\/p>\n
 Przyk\u0142ad 2:<\/strong><\/span> Usu\u0144 duplikaty z okre\u015blonych kolumn<\/strong><\/span><\/h3>\n
 Mo\u017cemy u\u017cy\u0107 argumentu by<\/strong> , aby okre\u015bli\u0107, kt\u00f3re kolumny maj\u0105 by\u0107 sprawdzane podczas usuwania duplikat\u00f3w.<\/span><\/p>\n
 Przyk\u0142adowo poni\u017cszy kod usuwa wiersze ze zduplikowanymi warto\u015bciami w kolumnach zesp\u00f3\u0142<\/strong> i pozycja<\/strong> :<\/span> <\/p>\n
 \/*create dataset with no duplicate rows in team and position columns*\/\n<\/span>proc sort<\/span> data<\/span> =original_data out<\/span> =no_dups_data nodupkey<\/span> ;\n    by<\/span> team position;\nrun<\/span> ;\n\n\/*view dataset with no duplicate rows in team and position columns*\/\n<\/span>proc print<\/span> data<\/span> =no_dups_data;<\/span><\/span><\/strong><\/span> <\/pre>\n
\"\"<\/p>\n
 Po usuni\u0119ciu wierszy ze zduplikowanymi warto\u015bciami w kolumnach zespo\u0142u<\/strong> i pozycji<\/strong> w zbiorze danych pozostaj\u0105 tylko cztery wiersze.<\/span><\/p>\n
 Dodatkowe zasoby<\/strong><\/span><\/h3>\n
 Poni\u017csze samouczki wyja\u015bniaj\u0105, jak wykonywa\u0107 inne typowe operacje w SAS-ie:<\/span><\/p>\n
 Jak normalizowa\u0107 dane w SAS-ie<\/a>
 Jak zidentyfikowa\u0107 warto\u015bci odstaj\u0105ce w SAS<\/a>
 Jak korzysta\u0107 ze podsumowania procedur w SAS-ie<\/a>
 Jak tworzy\u0107 tabele cz\u0119sto\u015bci w SAS-ie<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Mo\u017cesz u\u017cy\u0107 sortowania proc w SAS-ie, aby szybko usun\u0105\u0107 zduplikowane wiersze ze zbioru danych. W tej procedurze zastosowano nast\u0119puj\u0105c\u0105 podstawow\u0105 sk\u0142adni\u0119: proc sort data =original_data out =no_dups_data nodupkey ; by _all_; run; Nale\u017cy pami\u0119ta\u0107, \u017ce argument by okre\u015bla, kt\u00f3re kolumny maj\u0105 by\u0107 skanowane podczas usuwania duplikat\u00f3w. Poni\u017csze przyk\u0142ady pokazuj\u0105, jak usun\u0105\u0107 duplikaty z nast\u0119puj\u0105cego zbioru […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-2552","post","type-post","status-publish","format-standard","hentry","category-przewodnik"],"yoast_head":"\nJak usun\u0105\u0107 duplikaty w SAS-ie (z przyk\u0142adami) - Statologia<\/title>\n<meta name=\"description\" content=\"W tym samouczku wyja\u015bniono, jak usun\u0105\u0107 duplikaty w SAS-ie, podaj\u0105c kilka przyk\u0142ad\u00f3w.\" \/>\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\/pl\/nie-usuwaj-duplikatow\/\" \/>\n<meta property=\"og:locale\" content=\"pl_PL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Jak usun\u0105\u0107 duplikaty w SAS-ie (z przyk\u0142adami) - Statologia\" \/>\n<meta property=\"og:description\" content=\"W tym samouczku wyja\u015bniono, jak usun\u0105\u0107 duplikaty w SAS-ie, podaj\u0105c kilka przyk\u0142ad\u00f3w.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/pl\/nie-usuwaj-duplikatow\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-21T18:30:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dups1.jpg\" \/>\n<meta name=\"author\" content=\"Benjamin Anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Napisane przez\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin Anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Szacowany czas czytania\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minuty\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/pl\/nie-usuwaj-duplikatow\/\",\"url\":\"https:\/\/statorials.org\/pl\/nie-usuwaj-duplikatow\/\",\"name\":\"Jak usun\u0105\u0107 duplikaty w SAS-ie (z przyk\u0142adami) - Statologia\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/pl\/#website\"},\"datePublished\":\"2023-07-21T18:30:31+00:00\",\"dateModified\":\"2023-07-21T18:30:31+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/pl\/#\/schema\/person\/6484727a4612df3e69f016c3129c6965\"},\"description\":\"W tym samouczku wyja\u015bniono, jak usun\u0105\u0107 duplikaty w SAS-ie, podaj\u0105c kilka przyk\u0142ad\u00f3w.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/pl\/nie-usuwaj-duplikatow\/#breadcrumb\"},\"inLanguage\":\"pl-PL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/pl\/nie-usuwaj-duplikatow\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/pl\/nie-usuwaj-duplikatow\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Dom\",\"item\":\"https:\/\/statorials.org\/pl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Jak usun\u0105\u0107 duplikaty w sas-ie (z przyk\u0142adami)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/pl\/#website\",\"url\":\"https:\/\/statorials.org\/pl\/\",\"name\":\"Statorials\",\"description\":\"Tw\u00f3j przewodnik po kompetencjach statystycznych!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/pl\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"pl-PL\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/pl\/#\/schema\/person\/6484727a4612df3e69f016c3129c6965\",\"name\":\"Benjamin Anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pl-PL\",\"@id\":\"https:\/\/statorials.org\/pl\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/statorials.org\/pl\/wp-content\/uploads\/2023\/11\/Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"https:\/\/statorials.org\/pl\/wp-content\/uploads\/2023\/11\/Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin Anderson\"},\"description\":\"Cze\u015b\u0107, jestem Benjamin i jestem emerytowanym profesorem statystyki, kt\u00f3ry zosta\u0142 oddanym nauczycielem Statorials. Dzi\u0119ki bogatemu do\u015bwiadczeniu i wiedzy specjalistycznej w dziedzinie statystyki ch\u0119tnie dziel\u0119 si\u0119 swoj\u0105 wiedz\u0105, aby wzmocni\u0107 pozycj\u0119 uczni\u00f3w za po\u015brednictwem Statorials. Wiedzie\u0107 wi\u0119cej\",\"sameAs\":[\"https:\/\/statorials.org\/pl\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Jak usun\u0105\u0107 duplikaty w SAS-ie (z przyk\u0142adami) - Statologia","description":"W tym samouczku wyja\u015bniono, jak usun\u0105\u0107 duplikaty w SAS-ie, podaj\u0105c kilka przyk\u0142ad\u00f3w.","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\/pl\/nie-usuwaj-duplikatow\/","og_locale":"pl_PL","og_type":"article","og_title":"Jak usun\u0105\u0107 duplikaty w SAS-ie (z przyk\u0142adami) - Statologia","og_description":"W tym samouczku wyja\u015bniono, jak usun\u0105\u0107 duplikaty w SAS-ie, podaj\u0105c kilka przyk\u0142ad\u00f3w.","og_url":"https:\/\/statorials.org\/pl\/nie-usuwaj-duplikatow\/","og_site_name":"Statorials","article_published_time":"2023-07-21T18:30:31+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dups1.jpg"}],"author":"Benjamin Anderson","twitter_card":"summary_large_image","twitter_misc":{"Napisane przez":"Benjamin Anderson","Szacowany czas czytania":"2 minuty"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/pl\/nie-usuwaj-duplikatow\/","url":"https:\/\/statorials.org\/pl\/nie-usuwaj-duplikatow\/","name":"Jak usun\u0105\u0107 duplikaty w SAS-ie (z przyk\u0142adami) - Statologia","isPartOf":{"@id":"https:\/\/statorials.org\/pl\/#website"},"datePublished":"2023-07-21T18:30:31+00:00","dateModified":"2023-07-21T18:30:31+00:00","author":{"@id":"https:\/\/statorials.org\/pl\/#\/schema\/person\/6484727a4612df3e69f016c3129c6965"},"description":"W tym samouczku wyja\u015bniono, jak usun\u0105\u0107 duplikaty w SAS-ie, podaj\u0105c kilka przyk\u0142ad\u00f3w.","breadcrumb":{"@id":"https:\/\/statorials.org\/pl\/nie-usuwaj-duplikatow\/#breadcrumb"},"inLanguage":"pl-PL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/pl\/nie-usuwaj-duplikatow\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/pl\/nie-usuwaj-duplikatow\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Dom","item":"https:\/\/statorials.org\/pl\/"},{"@type":"ListItem","position":2,"name":"Jak usun\u0105\u0107 duplikaty w sas-ie (z przyk\u0142adami)"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/pl\/#website","url":"https:\/\/statorials.org\/pl\/","name":"Statorials","description":"Tw\u00f3j przewodnik po kompetencjach statystycznych!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/pl\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"pl-PL"},{"@type":"Person","@id":"https:\/\/statorials.org\/pl\/#\/schema\/person\/6484727a4612df3e69f016c3129c6965","name":"Benjamin Anderson","image":{"@type":"ImageObject","inLanguage":"pl-PL","@id":"https:\/\/statorials.org\/pl\/#\/schema\/person\/image\/","url":"https:\/\/statorials.org\/pl\/wp-content\/uploads\/2023\/11\/Benjamin-Anderson-96x96.jpg","contentUrl":"https:\/\/statorials.org\/pl\/wp-content\/uploads\/2023\/11\/Benjamin-Anderson-96x96.jpg","caption":"Benjamin Anderson"},"description":"Cze\u015b\u0107, jestem Benjamin i jestem emerytowanym profesorem statystyki, kt\u00f3ry zosta\u0142 oddanym nauczycielem Statorials. Dzi\u0119ki bogatemu do\u015bwiadczeniu i wiedzy specjalistycznej w dziedzinie statystyki ch\u0119tnie dziel\u0119 si\u0119 swoj\u0105 wiedz\u0105, aby wzmocni\u0107 pozycj\u0119 uczni\u00f3w za po\u015brednictwem Statorials. Wiedzie\u0107 wi\u0119cej","sameAs":["https:\/\/statorials.org\/pl"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/pl\/wp-json\/wp\/v2\/posts\/2552","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/statorials.org\/pl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/pl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/pl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/pl\/wp-json\/wp\/v2\/comments?post=2552"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/pl\/wp-json\/wp\/v2\/posts\/2552\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/pl\/wp-json\/wp\/v2\/media?parent=2552"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/pl\/wp-json\/wp\/v2\/categories?post=2552"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/pl\/wp-json\/wp\/v2\/tags?post=2552"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}