BookmarkSubscribeRSS Feed
0 Likes

(edited)

 

I learned the concept of collating in computer science classes, yet SAS help uses the word "interleave".  Nothing wrong with this, but for me and others that learned "collate" rather than "interleave" it would be nice to include this word in the help file, I think.  My ideal edit to the help file would be:

 

Example 2: Interleaving SAS Data Sets

 

To interleave, or collate, two or more SAS data sets, use a BY statement after the SET statement:

data april;
   set payable recvable;
   by account;
run;

 

Maybe, in the future, this will help someone else find this feature of the SET statement faster through a Google search for "SAS collate".

 

link: https://en.wikipedia.org/wiki/Collation

 

2 Comments
Astounding
PROC Star

If I understand what you are asking for, SAS does this already.  All you need to do is change COLLATE to SET.  Keep the BY statement in place and see if that does what you are seeking to do.

PhilC
Rhodochrosite | Level 12

Astounding, https://communities.sas.com/t5/user/viewprofilepage/user-id/4954

 

wow, you're right... "...learn something new..."  thanks