Hello, I have some data similar to what I've put below (only with many more variables and millions of records). I need some code to create a sum of the amount by region. I am aware of the proc print command that does this but I don't want to see a list of the observations for each region as there will be far too many (due to the millions of records). Ideally a new table with this information would be created or some way that I could reference these sums directly for a following piece of code. If I haven't made myself clear enough and more clarification is needed then feel free to ask. Thanks data proctest ; input age region $ amount ; datalines ; 23 NE 364364 45 NW 483933 67 SE 383932 43 NE 483022 54 L 666602 22 SW 483392 77 E 111111 34 SE 292093 ; run;
... View more