topic Re: BY variables are not properly sorted on data set in SAS Programming

BY variables are not properly sorted on data set

qwerty12 — Fri, 24 Feb 2023 14:19:58 GMT

can anyone help me out in this

Re: BY variables are not properly sorted on data set

ChrisHemedinger — Fri, 24 Feb 2023 14:26:31 GMT

What type of library is PHW2022?

Your PROC SORT attempts to sort the data "in place", which means the output of the sort step will replace the table your are sorting. I recommend that you specify an OUT= table instead (if you can) to create a separate sorted table.

If your source library is a database (not a SAS data set), then the sort step may not be necessary and certainly isn't the same as a standard SAS data set file.

Re: BY variables are not properly sorted on data set

Quentin — Fri, 24 Feb 2023 14:28:44 GMT

I don't think you can get that error from PROC SORT.

Read your log carefully and make sure that your sorted the dataset you intend to sort, and that the BY statement lists the variables in the same order as the BY statement of your data step that reads the data.

If you can post the full log showing the PROC SORT step and the step that generates the error, people will be able to help more.

Re: BY variables are not properly sorted on data set

Kurt_Bremser — Fri, 24 Feb 2023 14:54:52 GMT

PROC SORT cannot cause this ERROR, as its purpose is always to sort an unsorted dataset.

Please post your complete log (all code and messages) from PROC SORT to the occurrence of the ERROR by copy/pasting the log text into a window opened with this button:

Do NOT post code, logs or data as pictures. ALWAYS post text which we can copy into our SAS environment.

Re: BY variables are not properly sorted on data set

ballardw — Fri, 24 Feb 2023 15:27:24 GMT

What code did you execute between that sort and the step that caused that error? A very likely cause of this error is a step between the sort and the code you ran that actually generated the error. Or opening the set in a table view and sorting interactively.

Please don't show pictures of code or log. Copy the text from the editor or log window, open a text box on the forum using the </> icon and paste the text.

If we need to make substantial changes to your code to fix a problem then it is much easier if we can edit text. If we have to retype code the longer it is the more likely you won't get a working solution from pictures.