topic Re: PROC SORT not working in New SAS User

PROC SORT not working

sjbothwell — Tue, 03 Nov 2020 23:34:05 GMT

Hi!

I am trying to sort data by Subject_ID (primary) and Lab_Date. When I run the following code the data doesn't appear to be sorted :

PROC SORT DATA = WORK.Laboratory_2015;
BY Subject_ID Lab_Date;
RUN;

My data looks like this :

Re: PROC SORT not working

SASKiwi — Tue, 03 Nov 2020 23:37:56 GMT

Please post the SAS log of your PROC SORT.

Re: PROC SORT not working

novinosrin — Tue, 03 Nov 2020 23:39:57 GMT

Hi @sjbothwell That seems strange. Can you try writing the sorted contents to new dataset and compare-

PROC SORT DATA = WORK.Laboratory_2015 out=sorted_lab_2015;
      BY Subject_ID Lab_Date;
RUN;

Please open both sorted_lab_2015 and WORK.Laboratory_2015 and eyeball

Re: PROC SORT not working

sjbothwell — Tue, 03 Nov 2020 23:43:27 GMT

My initial code was

PROC SORT DATA = CanImpt.Laboratory_2015;
BY Subject_ID Lab_Date;
RUN;

Where CanImpt was a file path on my computer and the log gave this error

ERROR: You cannot open CANIMPT.LABORATORY_2015.DATA for output access with member-level control because CANIMPT.LABORATORY_2015.DATA is in use by you in resource environment SORT.

I changed CanImpt to WORK for the post but just realized that by using

DATA WORK.Laboratory_2015;
SET CanImpt.Laboratory_2015;
RUN;

and then sorting off of WORK.Laboratory_2015 works. Why do I need a temporary dataset? Or is there a better method?

Re: PROC SORT not working

ballardw — Tue, 03 Nov 2020 23:44:24 GMT

The result looks like you actually ran at some point:

PROC SORT DATA = WORK.Laboratory_2015;
BY Lab_Date Subject_ID;
RUN;

If you did sort this way and the data set was open for some reason then a different sort may not have been done.

Re: PROC SORT not working

sjbothwell — Tue, 03 Nov 2020 23:44:53 GMT

That worked thank you!

Re: PROC SORT not working

SASKiwi — Tue, 03 Nov 2020 23:54:04 GMT

@sjbothwell - Looks like you have a process already locking your permanent dataset so you can't overwrite it. Try closing your SAS session, reopen it and try the sort again.

Re: PROC SORT not working

sjbothwell — Tue, 03 Nov 2020 23:59:18 GMT

That did the trick - thank you!

Re: PROC SORT not working

Deanna_Payne — Wed, 04 Nov 2020 03:37:41 GMT

Like the earlier commenters, double check the datasets you are referencing and make sure that they work in your log and are correctly named.

I didn't see if you named the dataset into your log (Make sure you are not missing something like this):

DATA WORK.LABORATORY_2015;
SET CANIMPT.LABORATORY_2015;
RUN;

Then run the proc sort statement:

PROC SORT DATA = WORK.LABORATORY_2015;
BY SUBJECT_ID LAB_DATE;
RUN;

But if that is still not working you can achieve the same grouping result in a different way:

PROC PRINT DATA = WORK.LABORATORY_2015;
BY SUBJECT_ID LAB_DATE;
RUN;

While this method isn't great for large datasets with a lot of unique variables of Subject_ID, Lab_Date, it is good for seeing trends in a more bitesized way.

Hope this helps