Understood, thank you. I don't think, I'll store huge files on this resource, probably only local tasks, which I am doing when being staying at home because of COVID. ... View more

Sorry for the absence, thanks for all, many answers are significant for me. Big THX! ... View more

@Kurt_Bremser @BrunoMueller    Thank you, understood. I do not have access to the Oracle DBMS, I think that I should use macro variables, but it seems that 65,534 characters will not be enough. Therefore, I will have to make an array of macro variables, the length of which will depend on the number of elements and characters in the table 'temp' from the example above. I'm right?   proc sql; create table temp as select ID from have where <conditions>; quit;   ... View more

@Ksharp Thank you, this procedure works fast, I think I have to somehow attach the other columns of the main table to it.   @Kurt_Bremser Thank you, I will think how to adapt your solution to my task, I will return with feedback.   @BrunoMueller I think that is my fault, sorry, I should have said this at the beginning. The small table is local, the large table is coming from the external Oracle DBMS - it is not being held in SAS, tables in Library are links. ... View more

@Shmuel  Thank you, I've done this thing with copying ID's in one table(and of course checked it), but query still works long time. (not even finished yet) I wonder what is the difference between this subquery and the data written in the code in EG.. ... View more

@s_lassen  Thank you very much, but unfortunately your code is not working properly. Maybe that is my fault, but I am getting errors while compiling it and  cannot understand what I am doing wrong. I'm sorry..   @yabwon  Thank you very much, i've resend your code to my colleguaes(people, which asked me about this problem), they transmitted big thanks to you. ... View more

@FreelanceReinh  wrote: Ideally, the accepted solution should work not only for your current data, but also for similar data which later readers (or yourself or later users of your program) might apply it to. If the proposed methods were combined in one post, I would choose it, but useful information is split between many posts of the thread..  I can't judge about later users, but for me almost every post in this thread is useful 🙂 @FreelanceReinh  wrote: No, only N and n are the same. _n_ (=_N_) is an automatic variable (see documentation) in every DATA step. It counts DATA step iterations (but can also be used for other purposes by programmers who know what they're doing) and is dropped automatically. It must not be confused with a variable _N, which a user may create like any other variable (such as X, n, testvar1, _foo, etc.).   Understood, thank you. ... View more

Big thanks to Everyone. When wryting the topic I did not expect to get such detailed response.   Several answers are solutions to my problem, and I am a little confused which one I should mark as a solution.   I think it might be fair to choose the @hashman's approach but solutions of @PGStats @ChrisNZ @FreelanceReinh also give correct results on my data.   The only-SQL approach of @PGStats looks very smart, thanks a lot for it - I didn’t think that SQL could solve this issue so elegantly.   __ Looking at the code I have one simple question. Inside the code some of you use an underscore near the variables (the “_” character). The purpose of this is to increase code readability, am I right? From the SAS compiler's point the variables "N" and "_N", "n" and "_n_" are the same, right? ... View more

@FreelanceReinh you took it correct, thank you. ... View more

Values in 'name' field are looped chains. If sequence of the elements is different, we have different chains. Under numbers 3, 4, 5 there is the same sequence of the elements with different starting point; the chain is the same - so we are having duplicates. ... View more