topic Re: Sorting a Muldimensional Array/Matrix inside a FCMP function in New SAS User

Sorting a Muldimensional Array/Matrix inside a FCMP function

Billa — Mon, 28 Jan 2019 02:13:19 GMT

Hi Experts,

I have a muldimensional array array_mult_zero_coupon[500,4] and I would like to sort it by a specific dimension/Column (example: by the second dimension).

Two Questions:

1. Can I use Call Sortn() function in the Proc FCMP ?

call sortn(of array_mult_zero_coupon[*]);
ERROR: Argument number 1 to the CALL subroutine SORTN must be a variable.

2. Does anyone could give a example of how to sort an multidimensional/matrix array without call sort?

Regards,

Re: Sorting a Muldimensional Array/Matrix inside a FCMP function

ballardw — Mon, 28 Jan 2019 15:46:42 GMT

@Billa wrote:

Hi Experts,

I have a muldimensional array array_mult_zero_coupon[500,4] and I would like to sort it by a specific dimension/Column (example: by the second dimension).

Two Questions:

1. Can I use Call Sortn() function in the Proc FCMP ?

call sortn(of array_mult_zero_coupon[*]);
ERROR: Argument number 1 to the CALL subroutine SORTN must be a variable.

2. Does anyone could give a example of how to sort an multidimensional/matrix array without call sort?

Regards,

When discussing errors it is always a good idea to include the entire proc or data step that generated the error from the log as well as all notes, warnings and errors. Best is to paste the text copied from the log into a code box opened with the forum's {I} icon to preserve formatting of messages.

I would suspect from the incomplete code that you have an issue with declaring the parameters for the function or subroutine that attempts to use call sortn.

Re: Sorting a Muldimensional Array/Matrix inside a FCMP function

KachiM — Thu, 31 Jan 2019 11:29:28 GMT

Billa:

Your Two Questions:

1. Can I use Call Sortn() function in the Proc FCMP ?

call sortn(of array_mult_zero_coupon[*]);
ERROR: Argument number 1 to the CALL subroutine SORTN must be a variable.

2. Does anyone could give a example of how to sort an multidimensional/matrix array without call sort?

===========================

[1] Call SORTN() does not work in FCMP Environment. I confirm that I got the same ERROR as you have got. The OF operator within Call SORTN() is not working. So, sorting array within FCMP function has to depend on an external sorting routine. Paul Dorfman gave a Quicksort Macro which can be adapted.

[2] I can provide an example. Do you want sorting on ALL Rows or Columns of the Data Set ? Or on a given Row / Column ? If you specify your requirements, I can give you a FCMP function example using a FCMP Sorting Routine.

Best regards,

DataSP