topic SORT in SAS Programming

SORT

Thalitacosta — Mon, 21 Mar 2022 16:45:52 GMT

How to sort the variable "rating" so that the value "AA" is first than "A"? Because my results are coming out like this:

A01

A02
A03

AA01

AA02
AA03
B01
B02
B03
C01
C02
C03

CODE:

proc sql;

create table resul_perf as select

date,

varl,

qtde_def,

case when def = 1 then sum(qtde_def)-qtde_def end as qtde_good,

sum(qtde_def) as qtde_total

from perf

group by DATE,variavel

having def = 1;

run;

Re: SORT

Thalitacosta — Mon, 21 Mar 2022 16:47:14 GMT

rating = varl

Re: SORT

Thalitacosta — Mon, 21 Mar 2022 16:48:28 GMT

variável = varl

SORT

Thalitacosta — Mon, 21 Mar 2022 17:26:36 GMT

How to sort the variable "rating" so that the value "AA" is first than "A"? Because my results are coming out like this:

A01

A02
A03

AA01

AA02
AA03
B01
B02
B03
C01
C02
C03

CODE:

proc sql;

create table resul_perf as select

date,

rating as varl,

qtde_def,

case when def = 1 then sum(qtde_def)-qtde_def end as qtde_good,

sum(qtde_def) as qtde_total

from perf

group by date,varl

having def = 1;

run;

Re: SORT

Kurt_Bremser — Mon, 21 Mar 2022 17:41:52 GMT

Please do not double-post.

Re: SORT

Patrick — Tue, 22 Mar 2022 12:02:29 GMT

@Thalitacosta WHY do you want to sort this way?

In the collating sequence digits come before characters and though A0 comes before AA. This is not only with SAS the case - like copy/paste your codes into Excel and sort there. You will get the same result.

I'm sure with a bit of effort some code could be written to arrange the data the way you have in mind. But why would you do that given that "nothing else" would sort the data this way.