Metoda 1: obliczenie sumy wed\u0142ug grupy<\/strong><\/span><\/p>\n Metoda 2: oblicz sum\u0119 wed\u0142ug kilku grup<\/strong><\/span><\/p>\n Poni\u017csze przyk\u0142ady pokazuj\u0105, jak u\u017cywa\u0107 ka\u017cdej metody z nast\u0119puj\u0105cym zbiorem danych w SAS-owym:<\/span> <\/p>\n Poni\u017cszy kod pokazuje, jak obliczy\u0107 sum\u0119 punkt\u00f3w na dru\u017cyn\u0119:<\/span> <\/p>\n Z wyniku widzimy, \u017ce zawodnicy dru\u017cyny A zdobyli \u0142\u0105cznie 94<\/strong> punkty, a zawodnicy dru\u017cyny B \u0142\u0105cznie 109<\/strong> punkt\u00f3w.<\/span><\/p>\n Poni\u017cszy kod pokazuje, jak obliczy\u0107 sum\u0119 punkt\u00f3w, grupa wed\u0142ug dru\u017cyny i pozycja:<\/span> <\/p>\n Wynikowa tabela pokazuje sum\u0119 punkt\u00f3w zdobytych przez graczy na podstawie ich dru\u017cyny i pozycji.<\/span><\/p>\n Poni\u017csze samouczki wyja\u015bniaj\u0105, jak wykonywa\u0107 inne typowe zadania w SAS-ie:<\/span><\/p>\n Jak normalizowa\u0107 dane w SAS-ie<\/a> Aby obliczy\u0107 sum\u0119 warto\u015bci wed\u0142ug grup w SAS-ie, mo\u017cesz u\u017cy\u0107 nast\u0119puj\u0105cych metod: Metoda 1: obliczenie sumy wed\u0142ug grupy proc sql ; select var1, sum(var2) as sum_var2 from my_data group by var1; quit ; Metoda 2: oblicz sum\u0119 wed\u0142ug kilku grup proc sql ; select var1, var2, sum(var3) as sum_var3 from my_data group by var1, var2; […]<\/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-2592","post","type-post","status-publish","format-standard","hentry","category-przewodnik"],"yoast_head":"\n proc sql<\/span> ;\n select<\/span> var1, sum(var2) as<\/span> sum_var2\n from<\/span> my_data\n group<\/span> by var1;\nquit<\/span> ;\n<\/strong><\/span><\/pre>\n proc sql<\/span> ;\n select<\/span> var1, var2, sum(var3) as<\/span> sum_var3\n from<\/span> my_data\n group<\/span> by var1, var2;\nquit<\/span> ;<\/strong><\/span><\/pre>\n \/*create dataset*\/\n<\/span>data<\/span> my_data;\n input<\/span> team $position $points;\n datalines<\/span> ;\nA Guard 15\nA Guard 12\nA Guard 29\nA Forward 13\nA Forward 9\nA Forward 16\nB Guard 25\nB Guard 20\nB Guard 34\nB Forward 19\nB Forward 3\nB Forward 8\n;\nrun<\/span> ;\n\n\/*view dataset*\/\n<\/span>proc print<\/span> data<\/span> =my_data;<\/strong><\/span> <\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sassomme1.jpg\")
<\/p>\n Przyk\u0142ad 1: Oblicz sum\u0119 dla grupy<\/strong><\/span><\/h3>\n
\/*calculate sum of points by team*\/\nproc sql<\/span> ;\n select<\/span> team, sum(points) as<\/span> sum_points\n from<\/span> my_data\n group by<\/span> team;\nquit<\/span> ;\n<\/span><\/span><\/strong><\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sassomme2.jpg\")
<\/p>\n Przyk\u0142ad 2: oblicz sum\u0119 wed\u0142ug kilku grup<\/strong><\/span><\/h3>\n
\/*calculate sum of points by team, grouped by team and position*\/\nproc sql<\/span> ;\n select<\/span> team, position, sum(points) as<\/span> sum_points\n from<\/span> my_data\n group by<\/span> team, position;\nquit<\/span> ;<\/span><\/span><\/strong> <\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sassomme3.jpg\")
<\/p>\n Dodatkowe zasoby<\/span><\/strong><\/span><\/h3>\n
Jak zmieni\u0107 nazwy zmiennych w SAS-ie<\/a>
Jak usun\u0105\u0107 duplikaty w SAS-ie<\/a>
Jak zast\u0105pi\u0107 brakuj\u0105ce warto\u015bci zerem w SAS-ie<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"