topic Re: Ascending order in SAS Programming

Ascending order

ivethguzman — Sun, 13 Oct 2019 21:16:32 GMT

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.

Re: Ascending order

PaigeMiller — Mon, 14 Oct 2019 01:00:50 GMT

What is wrong with this output?

Re: Ascending order

hashman — Mon, 14 Oct 2019 02:55:45 GMT

@ivethguzman:

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

Re: Ascending order

PaigeMiller — Mon, 14 Oct 2019 11:26:15 GMT

@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)

Re: Ascending order

hashman — Mon, 14 Oct 2019 16:17:19 GMT

@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.