Ascending order

[ivethguzman]

Hello, I believe I am in the right path but don't know how to rearrange a variable in my data in ascending order.

The question is :

For each region, how many salesmen are in each state, what are the advertising expenditures for each state (in ascending order), and what is the total advertising expenditure for the region

This is what I have so far:

proc print data=datain .newstate;
 	      sum expenses ;
	      by region;
	      options byline;
	      title ‘The sum of salesman for each region by state’;
	      
	      run;

I have attached a file of the output.

[PaigeMiller]

What is wrong with this output?

[hashman · Accepted solution]

@ivethguzman:

First, sort you input file by REGION EXPENSES; then run your proc PRINT as is against the result.  

[PaigeMiller]

---

@hashman wrote:

@ivethguzman:

First, sort you input file by REGION EXPENSES; then run your proc PRINT as is against the result.  

---

Now I'm confused.

The original question asked for each STATE in ascending order.

what are the advertising expenditures for each state (in ascending order)

[hashman]

@PaigeMiller: The sentence can be interpreted as ascending by state or by expenditures. Since the OP's output was already by state within region, while the expenditures within region were disordered, of which s/he seemed to be complaining, ergo ... Perhaps the goal was to use the output to eyeball more readily which states within region had lower expenditures and which ones - higher. Agree that the task could be formulated less murkily.