topic Re: sortedby variable in proc dataset method in SAS Programming

sortedby variable in proc dataset method

BrahmanandaRao — Thu, 03 Mar 2022 06:14:11 GMT

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 — Thu, 03 Mar 2022 06:35:10 GMT

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

BrahmanandaRao — Thu, 03 Mar 2022 06:39:51 GMT

My dataset sex variable not sorted

Kurt_Bremser — Thu, 03 Mar 2022 06:50:14 GMT

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

BrahmanandaRao — Thu, 03 Mar 2022 06:51:48 GMT

I am trying proc datasets

proc datasets method can sort the observations particular variables

Kurt_Bremser — Thu, 03 Mar 2022 06:53:19 GMT

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

BrahmanandaRao — Thu, 03 Mar 2022 07:03:13 GMT

Kurt_Bremser — Thu, 03 Mar 2022 07:13:19 GMT

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