joherndon Tracker
https://communities.sas.com/kntur85557/tracker
joherndon TrackerTue, 21 May 2024 21:02:31 GMT2024-05-21T21:02:31ZRe: need help on proc summary procedure
https://communities.sas.com/t5/SAS-Procedures/need-help-on-proc-summary-procedure/m-p/627308#M77494
Thanks for your helpTue, 25 Feb 2020 19:53:51 GMThttps://communities.sas.com/t5/SAS-Procedures/need-help-on-proc-summary-procedure/m-p/627308#M77494joherndon2020-02-25T19:53:51ZRe: need help on proc summary procedure
https://communities.sas.com/t5/SAS-Procedures/need-help-on-proc-summary-procedure/m-p/626630#M77466
<P>Thanks for your quick reply. I used the same syntax you have provided. I am getting following out put. I don't want the first six rows.</P><P>I can use missing function and delete those values. but In my work I have millions of rows (four category variables). I used drop= _freq_ _type_ for my out put data set. So is there any short cut to get the data I want</P><P> </P><P> </P><P>generated out put</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>.</TD><TD>.</TD><TD>426</TD><TD>786</TD><TD>1026</TD></TR><TR><TD>.</TD><TD>AAAA</TD><TD>210</TD><TD>390</TD><TD>510</TD></TR><TR><TD>.</TD><TD>BBBB</TD><TD>216</TD><TD>396</TD><TD>516</TD></TR><TR><TD>Aug-20</TD><TD>.</TD><TD>138</TD><TD>258</TD><TD>338</TD></TR><TR><TD>Sep-20</TD><TD>.</TD><TD>142</TD><TD>262</TD><TD>342</TD></TR><TR><TD>Oct-20</TD><TD>.</TD><TD>146</TD><TD>266</TD><TD>346</TD></TR><TR><TD>Aug-20</TD><TD>AAAA</TD><TD>66</TD><TD>126</TD><TD>166</TD></TR><TR><TD>Aug-20</TD><TD>BBBB</TD><TD>72</TD><TD>132</TD><TD>172</TD></TR><TR><TD>Sep-20</TD><TD>AAAA</TD><TD>74</TD><TD>134</TD><TD>174</TD></TR><TR><TD>Sep-20</TD><TD>BBBB</TD><TD>68</TD><TD>128</TD><TD>168</TD></TR><TR><TD>Oct-20</TD><TD>AAAA</TD><TD>70</TD><TD>130</TD><TD>170</TD></TR><TR><TD>Oct-20</TD><TD>BBBB</TD><TD>76</TD><TD>136</TD><TD>176</TD></TR></TBODY></TABLE><P> </P><P>desired output</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Aug-20</TD><TD>AAAA</TD><TD>66</TD><TD>126</TD><TD>166</TD></TR><TR><TD>Aug-20</TD><TD>BBBB</TD><TD>72</TD><TD>132</TD><TD>172</TD></TR><TR><TD>Sep-20</TD><TD>AAAA</TD><TD>74</TD><TD>134</TD><TD>174</TD></TR><TR><TD>Sep-20</TD><TD>BBBB</TD><TD>68</TD><TD>128</TD><TD>168</TD></TR><TR><TD>Oct-20</TD><TD>AAAA</TD><TD>70</TD><TD>130</TD><TD>170</TD></TR><TR><TD>Oct-20</TD><TD>BBBB</TD><TD>76</TD><TD>136</TD><TD>176</TD></TR></TBODY></TABLE><P> </P><P>my syntax:</P><P> </P><P>proc summary data=have;</P><P>class date name;</P><P>var marks:;</P><P>output out=want (drop=_freq_ _type_) sum=;</P><P>run;</P><P> </P><P>Thanks in advance;</P>Sat, 22 Feb 2020 14:13:09 GMThttps://communities.sas.com/t5/SAS-Procedures/need-help-on-proc-summary-procedure/m-p/626630#M77466joherndon2020-02-22T14:13:09Zneed help on proc summary procedure
https://communities.sas.com/t5/SAS-Procedures/need-help-on-proc-summary-procedure/m-p/626593#M77461
<P>raw data I have is </P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Date</TD><TD>name</TD><TD>marks1</TD><TD>marks2</TD><TD>marks3</TD></TR><TR><TD>Aug-20</TD><TD>AAAA</TD><TD>30</TD><TD>60</TD><TD>80</TD></TR><TR><TD>Sep-20</TD><TD>BBBB</TD><TD>31</TD><TD>61</TD><TD>81</TD></TR><TR><TD>Oct-20</TD><TD>AAAA</TD><TD>32</TD><TD>62</TD><TD>82</TD></TR><TR><TD>Aug-20</TD><TD>BBBB</TD><TD>33</TD><TD>63</TD><TD>83</TD></TR><TR><TD>Sep-20</TD><TD>AAAA</TD><TD>34</TD><TD>64</TD><TD>84</TD></TR><TR><TD>Oct-20</TD><TD>BBBB</TD><TD>35</TD><TD>65</TD><TD>85</TD></TR><TR><TD>Aug-20</TD><TD>AAAA</TD><TD>36</TD><TD>66</TD><TD>86</TD></TR><TR><TD>Sep-20</TD><TD>BBBB</TD><TD>37</TD><TD>67</TD><TD>87</TD></TR><TR><TD>Oct-20</TD><TD>AAAA</TD><TD>38</TD><TD>68</TD><TD>88</TD></TR><TR><TD>Aug-20</TD><TD>BBBB</TD><TD>39</TD><TD>69</TD><TD>89</TD></TR><TR><TD>Sep-20</TD><TD>AAAA</TD><TD>40</TD><TD>70</TD><TD>90</TD></TR><TR><TD>Oct-20</TD><TD>BBBB</TD><TD>41</TD><TD>71</TD><TD>91</TD></TR></TBODY></TABLE><P> I want to transform my raw data to be like this(below)</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Aug-20</TD><TD>AAAA</TD><TD>66</TD><TD>126</TD><TD>166</TD></TR><TR><TD>Aug-20</TD><TD>BBBB</TD><TD>72</TD><TD>132</TD><TD>172</TD></TR><TR><TD>Sep-20</TD><TD>AAAA</TD><TD>74</TD><TD>134</TD><TD>174</TD></TR><TR><TD>Sep-20</TD><TD>BBBB</TD><TD>68</TD><TD>128</TD><TD>168</TD></TR><TR><TD>Oct-20</TD><TD>AAAA</TD><TD>70</TD><TD>130</TD><TD>170</TD></TR><TR><TD>Oct-20</TD><TD>BBBB</TD><TD>76</TD><TD>136</TD><TD>176</TD></TR></TBODY></TABLE><P> Which procedure can i use to do get the desired output. Please give me the syntax. I need answer as soon as possible.</P>Sat, 22 Feb 2020 03:00:55 GMThttps://communities.sas.com/t5/SAS-Procedures/need-help-on-proc-summary-procedure/m-p/626593#M77461joherndon2020-02-22T03:00:55ZRe: feature in file menu-Print to PDF
https://communities.sas.com/t5/SAS-Visual-Analytics/feature-in-file-menu-Print-to-PDF/m-p/465495#M10298
<P>I tried as you mentioned, but still I am getting the same problem</P>Mon, 28 May 2018 15:14:43 GMThttps://communities.sas.com/t5/SAS-Visual-Analytics/feature-in-file-menu-Print-to-PDF/m-p/465495#M10298joherndon2018-05-28T15:14:43Zfeature in file menu-Print to PDF
https://communities.sas.com/t5/SAS-Visual-Analytics/feature-in-file-menu-Print-to-PDF/m-p/465365#M10293
<P>Hi,</P><P> I have 5 sections in my report and each report I have logos, text boxes,list table,charts etc. I would like to print one section and also in that section I would like to print 2 logos and list table. Once I clicked Print to PDF from File menu, my PDF contains 5 pages. It contains one logo in each page and list table in another page. It doesn't look professional. I need help on this. I want them in 1 or 2 pages.</P>Sun, 27 May 2018 21:17:50 GMThttps://communities.sas.com/t5/SAS-Visual-Analytics/feature-in-file-menu-Print-to-PDF/m-p/465365#M10293joherndon2018-05-27T21:17:50Zregarding List table
https://communities.sas.com/t5/SAS-Visual-Analytics/regarding-List-table/m-p/465364#M10292
<P>I have a list table in my report , when I tried to sort the column name using the arrow icon next to it, it is not working. need suggestion</P>Sun, 27 May 2018 21:15:22 GMThttps://communities.sas.com/t5/SAS-Visual-Analytics/regarding-List-table/m-p/465364#M10292joherndon2018-05-27T21:15:22Zregarding Print to PDF
https://communities.sas.com/t5/SAS-Visual-Analytics/regarding-Print-to-PDF/m-p/465361#M10291
<P>Hi,</P><P> I have 5 sections in my report and each report I have logos, text boxes,list table,charts etc. I would like to print one section and also in that section I would like to print 2 logos and list table. Once I clicked Print to PDF from File menu, my PDF contains 5 pages. It contains one logo in each page and list table in another page. It doesn't look professional. I need help on this. I want them in 1 or 2 pages.</P>Sun, 27 May 2018 21:11:10 GMThttps://communities.sas.com/t5/SAS-Visual-Analytics/regarding-Print-to-PDF/m-p/465361#M10291joherndon2018-05-27T21:11:10Z