sortedby variable in proc dataset method

[BrahmanandaRao]

data ds;
set sashelp.class;
run;

proc datasets library=WORK;
modify ds (sortedby=Sex);
/*rename sex =Gender ;*/

quit;

I want to sortedby in proc datasets method

[Kurt_Bremser]

You already have the code, so what is the question?

[BrahmanandaRao]

My dataset sex variable not sorted

[Kurt_Bremser]

To actually sort the dataset, you need PROC SORT or ORDER BY in SQL.

[BrahmanandaRao]

 I am trying proc datasets 

proc datasets method can sort the observations particular variables

[Kurt_Bremser · Accepted solution]

PROC DATASETS does not sort, for this you need the tools I mentioned.

[BrahmanandaRao]

Anandkvn_0-1646290975564.png

[Kurt_Bremser]

You only set a metadata attribute in the dataset, but actually sorting is up to you.