topic Re: order of data sets that appear in window in SAS Programming

order of data sets that appear in window

Ronein — Mon, 08 Dec 2025 09:27:09 GMT

Hello

I run code that create data sets in following order.

Why the data sets appear in different order then order they were created?

%let h1=2508; /**YYMM structure**/
%let h2=2507;
%let h3=2506;
%let h4=2505;
%let h5=2504;
%let h6=2503;


%macro Help_Macro_a;
%do j=2 %to 6; 
proc sql;
create table _L_CS_&&h&j. as
select b.lakoach_y as lakoach_Y&h1.,a.*
from L_CS_&&h&j.(Rename=(lakoach_y=lakoach_y_&&h&j.))  as a
inner join L_CS_&h1. as b
on a.lakoach=b.lakoach
;
quit;
%end;
%mend Help_Macro_a;
%Help_Macro_a

Re: order of data sets that appear in window

Kathryn_SAS — Mon, 08 Dec 2025 16:48:38 GMT

I am not replicating what you are showing. Can you send the log with the following options turned on:

options mprint mlogic symbolgen;

Re: order of data sets that appear in window

Ronein — Tue, 09 Dec 2025 02:14:44 GMT

My question was- if you look at do loop then the order in which data?sets are created is-2507
2506
2505
2504
2503.
But when look at output screen can see 5 data sets thst were created but the order of then different.

Re: order of data sets that appear in window

Kathryn_SAS — Tue, 09 Dec 2025 12:30:32 GMT

I understand what you describe and what you show is not the correct order. However, when I run your code with sample data, I get the expected order. I have included my screenshot. Please include your SAS log with the options requested and clarify where you are running the code and which version.

Re: order of data sets that appear in window

andreas_lds — Tue, 09 Dec 2025 12:54:43 GMT

Can replicate your problem with EG 8.5 or 8.6 - maybe a problem with an older version or with some option set in EG itself.

Re: order of data sets that appear in window

Tom — Tue, 09 Dec 2025 14:19:45 GMT

You need to state what GUI interface you are using that is captured in your picture.

One of the responses is guessing it is Enterprise Guide.

Re: order of data sets that appear in window

andreas_lds — Wed, 10 Dec 2025 07:20:26 GMT

Two chars are missing in my previous post:

Can't replicate your problem with EG 8.5 or 8.6 - maybe a problem with an older version or with some option set in EG itself.