@ballardw    It works and it is close, Thank you! Could you say is it possible to improve your code according to my second example? - groups {3;4;5} and {10;11;12} should differ. ... View more

@ballardw  Thank you, I am checking     @Reeza   Does it have to be an exact match? Yes, exact match using parallel shift(can't catch how better to say). 3891.281.3891 would it still be a duplicate? Value '3891.281.281.3891' and value '3891.281.3891.282' will not be dupllicates.   Perhars in start message there was placed not very good example.. groups {3;4;5} and {10;11;12} are different   proc sql; create table tmp (num int, name char(200)); insert into tmp values (1,'281.3891.3891.281') values (2,'3891.281.281.3891') values (3,'1162.5645.5645.500835.500835.1162') values (4,'5645.500835.500835.1162.1162.5645') values (5,'500835.1162.1162.5645.5645.500835') values (6,'1349.1162.1162.5645.5645.500835.500835.1349') values (7,'1162.5645.5645.500835.500835.1349.1349.1162') values (8,'5645.500835.500835.1349.1349.1162.1162.5645') values (9,'500835.1349.1349.1162.1162.5645.5645.500835') values (10,'5645.1162.1162.500835.500835.5645') values (11,'1162.500835.500835.5645.5645.1162') values (12,'500835.5645.5645.1162.1162.500835'); quit;   p.s. While writing I am trying to do my best, but seems my English is rather unclear.. I am very Sorry for it.. ... View more

@SASKiwi  Thanky you, understood. Hoped there might be another solution.. ... View more

@Patrick    About: If you have to care about performance then don't issue a select count(*) against SAS tables as there the row count is a table attribute (nlobs) which you can retrieve directly from the descriptor (metadata) part of the table.   I have missing values in all descritor parts..   Previosly you wrote: Tables from libraries that point to databases will have a missing value for the row count because that's not a table attribute of database tables (like it is for SAS tables). I think that is my case, so I have to calculate metadata for several libraries consisting of ~500 tables manually.. but this will be another topic I think. I think during September I will write a code being based on your and Tom's solution. I also think I will post it for information and will make a link on this discussion.   One more time:  Big THX for Everyone, I am closing the topic. ... View more

I am back 🙂 I bring apologies to everyone, I was terribly busy last week. I really appreciate any help, please do not try to see disrespect in my disappearance.   @Tom  Thank you, understood, that is exactly what I was trying to do. The idea with writing code instead of macro is very smart, I haven't seen this ever before 🙂 Thank you.   @PaigeMiller  Thats is very fine that we understood each other. Thank you for your advices.   @Patrick  Thank you very much for your feedback. In general, I understood your code and in the first approximation I don't have any questions about it. I think on the next step I will try to combine your approach, Tom's approach and some my thoughts.   In my opinion, Tom's code is more consistent with the originally stated topic, it might be better to choose it as a solution. Please tell me, if I create another topic like Calculation of approximate Library size (which points to databases - tables have missing values of the sizes and rows counts) , could you copy your post into it? (this could be done to save important information - so that other members of the SAS Community could more easily find and maybe use it if there will be a need.) ... View more

No macros are needed. The data is there for your use in SASHELP.VTABLE Sorry, but it seems you don't listen to me.. This table is useful, thank you for the link, but it doesn't have the data, which I need. Values in columns "nobs" and "filesize" are missing - emptiness inside. The only library which has tables(rows in SASHELP.VTABLE), being filled with "obs" and "filesize" values is SASHELP ... View more

@PaigeMiller  Yes, they do have dictionary tables, it's the same table I mentioned SASHELP..VTABLE. Understood, I see them, thank you. So there's no need for any macro code to do any of your steps. Unfortunatelly I don't have columns "nobs" and "filesize" filled with values, so I think I have to calculate them manually. No, in my opinion, that's not a fair question. You need to try to do it yourself, and if you get stuck, show us your code/log and we can help you from there. I completely agree. Next time I will try to make my head question shorter. Concerning this topic - maybe one macro variable and one dataset could be enough to mark my problem (without sashelp tables and %macro)      @Patrick  I am very thankful for you for your concern. I will very attentivly study it today and mabe tomorrow and give you reply. Thank you. ... View more

@Patrick  SAS adds all tables of all libraries that you've got assigned in a SAS session to the SAS dictionary tables. These SAS dictionary tables are also accessible via views under library SASHELP. Thank you, I see, that is very convenient. Tables from libraries that point to databases will have a missing value for the row count Unfortunately that is my case. So I have to calculate some parameters myself.. If you clearly specify what you want to achieve then I'm sure people here will be able to give you a lot of guidance. Speaking in terms of SASHELP.VTABLE I want to have filled with values columns 1. "nobs" 2. "filezise" (approximately, tables are very big) for libraries that point to databases - that is my final goal.   But I dont know, will it be fair if I'll ask you to do whole task for me? The subject in topic is narrower.. ... View more

@PaigeMiller ,   Thank you, you are right, the final goal is to make a dictionary table for each library. SASHELP is a well-done library, it has dictionary tables.. other libraries I have dont have dictionaries. > 1/ so on the first step I want to calculate the number of observation and to put it in the dictionary table > 2/ on the next step I will try to calculate the size 10 observations of each table and to put them in the dictinary table > 3/ on the next step having 10obsSize and TotalObsCount I will try to calculate approximate full size of the table   2 and 3 steps are not the case of this topic, I will think and I hope after I'll be able to do them myself.. but I can't catch how I could technically put data, being contained in macro variable to existing dataset ... View more

@Reeza  when you're writing macros make sure to use the proper debugging options so that your log has enough information for you to see what's going on: options mprint symbolgen; MLOGIC is another option that can be useful when things aren't working well, but I also find it can really clutter up your log.   Thank you, I will study these options.   ... View more

It works! Thank you much, Reeza!   ... View more

Sorry, you mean because of presence the data in datastep without quotes it cannot being used in macro variables, right?   Or it is possible to somehow add quotes to each element in macro variable? ... View more