I just want to add that in a real life situation you wouldn't do this mass merge.  It is fraught with unseen dangers, such as variables being in different tables, different types, many to many merges etc.  Normally you should know your data well, and be able to pick out data items only when needed. ... View more

The basic step would look like: data teradata.target;: merge ds1 ds2 .... dsN ; by week; run; which will put all variables side-by-side (week will appear only once, of course). Depending on the name structure of your existing datasets, you will either have the option of using dataset lists (Mergin with Dataset Lists), or you might have to use a macro to insert the list of dataset names in the merge statement. ... View more