union of tables with fields in different formats in one iteration

[Denis]

Hi, Haikuo!

no, you aren't late, you're just in time.

Patric's approach works fine with limited number of additional fields in tables, cats function has limit of length of 200 bytes.

Log, trying to put additional fields under keep:

WARNING: The quoted string currently being processed has become more than 262 characters long. You might have unbalanced quotation marks.

WARNING: In a call to the CATS function, the buffer allocated for the result was not long enough to contain the concatenation of all the arguments. The correct result would contain 394 characters, but the actual result might either be truncated to 200 character(s) or be completely blank, depending on the calling environment. The following note indicates the left-most argument that caused truncation.

Notwithstanding that’s strange, ‘cause

„The value that is returned from the CATS function has the following length:

• up to 32767 characters in the DATA step except in WHERE clauses ”

So, your approach, Haikuo fits best for me!

Thank you!