topic call sortc or sortn in SAS Programming

call sortc or sortn

SAS_inquisitive — Mon, 11 Sep 2017 21:03:54 GMT

Hello,

How does CALL SORTC or CALL SORTN work? Is it a horizontal sorting of the variables?

The following program does not seem to make any changes.

data test;
	set sashelp.class;
	call sortn (age, height);
run;

Re: call sortc or sortn

Reeza — Mon, 11 Sep 2017 21:11:46 GMT

@SAS_inquisitive wrote:

The following program does not seem to make any changes.

That's because age is always less than height anyways. Make a better examle where the order would change to test it properly.

Re: call sortc or sortn

novinosrin — Mon, 11 Sep 2017 21:20:57 GMT

@SAS_inquisitive Reeza rightly mentioned to work on better examples. My suggestion is, if you don't mind and can afford to buy a book, try to get this-

https://www.sas.com/store/prodBK_60864_en.html?storeCode=SAS_US&storeCode=SAS_US

Learning SAS® by Example: A Programmer's Guide

Ron Cody

That has incredible and awesome examples on exactly what you are looking for. Also, you will start to contribute with your solutions very soon.

Re: call sortc or sortn

ballardw — Mon, 11 Sep 2017 21:53:02 GMT

Compare the differences in Example and Example2 in the code below:

data example;
   input v1 v2 v3;
datalines;
1 2 3
3 1 2
27 18 4
;
run;

data example2;
   set example;
   call sortn (v1,v2,v3);
run;

Re: call sortc or sortn

SAS_inquisitive — Tue, 12 Sep 2017 20:25:08 GMT

@novinosorin I have much more SAS books than you can think of. I, sometimes, post questions for the benefit of others too.

Re: call sortc or sortn

novinosrin — Tue, 12 Sep 2017 20:28:13 GMT

Awesome, I wish I could have at least one. Please do post, I'll learn too.Thank you!

Re: call sortc or sortn

SAS_inquisitive — Tue, 12 Sep 2017 20:43:11 GMT

This is learning and knowledge sharing forum. One should take it easy to each other.